SQL Bits 2018 - 60 Reporting Tips in 60 Minutes

60 reporting tips in 60 minutes - SQLBits 2018 from Ike Ellis

Latest YouTube tip on Excel Data Sets ~ 1 minute

14 Habits of Great SQL Developers - PASS Summit 2017

14 Habits of Great SQL Developers from Ike Ellis

Slides from SQL PASS 2017 - Dive into Azure Data Lake

Dive Into Azure Data Lake - PASS 2017 from Ike Ellis

Slides on A Lap Around Microsoft's Business Intelligence Platform

A lap around microsofts business intelligence platform from Ike Ellis

Visual Studio Azure Data Lake Issues

I had a weird issue with Visual Studio and Azure Data Lake.  It manifested itself in three ways:

1)  In the server dropdown of the U-SQL script editor, I could only see (Local) and not my ADLA account:

2)  When I closed an ADLA solution and reopened it, I would get "project not available."

3)  In Azure Cloud Explorer, I would get "Resource Unavailable" underneath Data Lake Analytics:

I couldn't figure out what the problem was.  I had a lot of tools installed and I think some were in beta...or I had an old version of the Azure Developer Tools.  I tried removing everything and readding it, but the problem persisted.

I finally just shotgunned the problem and created a new VM image.  I installed the following things in this order:

1)  Visual Studio 2015 Professional with Update 3.

2) Azure Developer Tools from this link: https://azure.microsoft.com/en-us/tools/

3) Azure Data Lake Tools (the Feb 8th build) from this link:  https://www.microsoft.com/en-us/download/details.aspx?id=49504

My problems all went away.  Hope this helps someone else.

Power BI - Creating a playable scatterchart

I created seven quick youtube videos on how to create a playable scatterchart like the one Hans Rosling created in his famous Ted talk.  This is part of a playlist that you'll see if you watch the video on YouTube.