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...

Backup of an Azure SQL DB downloaded outside of Azure

From a dev colleague: “Asking for a client... do you know how to get a backup of an Azure SQL DB downloaded outside of Azure?”

Short answer - You can’t…

Medium...

COUNT, DISTINCT, and NULLs

Watch this week’s episode on YouTube.
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT)...

CTRL + F in SSMS execution plans

I just discovered this the other day and I had to share it.

First, we need a query in Management...