Resources






Random SQL Workload Generator

Traditional SQL Server - Download Zip Here   | View the Blog
SQL Azure Database - Download Zip Here

SQLStress - Download Zip

SCRIPTS

What_To_Compress_v2.sql

PRESENTATIONS

DevOpsDays Tampa Bay 2022
DevOpsDays Tampa Bay Oct -21-2022 - Slide Deck

INTRODUCTION TO SQL SERVER ESSENTIAL CONCEPTS
SQL Saturday Jacksonville 552 May 2016 - Slide Deck & Demos

A Day of Data Science with SQL Server, Azure ML, Spark, Hadoop, and R
SQL Saturday Jacksonville 649 August 2017 - Slide Deck & Demos


A Day of Data Science with SQL Server, Azure ML, Spark, Hadoop, and R



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
OPASS June 2014 Slide Deck, Demo Scripts

INSIDE THE QUERY OPTIMIZER
DevConnections October 2013 Slide Deck, Demo Scripts
SQL Saturday 283 Puerto Rico 2014 Slide Deck, Demo Scripts
Denver SSUG May 2014 Slide Deck, Demo Scripts
AZ SSUG June 2014 Slide DeckDemo 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