Tag Archives: SQL

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

Azure Synapse Link for SQL Server

Since Synapse came to the market it has been one of my favourite products.  I have had the pleasure of helping many clients architect their way to the cloud to take advantage of Azure Synapse Analytics.  When first introduced, it was often referred to as the replacement for Azure Data Warehouse. Over time it has […]

Tempdb gets better with age (Part 2)

In my previous blog and this one, there is a lot of talk of trace flags and you can see the life cycle of them.  They are implemented and then sometimes become part of the product over time. For a long time, the trace flag 1118 was a common performance improvement trick known only by […]

Tempdb Gets Better With Age

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.

Cloud Connected SQL Server 2022

The fall is my favorite time of year, not just because of the leaves changing colour and certainly not because of the cooler weather. It is conference season! Fall is family time for me because it is when, in pre-pandemic times, I would see my #SQLfamily at one conference or another.  Typically, my SQL friends […]

Auto-Failover Groups for Azure SQL Hyperscale Tier

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

Microsoft Q&A (Preview) Has Launched

A few days ago, the Microsoft forum previously known as “Minerva” has launched in Preview mode. The new name for this forum is Microsoft Q&A. In order to ensure that you are able to quickly find the right answers to your tech questions, Microsoft has chosen to move away from the community-driven platforms like MSDN […]

5 Reasons DBAs are More Important Than Ever!

As data becomes increasingly important—along with related technologies like IoT and machine learning—it’s no surprise that our roles as DBAs are changing. To me, it is why I love this industry. For most of us, learning innovative technology is fun, and we wouldn’t want it any other way. However, change can be as scary as […]

Thank You For Your Vote of Confidence

I was recently informed that I have been elected to the PASS Board. I am very much humbled by this and intend to do my best to ensure that your confidence in me was not misplaced. It is a great honor to be able to represent you at the board level. I would like to […]