There are lists of exceptions to this as long as... well, very long. However, as a general rule, pick the clustered index based on the most frequently used path to...

There isn't a single true path through this.

Generally, a database gets one storage location. Depending on the tools I'm using (I work for Redgate, so Flyway is the tool of...

That's what I get for not using the GUI for backups.

This occurs when the logins have different IDs between servers. Here's an article that discusses dealing with this.

I'm not sure why it went wonky Rod. A restore of a full backup shouldn't be doing tail log backups, successful or otherwise. Something odd going on. Did you use...

I've always found attending conferences to be valuable. I've learned lots at the conferences I've attended and have made life-long friends.

Which is why it is strange that...

I've always found attending conferences to be valuable. I've learned lots at the conferences I've attended and have made life-long friends.

Which is why it is strange that my current...

In my 42 years in IT with most of it as a DBA I never got to go to a conference.  The closest was a very few meetings with...

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...