A SQL Server is a complex database environment that needs iterative analysis and constant tweaking to ensure its continual, optimal operation. This requires routine "health checks." What criteria ...

SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...

Disk access in Azure sucks. I need to gather useful data to show people that it sucks, because I don't think people will believe me until a customer is on the phone and pissed off. Is resource monitor ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...