Columnstore Indexes at PASS Performance Palooza: Recording and Materials

Yesterday I participated in PASS Performance Palooza.
I had a lot of fun delivering my session Columnstore Indexes – Questions and Answers.
The...

Power BI Desktop: A Guide for Excel Users

Today Microsoft officially released the new development tool for Power BI called Power BI Desktop.  First of all let me...

Get Away from the Heat and Learn some Database Version Control

I have enjoyed the trips I’ve made to New Orleans and Baton Rouge in the past. It’s a good getaway,...

013 – The Start of Something Big! - WaterOx Consulting

Together we can make a difference in the data world! In WOxPod!,...
The post 013 – The Start of Something Big! appeared...

Boost your OLTP database performance with SQL Server 2014 in-memory tables

Today we can already say with certainty that the most striking innovation in the MS SQL 2014 is the In-MemoryOLTP. In-Memory...

Setting Up and Using Azure VM SQL Automated Backup (and Restore)

This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots....

Power Bi Desktop Release Today

You can download the much hyped up Power BI Desktop (formerly Power BI Designer). There are many blogs about the...

Speaking on Standardized SQL Installations - Script Review & Demo - SQLSaturday (Sacramento)

Speaking on Standardized SQL Installations - Script Review & Demo - SQLSaturday (Sacramento)

Speaking on Standardized SQL Installations - Script Review & Demo - SQLSaturday (Sacramento)