Just piling on. I think @Ant-Green has nailed it. Availability Groups are where Microsoft has been investing all it's time and money. So if you're going to be building an...

Just piling on. I think @Ant-Green has nailed it. Availability Groups are where Microsoft has been investing all it's time and money. So if you're going to be building an...

I'm confused. What is this in relation to?

And very much still is.

Excellent! Thanks again. Glad you got it all figured out.

Ah, sorry I misunderstood.

If they were switched to read only on you, it's likely something to do with size and the cleanup management. The size-based cleanup should be a backup...

So, SQL Server is time-tested and extremely reliable. It simply does not randomly provide values based on whims or anything like that. It is ALWAYS down to the code, structures,...

Mirrored databases can't be written to, right? If so, then I'm pretty sure Query Store won't work on a mirrored database. Same as AG. It doesn't work there either (except...

Cool! Can you detail a little more for the person who has the same question as you so that they can see the answer too?

Looks like a monitoring query. It's probably being run from a monitoring tool. I've no idea how to tell you when it will next be executed. I'd suggest you use...

Microsoft has a couple of good examples. I'd strongly suggest you use option 2.

But!!!

The bigger question is, how did that happen in the first place? Cleaning it up is...

Share a little history, the compare engine in Visual Studio was licensed from Redgate years ago. Now, we've been tuning our engine since then. I don't think Microsoft has shown...

ddltbl

I promise, you'll never guess what that means. Never, ever, never. It was part of a naming standard at my old company that I raged against until it went away....

So, probably not going to have a single book that explains "each topic in full depth".

I have two books that I've written, totaling about 1,300 pages between the two of...

It can be a weird line here.

At my previous job, we were moving our entire data center from one building to another. As part of it, we wanted to, just...