Read this to my daughter, who I brought up watching the show, she wants to know which episode it was? Thanks Runa.

Who are you? What do you want? Do you have anything worth living for?

When Babylon 5 was in its second season, I attended a Science Fiction convention in Ohio...

Yeah, Kevin is great at this stuff too.

It is an older book, but this one by Itzik Ben-Gan is simply one of the best for learning T-SQL.

You can sit in the back. Won't matter. Buck will spot...

You...

Cheers!

Very kind of you to say. Could you share it with my boss? Ha!

I clearly have biases. When I'm not talking about a pure, non-Redgate, topic, in short, stuff that can be construed as marketing or sales, I just try to be incredibly...

Ooh, I would not solve this by going to VARCHAR(MAX). That could cause all sorts of performance problems. If you really have to go through this exercise, the answer is...

It can't be turned on with the secondary in 2019 or less (2022 only). When the primary fails over, it will have Query Store and the last good plan enabled...

The suspended state just means it's a connection waiting for a query to run. It's not actively using resources (well, a tiny amount of memory maintaining the connection). Did you...

Nah, you can turn off whatever you want. You'll lose some pretty sophisticated SQL Injection protection and a few other things.

I was referencing Query Store and ExEvents as a way...

Then walk through all other roles and groups that the login is associated with. Something has gone south.

Not much data to go on, but that looks like a pretty benign thing. It's had 3 seconds of waits over however long it's been connected (can't see that in...

Also, you sometimes see this kind of thing when thresholds are crossed such that the row counts change and different execution plans get generated. Over time, statistics and data distribution...