Join Me Online Next Week for SQL in the City

It’s one week to SQL in the City 2017, once again streamed. I’ll be traveling this weekend to the Redgate...

All Mac users should do this immediately

This post is a public service announcement for all users of macOS High Sierra (10.13). (Note: Apple has already released...

Restrict the usage of a SQL Server Authenticated Application Id

SQL Server login ids may not be the most secure thing in the world but they are likely to be...

Overview of Encryption Tools in SQL Server

More and more people are considering some level of encryption against their data stored in SQL Server. In many cases...

Design, Deploy, and Optimize SQL Server on VMware

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

More Beginner / Fundamentals Content

Not surprisingly, there are folks who want beginner / fundamentals presentations and blog posts. 

I put up the poll based on a...

SQL Prompt Gets Even Better

SQL Prompt v9 came out recently, and just when you thought they couldn’t make it better, they found a way....

New version of sp_WhoIsActive (v11.20) is available – Deployed on 123 instances in less than 1 minute

Last night, I received Adam Machanic's (b | t) newsletter "Announcing sp_whoisactive v11.20: Live Query Plans". For those who don't know...

Azure SQL Database – Using sp_BlitzIndex

I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...

How to use Statistics IO to Improve Your Query Performance

SQL Server’s STATISTICS IO reporting is a great tool to help you performance tune queries.Usually the goal of performance tuning...