Do you know how to measure the impact on performance of your SQL changes? Do you know which parts of your stored procedures (or batch of SQL statements) you need to optimise? Both of these questions ...
Microsoft has confirmed that Windows updates released since the October 2026 Patch Tuesday are causing SQL Server performance and stability issues.
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 ...
Microsoft confirmed Windows updates since Oct 13 leave SQL Server linked server connections open to Oracle and PostgreSQL.
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 ...
This book aims to improve the performance of your SQL Server, how does it fare? Benjamin Nevarez concentrates on improving the performance of your SQL server largely from a configuration perspective, ...
As today’s database administrators (DBAs) manage the complexity of modern database environments, particularly containerized systems, they must lean into smart automation to transform database ...
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 ...
With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...
At the inception of relational database systems and into the 1980s, the only portable interface for applications was embedded SQL. At that time, there was no common function API such as a ...