Testing and tuning SQL is an often-overlooked aspect of incorporating the database into your DevOps pipeline. It is important to be able to analyze and optimize SQL performance within your application ...

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

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

The Goldilocks porridge of A/B testing Amiato aims to fill that chasm with something that’s “just right” for its crowd. Amiato lets users load JSON data files or other forms of semi ...

Testing Forsa’s ability to achieve significant performance levels in SQL environments on a single mid-range server without tuning, shows that it is unmatchable by any SSD or other I/O-bound ...

More from Microsoft's lead SQL architect about how telemetry data is helping the company deliver regular, highly requested and targeted feature improvements at a massive scale.

I have been testing SQL Server 2005 SP3 CTP this week. This Beta version of SP3, which is due out for official release before the end of the year, includes all of the previous cumulative updates ...