AdventureworksCI Step 4 Pushing to GitHub

This is part of a series on how to take the Adventureworks database and bring it in line with modern...

DBTA – IT Employers Must Adapt to the Looming DBA Shortage

Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of the findings contained in an intriguing...

Hey Kids! Let’s Put on a Show at the Old Barn

Alternate Title: I’m traveling a bunch. Let’s get together and talk.
A bunch of trips and presentations coming up, so I...

Power BI v2 is GA

I guess in the age of rapid development and releases the fact of General Availability of the Power BI v...

Some of my favorite SSMS Keyboard shortcuts

I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of...

Creative Schools by Sir Ken Robinson

Education. The key topics for everyone.
In his incredibly famous TED Talk “Do Schools Kill Creativity“, which might be some of...

Excel BI Tip #28: Using member expressions in the CUBEVALUE Function

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Include File Name in Content Using Power Query

When importing data from a flat file using Power Query, you’d want to combine multiple files and include file name...

Password for SQL Server Service Accounts

I wrote recently about my philosophy for service accounts, and wanted to add a few more thoughts.
Security is important for...

Present at SQL Saturday #386 – Achievement Unlocked!

SQL Saturday #386 (Albany, NY) – My first SQL Saturday Session

So that picture to the right is me out front of...