David Pless, Author at Microsoft SQL Server Blog

Updates

Published April 1, 2024

6 min read

Provision Premium SSD v2 Storage for Microsoft SQL Server on Azure Virtual Machines in the Microsoft Azure portal

We’re excited to announce the public preview of the Premium SSD v2 provisioning experience for SQL Server on Azure Virtual Machines.

Published March 9, 2023

11 min read

SQL Server 2022: Intel® QuickAssist Technology overview

SQL Server backup compression provides the compressed backup option for all streaming SQL Server backup types—full, differential, and transaction log.

Published September 8, 2022

6 min read

Query Store hints in SQL Server 2022

Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database workloads.

Published August 18, 2022

6 min read

Query Store is enabled by default in SQL Server 2022

In SQL Server 2022, Query Store is now enabled by default for all newly created SQL Server databases.

Published July 21, 2022

13 min read

Improve scalability with system page latch concurrency enhancements in SQL Server 2022

Over the past several SQL Server releases, Microsoft has improved the concurrency and performance of the tempdb database.

Published July 7, 2022

5 min read

Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022

Buffer Pool Parallel Scan is a new feature in SQL Server 2022 that improves the scalability of several common scenarios in SQL Server.

David Pless articles

Provision Premium SSD v2 Storage for Microsoft SQL Server on Azure Virtual Machines in the Microsoft Azure portal

SQL Server 2022: Intel® QuickAssist Technology overview

Query Store hints in SQL Server 2022

Query Store is enabled by default in SQL Server 2022

Improve scalability with system page latch concurrency enhancements in SQL Server 2022

Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022

Explore SQL Server 2025