How to get Live Execution Plan using Extended Events

Introduction
Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that...

How Your Hypervisor Can Impact Your CPU

Recently I had a client complain of chronic high CPU utilization. The performance of their SQL Server had degraded, and...

Midlands #PASS April Meeting with Matt Gordon (@SQLatSpeed)

Midlands PASS in Columbia, SC, will be hosting Matt Gordon (website | twitter) for our next meeting, which is scheduled for...

Pushing SQL Change Automation Code to Azure DevOps

Making changes on your own system for a SQL Change Automation project is great, but if you’re the only one...

SQL server reports GUI Schema change history and CPU  RAM IO

SQL server reports GUI Schema change history and...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

SQL server reports GUI Schema change history and CPU  RAM IO

SQL server reports GUI Schema change history and...

[[ This is a content summary only. Visit my website for full links,...

SQL Server, What's In My Buffer Cache?

When SQL Server reads pages it stores them in an area of memory called the buffer cache, things like memory...

Tokenization of database project in SSDT

SSDT project has something we call Variables. On the Internet (posts, forums) they also are known as placeholders or tokens,...

Writing a new session/Preparing for SQL Saturday Chicago

So, I’m presenting a session at SQL Saturday Chicago on March 23, 2019. This is a new session, called Performance...

Azure SQL Data Warehouse Query Store

I personally think that query store has been a fantastic feature. I find myself using it for query performance troubleshooting...