Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run, asking devs to...

Presumably, that means a lot of Extended Events sessions outputing to the ring_buffers. Probably not the best way to go. Output to file is generally better. But, it does depend...

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