Resources


PAGE & ROW COMPRESSION HOW, WHEN, & WHY

Slide Decks & Demo's

SQL Saturday 62 January 2011 - BlogSlide Deck
MagicPass February 2011- BlogSlide Deck
DBA Virtual Chapter March 2011 - BlogSlide Deck, Demo Scripts
SQL Saturday 74 April 2011 - Slide Deck, Demo Scripts, Monday Morning Checklist
SQL Rally May 2011 - BLOGS [Pre-Con, Day 1, Day 2, Slide, Thank You], Slide Deck, Demo Scripts
OPASS August 2011 - Slide Deck, Demo Scripts
SQL Saturday 79 August 2011- Blog, Slide Deck, Demo Scripts, Monday Morning Checklist
Pragmatic Works August 2011-Blog, Slide Deck, Demo Scripts,Monday Morning Checklist
SQL Saturday 130 April 2012 - Blog, Slide Deck, Demo Scripts, Monday Morning Checklist

PAGE & ROW COMPRESSION DEEP DIVE

PASS Summit October 2011 - Slide Deck, Demo Scripts
PASS Summit November 2012- Slide Deck, Demo Scripts
SQL Live 360 December 2012- Slide Deck, Demo Scripts

TRANSPARENT DATA ENCRYPTION THE LIGHTNING ROUND

Slide Deck & Demo's

OPASS March 2011- Blog, Slide Deck, Demo's, Additional Scripts for Certificate Management Script 1, Script 2, Script 3
SQL Rally 2012- Slide Deck, Demo Scripts

TRANSPARENT DATA ENCRYPTION INSIDE AND OUT

SQL Saturday 79 August 2011- Blog, Slide Deck, Demo Scripts
SQL Dev Connections 2012 March 2012 - Slide Deck, Demo Scripts
SQL Rally 2012- Slide Deck, Demo Scripts
MagicPASS 5/2012-  Slide Deck, Demo Scripts
Pragmatic Works Webinar 5/22/2012-  Slide Deck, Demo Scripts
SQL Live 360 December 2012- Slide Deck, Demo Scripts



SQL INTERNALS, RECOVERY MODELS, AND BACKUPS!  OH MY!

SQL Saturday 79 August 2011- Blog, Slide Deck
Pragmatic Works November 2011 - Blog, Slide Deck, Demo Scripts
SQL Rally 2012 - Slide Deck, Demo Scripts
SQL Saturday Boston 203 2013- Slide Deck, Demo Scripts
SQL Saturday Jacksonville 215 2013 Slide Deck, Demo Scripts


SQL 2000 UPGRADE TIPS AND TRICKS

Pragmatic Works June 2012-  Slide Deck, Demo Scripts


TRIMMING INDEXES GETTING YOUR DATABASE IN SHAPE

PASS DBA Virtual Chapter October 2012 - Slide Deck, Demo Scripts, Blog
Pragmatic Works Training on the T's December 2012 - Slide Deck, Demo Scripts
SQL Live 360 December 2012- Slide Deck, Demo Scripts

PERFORMANCE TROUBLESHOOTING
Space Coast SSUG May 2013 Slide Deck, Demo Scripts
Tampa Bay DBA SSUG May 2013 Slide Deck, Demo Scripts

INSIDE THE QUERY OPTIMIZER
DevConnections October 2013 Slide Deck, Demo Scripts

PARTITIONING
Pragmatic Works Training on the T's July 2013-Slide Deck, Demo Scripts, Webinar

SQL INTERNALS DEEP DIVE
24 Hours of PASS Fall 2013 - Slide Deck, Demo Scripts
DevConnections October 2013 - Slide Deck, Demo Scripts
PASS Summit 2013 - Slide Deck, Demo Scripts