Change in sys.dm_exec_query_stats in SQL Server 2016

Sys.dm_exec_query_stats is most commonly used DMO used by DBA and developers to find out the information about queries involving query...

MDW Data Collector – Collection Set jobs not working

ERROR :
Error Message 1 :
Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS...

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)