Slides from my SQL in the City Seattle presentation

11 Goals of High Functioning SQL Developers from Ike Ellis

Pluralsight offline player doesn't show the course list

Just in case anyone else has this problem: I use the Pluralsight offline player to watch videos on my 1 hour train ride to and from work. I noticed that the player wouldn't load the course list intermittently. Then I noticed that it would load the coarse list if I had internet access, which defeats the purpose of an offline player.

 After a little thought, I figured out that the Pluralsight offline player uses Silverlight, but it doesn't load it. Internet Explorer can load it. So if it is not showing your course list, launch IE, then launch the player. Your course list will show up afterwards.

 

Top 5 Things You'll Learn from my PASS Summit session

I don't want to give everything away, but if you come to my PASS Summit session, you'll learn and see demos explaining the following five bullets:

 1) When to use a JSON document store and when to use a relational store.

 2) When you need to use Azure Table Storage, and when you should use something else.

 3) You'll see demos for DocumentDB, Azure Table Storage, and Azure SQL Database.

 4) You'll see when to use Azure SQL Database or SQL on an Azure VM or both.

 5) You'll see Azure SQL Warehouse and why it's a unique data storage offering.

 Most importantly, at the end of this session, you'll understand your Azure data storage choices and why they can each play a pivotal role in your data architecture.

SSMS: Query Shortcuts

No reason to type out SELECT TOP 1000 * FROM or SELECT COUNT(*) FROM anymore.

Slides from the SQL PASS BAC Conference - 60 Reporting Tips in 60 Minutes

SQL Tip: Use Templates and Parameters

Slides from talk from SQL Saturday - Silicon Valley

SQL Tip: Quickly Alias Columns

Slides from SQL PASS talk and talk at San Diego .NET User Group

ALM Best Practices with a SQL Server Database from Ike Ellis