Procedure to Create New Filegroups and Files

Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...

Why Projects Fail...Free Session, Free Beer and Free Food

Why Projects Fail...Free Session, Free Beer and Free Food 

Mark Williams and myself will delivering a seminar called #Not the GDPR news in...

Azure SQL Database – Failed to Delete Database Nightmare

After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs....

Remembering Robert Davis, aka @SQLSoldier

I woke up early on Tuesday with a hundred things to do and plenty of energy to match my task list. By noon, I’d made a loaf of bread,...

Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger

Watch this week’s episode on YouTube.
In this week’s video with Power BI expert Eugene Meidinger, we’re in the kitchen learning...

Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger

Watch this week's video on YouTube
In this week's video with Power BI expert Eugene Meidinger, we're in the kitchen learning about Power BI.
Power BI has two languages available for...

Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger

Watch this week's video on YouTube
In this week's video with Power BI expert Eugene Meidinger, we're in the kitchen learning about Power BI.
Power BI has two languages available for...

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1

(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...

Primary Replica Jobs

This post talks about having primary replica jobs. That is, jobs that will only run on the primary replica of...

Migrating to Azure DBaaS – A Client’s Steps Taken to the Cloud – Part 2

Hello everybody!  Thanks for stopping by again.  In Part 1 of this series, I gave the background of the project, and...