Tag Archives: Melody

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

Women’s History Month

Gandhi is quoted as saying “be the change you wish to see in the world.” I take this to heart and live my life by this statement in many respects. Applying this sentiment can be particularly hard in business as we try to fight our confirmation bias and need to surround ourselves with like minded […]

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