As a consultant whose job description includes putting out performance fires, I get to see a lot of problematic queries that can dramatically harm overall server performance and throughput. Wondering ...

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

Just to wrap up this week’s discussion on VLDBs we need to look at the new features of SQL Server 2008 as it improves the Data Partitioning features introduced in 2005. Let’s take a look. First of all ...

The Incremental Servicing model for SQL Server continues to march on with Cumulative Update # 3 now available for SQL Server 2008. Microsoft has committed to a CU every 2 months and this strategy ...

Patch Tuesday: Microsoft Addresses 137 Vulnerabilities, Including High-Severity SQL Server RCE Your email has been sent Two SQL Server vulnerabilities raise concerns for data exposure and remote code ...