Toolbox - IO, IO, Why are You So Slow?

This is the next in a series of blogs I am going to create talking about useful tools (mostly scripts)...

Database Fundamentals #9: Schemas As Containers

Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas...

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