Query Store was first introduced in SQL Server 2016 and it is amazing how far it has come in such a short time. You can already use Management Studio and Azure Data Studio to get detailed resource consumption for all your queries, such as CPU, memory, and I/O, for Query Performance Insight to give you […]
Shrink the size of your SQL database with SQL Server 2022.
14
Feb
Feb
SQL 2022 is coming and it is time to start preparing. Tempdb for SQL 2022 has some improvements and in order to appreciate them, I start with an overview/history of tempdb.
I am not sure if many of my readers are aware but I am a fan of the work that Davide Mauri, and his team at Microsoft do on the Azure SQL Hyperscale team. I have had the pleasure of working with Davide through the MVP program and he is truly one of the more […]
