« first day (4273 days earlier)      last day (894 days later) » 

03:45
Yeah saw that 😂
 
2 hours later…
05:58
Morning
 
1 hour later…
07:20
morning
08:09
A chairde - Morning all!
 
1 hour later…
09:33
morning
 
3 hours later…
12:20
🌕
13:05
@ErikDarling I was offered a position on Tim's team but ultimately stayed in SQL. I worked with Jason on many different SQL+Windows items, he's a great guy, super smart, Tim is as well! Haha my old role right there.
I thought about seeing if there were openings on Jason's team but I wasn't sure I wanted to do more Windows stuff or not... I probably should have.
13:20
is it too late?
i know how much you hate perf stuff, heh
It's never too late, but I promised Jack I'd stay at least for 1 year
I do enjoy the OS site immensely, I'm just not nearly as knowledgeable as Jason, for example.
13:42
i am rooting for you to find a better fit with sql server
i'd miss you if you went to windows
no way i'm going to the superuser chat
3
it's hard to imagine the state of on-prem SQL Server support that would make you choose cloud
i have been following the saga
aside from the obvious and public hemorrhaging of sql server people
14:08
every time. Every time I see a question or answer with pages of code and not a single statement terminator. I want to ask "What is wrong with you?"
That risks an equally long answer
what about pages of text without a single terminator
except incorrectly placed apostrophe's
would never happen
maybe in Super User chat
14:24
@PaulWhite That'd be more of a phone call item than text, but high level is terrible ranks of management making terrible decisions to the point where it's more important to make an initial email response to an incident than actually fix the issue or solve the problem. If you say anything about this, you're a customer experience denier and must be punished accordingly.
Second most important thing is to only hire people in cheap countries with no experience, give them no training, and just hope it all works out.
oh yeah i got a bunch of shit on tw when i said i wanted to see more accountability from microsoft
@ErikDarling There is absolutely none.
While this chatroom is an outlier, your everyday DBA has more knowledge than most of the people in on-prem support right now.
When I left, 70% of all people in that org had less than 1 year of total experience with SQL.
I forget what the average was, something like 1.8 years
Median was like 8 months
The only reason the average is so high is that we have/had a few people on the team that have been there since 2000.
I think we have two people with 30+ years.
and you'll never get to talk to them, heh
14:42
I don't think I've seen you say "horseshit" on tweeter before
i say it all the time
horseshit and nonsense
maybe i should add poppycock
it's very colourful
balderdash
bilge
ooh, bilge
crudwollops
15:01
bollocks @ConcernedOfTunbridgeWells would add
wishy washy washer woman
so what's everyone up to this weekend
having a great one i hope
Have a bunch of Bday plans that were killed due to a death, so it's already been a good time.
:(
killed by death
16:09
I don't get this
-2
Q: There is a way fo filter out from extended events query parse events?

MBuschiI'm currently using extended event to capture query statement executed on production environment. But the actual session is capturnig also the activity of 'query parsing' dome by operators to evaluate if a query is well written. I would like to modify extended events in a way to filter out SSMS a...

no one does, that's why it has two downvotes and is closed and locked
It's not like it's a new contributor though
no but he works for lucient which means his brain has a maximum of three wrinkles
lmfao
still no email with dump link
maybe it got quarantined
"hey sean here's the dump i took for you"
"i hope this dump isn't too big for you"
16:22
@ErikDarling Isn't Luciente the company that Itzik started?
i have no idea
that isn't who he works for though
unless itzik quietly started a global consulting firm
16:43
@ErikDarling tsql.lucient.com?
> Itzik Ben-Gan is a T-SQL Trainer and Co-Founder of Lucient.
wild
why have i only ever run into dummies from that company
I'm not 100% on the history but weren't they originally named SolidQ or something
i remember soldi q
Well, that Q up there definitely wasn't solid.
16:50
it's a thing apparently - drinkhiyo.com
How to clarify better this question: "there is a way to filter out from extended event query parsing activity"? No way. You know how to do it or not. — MBuschi 2 hours ago
tell him to ask his boss
Attitude often helps
Yoda would be proud
2
I wouldn't mind, but their first reaction to having the question downvoted and closed was to re-ask it
16:52
you know or you don't paul
iykyk
then I guess I don't 😀
It's a bold strategy, Cotton. Let's see if it pays off for him.
exactly
my advice is never to attempt a quadruple Axel on thin ice
if things go wrong, something might get frozen for a while
iykwim
snow balls
16:59
I moved south to never have snowballs again
Albeit not as far south as Paul...
he went so far south he went north again
perils of balls
 
2 hours later…
18:34
this doesn't deserve downvotes
-1
A: Allow multiple rows to have same X value only if also same Y value?

CharliefaceYou need to normalize your tables. Clearly, url has a many-one relationship to owner, so it should go in its own table. CREATE TABLE url ( url text NOT NULL PRIMARY KEY, owner_id bigint NOT NULL REFERENCES owner (id) ); CREATE TABLE links ( id bigint NOT NULL PRIMARY KEY, url tex...

owner_id bigint NOT NULL REFERENCES owner (id)
I don't see an owner table?
I guess he assumes there is one
It was there in the original answer (revision 1)
Yes I saw, thanks
I am reminded of the epic debate over how to name id columns
Exclusion constraints are a blessing and a curse
18:45
@PaulWhite nearly as bad as where to put commas
I didn't expect to hear from you for a while after yesterday's performance
/slinks away
ha ha ha
I wonder what regression causes that to prevent shutdown in 2019 but not in 2017
brain drain/summer interns
18:48
seems likely
there does seem to be a general feeling 2019 is lower quality than 2017
but SQL Server is a huge complex product, so these things happen
one can only imagine the possible set of unintended consequences in making changes to code
code was a mistake, clearly
someone makes a well-intentioned, well-tested, obviously good change somewhere in SQLOS and silently, a million miles away in a remote corner of Service Broker, something goes bang
it's always Service Borker's fault.
remind me, it was an event notification in your case?
18:51
yes, there is a Server Event Notification that fires into a queue that is processed by SB
it should work without a timeout, just saying
also I feel about 95% certain that some version of SQL Server (prior to 2014 perhaps) didn't issue automatic checkpoints on service shutdown.
I'm pretty sure that's always been the case
but perhaps I'm wrong. Again.
There might've been one way of shutting down SQL Server that didn't, aside from CTRL+C when started from a command prompt, but I don't remember it if so
running SQL Server from the command prompt is the only way I can get it to run on my work laptop.
18:55
even though I have local Administrator access, there is a group policy that determines who can run as a service
work laptops are stupid
it's interesting to see it run that way though so I don't mind
I'd leave mine at work on general principle
my work locale is about 6 feet under my living room
six feet under sounds right for it
18:57
apropos
Hoowee 🔥🔥🔥
Erik prefers 2019 to 2017
Generates more invoices
gotta invoice 'em all.
^^^ Erik's version of Pokemon
I don't think there is a regression, I think that's always how it's been for whatever case this happens to fall under, hence why it doesn't happen everywhere.
My guess based on the dump is that this exists in all current versions
So it not happening on the 2017 instance is user error?
Hard to believe in this case
Assuming "current versions" means "currently supported versions"
Though I suppose anything's possible for someone prepared to run unauthorized software on their work laptop
Via hax
19:12
I did some cursory checking this morning to see if anyone else hit this type of thing and I had 1 hit from 2014. Defect was opened, closed because it didn't meet the bar for fixing.
Have you tried writing set-based code
Cursors all the way, love me some RBAR
You really do belong on the Windows team
:D
I clearly don't belong on the kusto team
I might end up on the cosmos db team, eventually
no me kusto
19:14
depends on their consistency
you should try for Azure SQL Edge
I hear that's very popular
And you could be their Edge Lord
2
They're a little to edgy for me, like asymmetric haircuts
 
2 hours later…
21:10
You could start consulting and end up on the costmost team.
21:44
💰💰💰
22:14
Like Paul here
22:49
@PaulWhite especially considering the source #amiright ?
if you're the source how can you be right
this is impossible
@SeanGallardy-MostlyRetired is there some way I could prove it doesn't (or does, perhaps) happen on 2017? Is that P≠NP
@ErikDarling this was my assumption out of the gate
OPs gonna OP
@ErikDarling like using markdown in comments on your blog, apparently.
23:31
Paul can figure it out

« first day (4273 days earlier)      last day (894 days later) »