Downloads

Looking to download the materials from one of my sessions or articles?

I put them all here, in one convenient location for you!

SQL 2016 Launch Day Package

This is a package containing the slides and scripts we used for the SQL 2016 Laucnh Day event in Washington DC, along with a few others bonus slide decks!

Would You Just Load Already Pack

This pack contains a backup of an empty demo database, source and destination files along with the SSIS package used during the Would You Just Load Already presentation.
Note that the SSIS package was developed with SSDT for Visual Studio 2013.

Len vs Datalength

Demo script for Len vs Datalength post

Renaming Servers

Script from our Changing Your Server Name blog post

Untrusted Foreign Keys

The script from our Untrusted Foreign Keys blog post

Unknown Values – Script 1

The first set of scripts from our Video: Walk & Talk #1 – Unknown Values

Unknown Values – Script 2

The second set of scripts from our Video: Walk & Talk #1 – Unknown Values

Hashgroups Demo Script

From our presentation: Optimizing Protected Indexes

Versioning SQL Server

The script from our blog post: Versioning In Your SQL Database

SQL Server Versions

The script to build your own SQL Version table.

From our blog post: SQL Server version table

SQL Server Internals – A Moderate Wade

Slide deck from my presentation that covers the 3 main components SQL Server uses. CPU, Memory and Disk.

Would You Just Load Already Pack

This pack contains a backup of an empty demo database, source and destination files along with the SSIS package used during the Would You Just Load Already presentation.
Note that the SSIS package was developed with SSDT for Visual Studio 2013.

The Spy Who Loathed Me – An Overview of SQL’s Security Features
Forget the Backups – Prevent Recovery Amnesia

A zip file containing the presentation, scripts and supporting files from our: Forget The Backups – Prevent Recovery Amnesia session

Optimizing Protected Indexes – PPT

The slide deck from our Optimizing Protected Indexes session.

Dealing With Difficult People

The slide deck from Gigi Bell’s presentation on Dealing With Difficult People

It is easier to forgive an enemy than to forgive a friend.

You are ultimately responsible for what you download from the internet. Make sure it is what you expect it is and it does what you think it does first.