Azure SQL Data Warehouse Gen2 announced

Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse.  With this performance optimized tier, Microsoft...

Power BI Custom Visuals Class (Module 101 – Tachometer)

In this module you will learn how to use the Tachometer. The Tachometer for communicating performance against a goal.

Module 101...

Connect to Power BI Report Server with SSMS

Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security...

SQL Homework – May 2018 – Create a database

I’ve really got to make a plan here at some point. So far I’ve been just putting down things as...

5 Ways to Examine Cardinality Metrics

In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The...

Getting my Twitter Data via Azure Logic Apps

As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people...

Using CAST() function with User-Defined Data Types…Did you know…

I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the...

Changing the location of docker named volumes

A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know...

Using CAST() function with User-Defined Data Types...Did you know...

I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the same way that SQL Server. No surprise - I...

SQL Server Advanced Aggregations Part 3 GROUPING/GROUPING_ID

This post is part 3 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...