Welcome to The Monday Morning DBA

I started my IT career twenty years ago as a VB and C developer, wandered into C++ for a bit,...

SQLCLR vs. SQL Server 2017, Part 6: “Trusted Assemblies” – Whitelisted Assemblies can’t do Module Signing

“Trusted Assemblies”, a new feature starting in SQL Server 2017, is a means of whitelisting Assemblies that one feels pose...

Stop waiting for SQL Server Service Pack 1 before upgrading!

It’s not stable until Service Pack 1…
Are you at a company that doesn’t install a new version of SQL Server...

This Made Me Laugh: SQL v NoSQL

It’s a humorous history lesson on SQL (and product promotion), but it opens like this:

SQL awakens to fight the dark...

Love and Hate for SSMS

People have strong feelings about SQL Server Management Studio: they love it AND they hate it. In this week’s episode, I talk about why people have such conflicting feelings...

SSMS 17 Dark Theme

Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...

Friday Reading 2017-09-29

Another busy week almost over and today I’m heading to Utrecht for SQL Saturday Holland! Never been to Utrecht before...

SSAS Tabular DirectQuery–No Hierarchies in Dimensions

I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server and analyzing in Excel, the hierarchies for the Date...

Seattle Freecon 2017

Announcing Seattle Freecon 2017
Are you going to the PASS Summit this year? (and if not… why not?)
Are you coming in...

SSAS Tabular DirectQuery–No Hierarchies in Dimensions

I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server...