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

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

Informix on Docker

Today we will discuss how to install/configure informix on Docker, >docker run -it –name ifx –privileged -p 9088:9088 -p 9089:9089...

Watch: Kendra Breaks and Fixes SQL Source Control (9 minutes)

I love breaking technology. Well, I love breaking technology on purpose, in a place where it’s not going to slow anyone else down. It’s a great way to learn...

system_health Extended Events in Azure SQL Database

The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management that is 2008 or greater. Things are not the...

system_health Extended Events in Azure SQL Database

The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management...

SQL Homework – March 2019 – Reconfigure tempdb

You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor...

Database management: what’s in it for me?

Meet Lisa; she’s a marketing manager with an international travel company. She recently bought a new handbag online. She’d spotted her favorite brand, in the right color and at...

Database management: what’s in it for me?

Meet Lisa; she’s a marketing manager with an international travel company. She recently bought a new handbag online. She’d spotted...

Speaking at Techorama 2019

I’m delighted to announce I’ll be giving a talk at Techorama 2019. It’s one of the best events I’ve ever been to and I’ll be in the good company...