Analyzing DBA Salaries

Recently, Brent Ozar put together a data professional salary survey.  He did some early research and opened the floor for others, now that the results are in.  In this post, I'm going to take that data set and do some fairly simple descriptive statistics with R.  So let's fire up RTVS and get started. Getting A Picture…

Let’s Build A Portable Hadoop Cluster, Part 1

A little while back, I had a mini-series on building a Hadoop cluster.  Part 1 covered what I bought.  Part 2 introduced the idea of a Dockerized Hadoop cluster.  Part 3 covered installation and setup. That's all well and good, but one of my goals is to make this a portable Hadoop cluster so I can…

Working With Azure SQL DW

This is a continuation of my Polybase series. The first step to working with Polybase in Azure SQL Data Warehouse is to provision an Azure SQL Data Warehouse instance.  I'm going to follow along with the data I used in my Azure Blob Storage examples and load that data into Azure SQL Data Warehouse using…

Partitioned Views With Polybase

This is a continuation of my Polybase series. In today's Polybase post, I want to see if I can replicate "SQL 2000 partitioning" using Polybase.  Back before SQL Server 2005, there was no concept of partitioned tables; the only way you could partition a table was to separate each logical subset of data into its own…