A comparison of SQL Server's throughput performance on Microsoft Azure and Amazon Web Services (AWS) gives the edge to Microsoft's cloud. "Azure emerged as the clear leader across both Windows and ...

Anyone have any ideas about how to simulate real-world scenarios in a dev environment? Specifically regarding SQL Server. To get a good picture of real-world performance behaviors (locking, blocking ...

As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

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

Due to my background working with other major database platforms such as Oracle, MySQL, and PostgreSQL, I’ve long been an advocate for the SQL Server Migration Assistant (SSMA). This powerful and easy ...

This month’s collection of fixes from Microsoft includes 86 patches — but at least there were no zero-day bugs.