The only reasons I would use XML are because I've got a metaphorical and/or technical gun held to my head. It's honestly crappy and the XPath queries within SQL Server...

Personally, either would be fine. However, AWS has a much larger market share, so it's more likely to be transferable.

It's mostly a question of training and setting up the right levels of access. While you want to empower people, I'd be cautious about giving too many, especially untrained and...

In all fairness if the commands are  coming from SSMS it's not...

If the backup takes longer than an hour, we're killing it? I mean, so much of this seems arbitrary and heavy-handed. What's the real problem?

Oof.

Well, part of it is easy & straight forward. Set up a SQL Agent job to run once an hour. You can script out the capture of long running code...

I don't think we can do that. You can absolutely filter out tables that have no differences. However, once a table has a difference, in order to show that table,...

You can also do a query against the DMVs to see what's currently in cache in terms of queries against the databases. It won't show the kind of detailed activity...

Hi.

Full disclosure, I work for Redgate. So, you can weigh everything I'm about to say.

Microsoft has a tool built into Visual Studio, so you have to have a license for...

Honestly, Azure or AWS is what I would suggest.

Are there third party things? Sure. Are they applicable to a broad enough swathe of the landscape that it's going to help...

You would need some different filtering on the waits. You can't simply correlate them through causality tracking and then only capture the related waits. Instead, you also need to filter...

Jeff. Your ears should be burning. I've had a few conversations about you & fragmentation over here in Belgium with a bunch of people. Happy to hear you've...

Jeff. Your ears should be burning. I've had a few conversations about you & fragmentation over here in Belgium with a bunch of people. Happy to hear you've stopped smoking....

It would be the standard stuff, sql_batch_complete or rpc_complete. With the batch completion event you can filter by the search string. With the rpc_complete you'll need to first identify stored...

And you, you should not be in fear for your job. Ha!

You've hit it on the head. I love this stuff. I do. However, like anything, used badly, it's going...