Using docker named volumes to persist databases in SQL Server

I’ve previously talked about using named volumes to persist SQL Server databases but in that post I only used one...

Power BI Now Has Keyboard Accessible Visual Interactions

The March 2019 release of Power BI Desktop has brought us keyboard accessible visual interactions. One of Power BI’s natural...

Microsoft Azure – How to create the Azure Active Directory (AD) using Azure Portal

Microsoft Azure Active Directory (AD) is a cloud based service to handle the identity and access management. It has the...

Uppercase All String Columns (and in a Single Query!)

(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )

Intro
The other day, Steve Jones published a short post with a quick...

Two Weeks to #sqlinthecity Streamed

It’s just two weeks until the SQL in the City Streamed starts up again in 2019. I’m ready to travel...

Delete activity in Azure Data Factory - Cleaning up your data files

(2019-Mar-20) File management may not be at the top of my list of priorities during data integration projects. I assume that...

Generating a Jupyter Notebook for Glenn Berry’s Diagnostic Queries with PowerShell

The March release of Azure Data Studio now supports Jupyter Notebooks with SQL kernels. This is a very interesting feature...

The free SQL to Excel Export tool

Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel....

Sizing your Azure SQL Database

Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...

Women in Tech Talk Tech

March is Women’s History Month, to celebrate the PASS Women in Technology Virtual Group (@PASS_WIT) held a webcast featuring prominent...