Thanks for the support on the move. A couple of notes. First, I'm not changing jobs. I love Redgate and you'll have to pry this job from my dead cold...

Going backwards is hard. There are no shortcuts. The best way is going to be to script everything out and then build data migration processes using whatever tools you're most...

Quick note regarding any 3rd party solution:

I'm game to use any of them. Show me a restore to a point in time that meets our SLA, RTO & RPO. Now...

Months of log restores? Oh no. That will be a nightmare, regardless of the failover question. Speaking of, because the secondary has the same transaction id values and will be...

Rebuilding an index updates the statistics. After updating statistics, new execution plans get created. Sounds like the stats update may have lead to a different plan with poor performance. Since...

Instead of trying to trick out how extended events works, simply expose the data collected in a different location, a file system or something. What's important is not running Extended...

If you're capturing queries, usually either rpc_completed or sql_batch_completed, you'll be getting all queries. Then just filter by the appropriate action and values to limit the queries to a particular...

To do this you're going to need to use an Action in the events you capture. Which action really depends on your system setup. You can use username, session_principal_name, nt_user_name,...

It's all Steve Jones. His idea. His execution. He deserves all the credit.

Yep. You're stuck. Either all the values are the same, then no update should occur and no change tracking needed, or, the data is inserted only, and no way to...

No arguments. Your interpretation may be right. But then, what are we trying to see here? Query performance but not queries? How then do you correlate the performance, "An unidentified...

It is possible for Extended Events to miss an event. The tool is designed so that it puts minimal load on a system. Part of that includes the ability to...

Yes!

Have you tested without the nonclustered index? If it's not used, why have it at all? And yeah, lots of inplace updates are very hard on a columnstore index. Everything...

Thank you Grant Fritchey!

1. how can we check the cache for DMVs and  how to set the cache for DMVs( or how to set the cache for different DMVs)...