Resources

Presentation Materials

Download the slide decks and code samples from my recent presentations:
Next Level SSIS series - North Texas SQL Server User Group (June-Aug 2014)
SSIS Scripting – SQL Saturday #271 Albuquerque (01/25/2014)
Data Cleansing in SSIS – SQL PASS Summit 2013 (10/16/2013)
Maximizing SSIS Package Performance – SQL Saturday #232 Orlando (9/14/2013)
Handling Errors and Anomalies in SSIS – SQL Saturday #223 OKC (8/24/2013)
Scripting and SSIS – Linchpin People presentation w/ Andy Leonard (May 2013)
Real World SSIS – Full day precon at SQLBits 11 (May 2013)
Cleaning up Dirty Data with SSIS – SQLBits 11 (May 2013)
When ETL Goes Bad: Handling Errors and Anomalies in SSIS – Colorado user group tour (March 2013)
When ETL Goes Bad: Handling Errors and Anomalies in SSIS
Real World SSIS – SQL Saturday Dallas precon (10/12/2012)
Top 10 New Features of SSIS 2012 – SQL Saturday #125 OKC (8/26/2012)
Introduction to Data Quality Services – SQL Rally Dallas (5/10/2012)
Top 10 New Features of SSIS in SQL 2012 – SQL Saturday #107 Houston (4/21/2012)
Parent/Child Structures in SSIS – SQL Saturday #107 Houston (4/21/2012)
Defensive ETL – SQL Connections Las Vegas (11/3/2011)
Top 10 SSIS Best Practices – SQL Connections Las Vegas (11/2/2011)
ETL Head-To-Head: T-SQL vs. SSIS – SQL Saturday #90 OKC (08/27/2011)
Business Intelligence Drive-By: A Quick Tour of Microsoft BI – SQL Saturday #90 OKC (08/27/2011)
ETL Head-To-Head: T-SQL vs. SSIS – SQL Rally Orlando (5/12/2011)
Dirty Data? Clean It Up! – Colorado SQL Server User Group tour (Feb 2011)

Please note that all code is provided as-is with no expressed or implied warranty. Use at your own risk.

Stuff I read

Data Loading Performance Guide – Loading lots of data into SQL Server?  You need to read this.

Tools

Konesans.com produces a great Trash Destination and Data Generator for SSIS, among other tools
BIDS Helper is a Visual Studio add-in with some nice features for SSIS.
Notepad++ is Windows Notepad on steriods. ‘Nuff said.
Here’s a listing of a ton of free SQL Server utilities. Enjoy!
ConnectionStrings.com - The place to find any connection string you will ever need.
SSIS to SQL Server data type translation

Comments are closed.