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

SQL Server Database Files Wise I/O Latency Details PART#1

One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want...

Geo Location of Twitter messages in Power BI

[2017-June-25] There are several custom solutions that make Twitter messages analysis possible in Power BI. And with a recent addition of...

Columnstore Indexes – part 107 (“Dictionaries Deeper Dive”)

Continuation from the previous 106 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I would like to thank Sunil Agarwal...