Overview of Resumable Indexes in SQL Server 2017

Managing indexes is a critical component of database maintenance but we often don’t think about the indicators behind the index...

Adding Performance Counters back for SQL Server

I had a strange situation the other day, where a number of things went wrong with my instance. First, I...

Database Fundamentals #4: Create a Database

SQL Server provides multiple ways to perform most functions. In order to maximize your understanding of how SQL Server works...

Temp table quiz

Brent Ozar (b/t) posted a pop quiz on twitter earlier today.

Go ahead and give it a shot .. I’ll wait.
So?...

Keep VMware snapshot growth from wrecking your day

VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot...

SQLpassion Workshops for Fall 2017

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

Real-life SQL Server Performance Troubleshooting at SQLSaturday Columbus

Join me Friday, July 21, 2017 for a day of Real-life SQL Server Performance Troubleshooting as part of SQLSaturday Columbus...

The Three A’s: Authentication

When I start talking with folks about security, one of the areas of confusion I often find has to do...

Monday Coffee: Attending Conferences

Last week I asked the following question on Twitter: –

I was interested to see the responses as I wanted to...

External Tool VSCODE called from SQL Management Studio

Previous Related Post:
Split personality text editing in SSMS with Sublime Text 3
In this prior post I wrote about how...