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

Docker – Install Other Open source DB

We can quickly install anything on Docker with hub.docker.com PostgreSQL: $ docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres MariaDB: docker...

How can we merge multiple dacpacs into one

Reading Time: 4 minutes (not a minute longer)
TLDR; You probably don't want to actually merge dacpac's you probably want to deploy multiple and use /p:IncludeCompositeObjects=true.
If you do really want...

How can we merge multiple dacpacs into one

Reading Time: 4 minutes (not a minute longer)
TLDR; You probably don’t want to actually merge dacpac’s you probably want to deploy multiple and use /p:IncludeCompositeObjects=true.
If you do really want...

Invoke-Sqlcmd is Now Available Cross-Platform in the SqlServer module

Invoke-Sqlcmd is Now Available for MacOS & Linux in the SqlServer module.  The module has been posted as v21.1.18095-preview which means to download the module you’ll have to add...