dbta

SQL Performance Testing and DevOps

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

A Deep Dive into SQL Server 2022's Query Performance Features, Part 1

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...
Redmond Magazine

SQL Server Speed Test: Azure Beats AWS

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

SQL Server Migration Assistant v8.19 Now Automates Testing

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

Comparing cursor vs. WHILE loop performance in SQL Server 2008

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...