Creating Bar Graph In SQL Server 2017 Using R

Creating a bar graph with R in SQL Server 2017 is relatively easy. It’s just a matter of finding the correct...

Power BI Custom Visuals Class (Module 97 – Enlighten Data Story)

In this module you will learn how to use the Enlighten Data Story. The Enlighten Data Story allows you to...

TDE – Regenerating the Database Encryption Key

As discussed in the last post, with TDE (Transparent Data Encryption), you generally do not need to change the Database...

Date Fun with SQL Server

I saw a people discussing date formats on Twitter after PASS put out an advertisement for a webinar with a...

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

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