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 #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

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