Salem Area SQL User Group

Next Meeting




Vern Rabe -- The Ultimate ETL Stored Procedure Template

  • In-Person @ Salem, Oregon, United States (map)
  • 11:30 - 13:00 Pacific Daylight Time
  • Language: English

>>>>Download Meeting Materials Here:!topic/salemsql/ny8PSowF__Y 

SalemSQL Lunch & Learn
Wednesday, July 10th, 11:30 am - 1:00 pm 
RSVP at Eventbrite Tickets. 

Lunch provided by TEKSystems

Public Service Building 
(across the street from the state Capitol, the SE building on the Capitol Mall) 
255 Capitol St NE, Salem, Oregon 97310
Basement Room A

Going to PASS Summit this year?  Use the SalemSQL discount code LGDIS9V6G for a $150 discount.

Featured Presentation:

The Ultimate ETL Stored Procedure Template

Vern Rabe, Data Architect RabeData

Do you process data from externally sourced landing tables to staging tables? Or from staging tables to an ODS? Or from an ODS to a DataWarehouse? These processes are typically done with ETL (extract, transform, load) stored procedures. In this session we will build, one step at a time, the ultimate template that can be used to create all of these stored procedures. The template covers error handling, deadlock detection and recovery, the ever-important logging, transaction management, incremental loading, and more. Starting with a basic structure, we will step through adding features one at a time to the template, explaining each as we go. Use some of the features or all of them – your stored procedures will be more stable, extensible, and “troubleshoot-able”.

About Vern:
Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR, and leader of the Oregon Data Community user group, formerly OregonSQL. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server knowledge gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts. Vern regularly presents technical sessions at SQL Server user group meetings, SQLSaturdays, and PASS Summit.



Back to Top