Salem Area SQL User Group

Next Meeting

Wednesday,

July

10

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: https://groups.google.com/forum/#!topic/salemsql/ny8PSowF__Y 

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

Lunch provided by TEKSystems

Location: 
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 OregonSQL user group. 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 was honored to have one of the Top 9 PASS Summit session in 2017.

PASSChapterLogo.jpg

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids