Tag Archives: SQL Server

Query Store Improvements in SQL 2022

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 […]

Resource Governor – Changing and Deleting a Resource Pool

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 […]

Resource Governor – Getting Started

Microsoft in the News Gates Notes In case you missed it, back in December, Bill gates put out a newsletter with a list of five books he loved in 2018. They included: Educated, by Tara Westover, Army of None, by Paul Scharre, Bad Blood, by John Carreyrou, 21 Lessons for the 21st Century, by Yuval […]

Resource Governor – Memory Allocations

Microsoft in the News Fabian Bolin is looking to bring the power of Microsoft Azure to address a bottleneck in the area of cancer research. It turns out that almost half of clinical trials dealing with the study and treatment of tumors (oncology) are delayed due to a lack of qualified patients. Fabian is looking […]

Resource Governor – CPU Allocations Part 2

Microsoft in the News Microsoft’s Cortana voice assistant has been a huge success among enterprises in North America and Europe. They can currently boast that 49% of enterprises in these regions use Cortana – not exclusively, but still. Unfortunately, the story is very different in the consumer world. In that area, Cortana has struggled to […]