July 10, 2019: The Ultimate ETL Stored Procedure Template

1515 SW 5th Ave. Suite 900, Portland, OR
6:00PM – 6:30PM social | 6:30PM – 8:30PM meeting

Download the stored procedure templates here.


If you attended The Modern Migration Tour 2019 on June 26 (or even if you didn’t but want to review recommendations for upgrading SQL Server), you can download the presentation material from OregonSQL’s public OneDrive.


Vern Rabe
The Ultimate ETL Stored Procedure Template

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.

Michael WallVern 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 and attained certifications in 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.


ServerLogic


Paul Turley
Can You Say “Charticulator”? – I Knew You Could

Learn to build mind-blowing custom Power BI charts for free with no programming. This abbreviated presentation is a sneak peek of a session being prepared for the Power Platform Virtual Conference on July 23 (https://pragmaticworks.com/event/power-platform-virtual-conference/). Charticulator is a toolkit developed by Microsoft Research that allows you design sophisticated, high-precision chart visuals and compile them into an impactful custom visuals for use in your reports. This session was presented at the PNW Power BI Symposium in June.

Paul TurleyPaul ( Blog | LinkedIn | Twitter ) is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon SQL PASS chapter & user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox & Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.

Register NowDon’t miss this meeting!

Refreshments graciously provided by ServerLogic.


We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.


 

Posted in Announcements | Comments Off on July 10, 2019: The Ultimate ETL Stored Procedure Template