CALCULATE and FILTER: A Love Story?

There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going...

Please Don’t Do This!

Please, please, please Admins do not leave your default index fill factor at 0. This means you are telling SQL...

Dynamic Threshold for Statistic Update - SQL Server 2016

By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the...

Exploring the Kubernetes dashboard in Azure Container Services

Last week I went through how to run SQL Server in Kubernetes on Azure Container Services (ACS)
This week I want...

TSQL2sday #94 Lets get all Posh!

Write-Output "What are you going to automate today?" 
Welcome to T-SQL Tuesday for September 2017!
T-SQL Tuesday is a chance for you...

Game Night is Back at the Summit

Last year Andy Warren and I worked out a deal with the PASS organization to sponsor a game night on...

How to Safely Parameterize Table Names

Protecting against SQL Injection Part 2

Watch this week's video on YouTube
Last week we talked about building dynamic SQL queries and how doing so might leave you open to SQL injection...

Power BI Custom Visuals Class (Module 67 – Impact Bubble Chart)

In this module you will learn how to use the Impact Bubble Chart Custom Visual.  The Impact Bubble Chart is...

Luck and the PASS Summit

I recently read an article asking the question whether or not we downplay the role that luck plays in our...

SQL Homework – September 2017 – Create a home lab

As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something...