Strong suggestion, don't store the response time. Store the start and stop times and then calculate the response times when you retrieve the data.

That's a convoluted way to go about a data transfer. Why do you have to use XML? Why do you have to use triggers? SQL Server has built in mechanisms...

So you think that's one ugly dude too.

yeah, on the one hand, they make it easy. On the other hand, which damned one is best? I'm not sure there's a perfect answer.

There are like 20 different scheduling tools in Azure. Pick one. Any one. Use that.

Learn how to do this through T-SQL. It's vastly superior, and ultimately, believe it or not, much easier.

It's going to be really hard for us to troubleshoot through screen shots....

That dude in the vest is seriously ugly.

I've spent the last 20 months doing online events. On one level, they're helping people who couldn't/wouldn't ever attend in-person events, which is...

Try to see if you can export the data, not back it up. Chances are you won't be able to, but try. And, if you get an error, read it...

Man, that's asking for trouble, but...

You just need to use sp_executesql. Query the table to get the string. Load that into a variable. Follow the link to see how...

Just Sp3. No need to do the others. They are cumulative.

Before you partition, you need to know, that if you get partition scans, performance will be worse than before you partitioned. So, when partitioning, we should only do it, if...

There is a HUGE difference between Managed Instance and Azure SQL Database. So, as everyone has pointed out, if you're in Azure SQL Database, the standard three-part multi-database queries will...

The Service Packs and the Cumulative Updates are, as the name says, Cumulative. They include all previous stuff. While there can be exceptions if you need a particular security patch...

There is actually quite a bit of overlap between those two books. However, the Fundamentals book goes much slower in explaining SQL concepts as well as T-SQL specifically. Where as...

To my knowledge, discipline is your only friend here. Keep the files in a defined place. Use naming standards that help you clarify what a thing is for, then clean...