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 […]
Tag Archives: Microsoft
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 […]
29
Mar
Mar
Microsoft in the News Data Storage On March 21, 2018, Microsoft announced their proof of concept for the storage of data in manufactured DNA. Using a fully automated system, Microsoft was able to store the word “hello” in a manufactured DNA and retrieve it back into digital form. The rate of data production is increasing […]
