Being an introvert at a conference is exhausting. Utterly and completely.

And totally worth it.

No one believes me when I say I'm an introvert because I'm always up on stage, running...

Johan, did you try doing sni_trace? That is an event, in the debug channel. I guess I somehow missed that on the first read through.

I don't have the setup handy...

Trying doing it without compressing it. Backups are compressed by default ever since... 2014?... and zipping or tar or whatever, can affect the files.

I've worked on SQL Server databases for 30 years now. I've written multiple books on the topic of query tuning. I want to lead in with that because the next...

If, and this is a big one, there are zero data types, indexes, settings on any of those, that are incompatible between versions, this will not work.

What you can try...

Thank you for the cautions, Grant.

I always develop xEvents related stuff on my local box, then on a dev box, then on a QA box and only then ....

As...

You beat me to to use of phone iconography. It's not just cell phones though. We have "desk phones" in the form of VOIP on our PCs. There's no...

Hey Johan! I don't think debug_channel is an event. There is a Debug Channel in Extended Events, but it's a grouping of the events that are undocumented, minimally documented, and...

Just to be clear, nothing in a derived table, in and of itself, is necessarily a problem for the optimizer, resulting in poor performance. It's the specific implementation of your...

To a very large degree, a VM is a VM. If it's running locally, Azure, AWS, Google Cloud, doesn't matter. Yes, there are SQL Server configured VMs to pull from....

It does sound like your login doesn't have access. Might be time to reinstall. If you picked Windows auth only and didn't add your login appropriately, getting in to this...

Ah, I do miss those parties.

Also, if a lot of code is generated, then the process of literally learning how to write that code is also going to be curtailed. Getting from junior to senior,...

Grant is right about the benefits of having interests outside of work and family.  I am a member of the Tadley Men's Shed, and enjoy a lot of the...

There is an organization in town that runs a...