Viewing container logs

I’ve been going over some demos for a presentation that I’ll be giving this year and I thought I’d write...

Creating SQL Containers from a Dockerfile

I’ve been playing around with SQL containers on Windows Sever 2016 a lot recently and well, building empty SQL containers...

Does Query Store Pre-Allocate Space

I love the questions I get while I’m presenting because they force me to think and learn. The question in...

How SQL 2016's JSON Functionality Will Make You Want To Use JSON

This post is a response to this month's T-SQL Tuesday prompt. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users to share ideas about...

It is possible to run scripts inside SSMS on multiple instances without using CMS? Yes, it is!

Today I will write about an option that is less known/used in the SSMS tool. The ‘SQLCMD Mode’ option.

What is...

Power BI Custom Visuals Class (Module 38 – Mekko Chart)

In this module you will learn how to use the Mekko Chart Power BI Custom Visual.  The Mekko Chart visual...

Server level database permissions

Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a...

T-SQL Tuesday #87 – Beware the Shiny New Toys

Today is yet another T-SQL Tuesday – the monthly blogging party started by Adam Machanic (b|t) to get everyone in the...

T-SQL Tuesday #87 – Fixing Old Problems with Shiny New Toys: STRING_SPLIT

Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday.

Splitting Strings in SQL
A problem that has plagued SQL developers through...

T-SQL Tuesday #87 – New Way to See Wait Stats for a Single Query

Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems...