Canadian SQL Saturday speaking events

I am pleased to announce that I will be speaking at two separate SQL Saturdays in March and April of...

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

Disabling and enabling triggers

I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now...

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

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