Resources

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


Presentations:

Date: December 5, 2015
Event: SQL Saturday #470 - Washington, DC
Topic: Policy Based Management - Beyond the Basics
Content: PowerPoint slide deck

Date: October 17, 2015
Event: SQL Saturday #452 - Charlotte
Topic: No Money for Performance Monitoring Tools? No Problem!
Content: PowerPoint slide deck

Date: October 10, 2015
Event: SQL Saturday #445 - Raleigh
Topic: Policy Based Management - Beyond the Basics
Content: PowerPoint slide deck

Date: October 10, 2015
Event: SQL Saturday #445 - Raleigh
Topic: No Money for Performance Monitoring Tools? No Problem!
Content: PowerPoint slide deck

Date: October 4, 2014
Event: SQL Saturday #330 - Charlotte - BI Edition
Topic: Introduction to Columnstore Indexes
Content: PowerPoint slide deck

Date: July 17, 2014
Event: Charlotte SQL Server User Group
Topic: How to Train Your DBA
Content: PowerPoint slide deck

Date: July 1, 2014
Event: Charlotte BI Group
Topic: Introduction to Columnstore Indexes
Content: PowerPoint slide deck


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