PASS Summit 2016–Tuesday

For the first day at the Summit this year, I spent half my time in a Pre-Conference session with Idera...

SELECT * Does Not Hurt Performance

I read all the time how SELECT * hurts performance. I even see where people have said that you just have...

Thursday Game Night at PASS Summit

On Thursday night, Oct 27, 2016, Andy Warren and I are hosting a game night event at the Washington State...

A Sub-Query Does Not Hurt Performance

The things you read on the internet, for example, “don’t use a sub-query because that hurts performance.”
Truly?
Where do people get...

Centralized Management Server 101

Registered Servers
I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. 🙂 This is definitely not...

Monday Night Networking Dinner Tonight

If you are attending the  PASS Summit, or even in the Seattle area, we have a SQL Server pro networking...

Power BI Custom Visuals Class (Module 22 – Force-Directed Graph)

In this module you will learn how to use the Force-Directed Graph Power BI Custom Visual.  The Force-Directed Graph allows...

PowerShell : CSV – Disk Space Report – Excel

Abstract
Monitoring disk space utilization of server(s) is a critical and important job for any administrator. Keeping things organized might improve...

PSConfAsia 2016

I have just got back to the UK from Singapore following the amazing PSConfAsia conference. I must say that Matt,...

Query Store – Part 2 - Configuration Settings

Introduction to Query Store covered here.
Now for the second part on “How to Configure?”

Query Store is configured at the...