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

#DataInDevon – Getting up to speed with PowerShell or spend a day with one of four other MVPs :-)

Saturday 27th April is Global Azure Bootcamp day
What’s Global Azure Bootcamp?
The website says it best

…. communities will come together once...

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

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

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

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

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

SSIS Catalog Dashboard

For organizations using SQL Server 2012 and newer, the SSIS catalog is the ideal tool for storing, executing, and monitoring ETL logic. The SSIS catalog includes built-in reports that...