Resources

 

The page is dedicated to presentations, scripts, and other resources that are available for download.

Presentations:

SQL Server Audit – Evidence Never Lies – PowerPoint slide deck
SQL Saturday #707 – Pordenone, Italy – Feb 17, 2018
SQL Saturday #678 – Orlando, FL – Oct 7, 2017
SQL Saturday #692 – Atlanta, GA – Jul 15, 2017
SQL Saturday #610 – Richmond, VA – Mar 18, 2017
SQL Saturday #592 – Raleigh, NC – Mar 11, 2017

Policy Based Management – Beyond the Basics – PowerPoint slide deck
SQL Saturday #544 – Spartanburg, SC – Aug 20, 2016
SQL Saturday #470 – Washington, DC – Dec 5, 2015
SQL Saturday #445 – Raleigh – Oct 10, 2015

No Money for Performance Monitoring Tools? No Problem! – PowerPoint slide deck
SQL Saturday #452 – Charlotte – Oct 17, 2015
SQL Saturday #445 – Raleigh – Oct 10, 2015

Introduction to Columnstore Indexes – PowerPoint slide deck
SQL Saturday #330 – Charlotte – BI Edition – Oct 4, 2014
Charlotte BI User Group – July 1, 2014

How to Train Your DBA – PowerPoint slide deck
Charlotte SQL Server User Group – July 17, 2014

Scripts:

Blog Post: Collecting Historical IO File Stats
Script: sp_CollectIoVirtualFileStats
Current Version: v1.0.0 – 12/17/2013

Blog Post: sp_PerformanceCounters – Get a Health Check of SQL Server’s Performance
Script: sp_PerformanceCounters
Current Version: v.1.0.2 – 11/26/2013