Olympia Area SQL Server User Group

Welcome to the website for the Olympia Area SQL Server User Group (OASSUG) in Thurston County, Washington. Our meetings feature excellent presentations plus the opportunity to network with SQL Server professionals.

 

Next Meeting: Wed, Nov 16 2016

Temporal Table and a stateless ETL

Language: English
Event Type: In-Person

When

iCal
Event Time : Wed, Nov 16 2016 14:30 - 16:30 (UTC-08:00) Pacific Time (US & Canada)

Where

5000 Abbey Way SE

Lacey, Washington

November meeting.

 

Updated Location:

The meeting will be held in the Industrial Lab (Engineering) building, which is noted as building 23 on this map:  https://www.stmartin.edu/sites/default/files/smu-files/public-safety/smu-2d-map.pdf.  Please make sure you park in the open parking out near Pacific Avenue, which is a short walk to the meeting location.  Note the meeting room doesn’t have a room number, but there will be a plague that says “Col. Charles Hodges Jr. Microsoft Software and Systems Lab”.  We will try to get some signs up to help direct you. If you get lost go to room 111 for directions.

 

Featured Presentation

Temporal Table and a stateless ETL

Speaker: Daren Child

Summary: Often ETL’s are designed in a quick adhoc fashion, not a lot of thought or design is put into the ETL other than successfully completing a data flow. This ability to quickly develop ETL’s often leaves a ETL less robust and the ETL normally is sensitive to schedule, interruption, or unforeseen failure. A stateless ETL is an ETL that can be ran any number of times, never have to be cleaned up and always pick up the correct set of records. If a stateless ETL fails midstream, the next scheduled run will complete the ETL. This can be easily accomplished using patterns with SSIS. Additionally, the new Temporal Table feature in SQL Server 2016 allows one to easily detect change, and drive a data flow in a stateless manner. This demonstration will be to showcase the new features of Temporal Table and to show the advantages of a stateless ETL.

About Daren: Daren Child is seasoned Data Architect, early in his career he lead an Oracle Academy, and while doing so contributed to the Human Genome Project. Later in Daren’s career he made a platform change to Microsoft SQL Server and took a role as Vertical Data Architect for First American, where he was responsible for data systems that provided over 2 billion dollars in revenue. Daren has expertise in tuning and optimization of high volume complex OLTPs and designing complex ETL based data flows. Daren has modeled and designed over 10 major OLTPs and lead the design of 4 Data warehouses. Last year Daren joined Microsoft and currently is the Regional Data Platform Solution Architect for State and Local Governments. Daren compliments his love for data systems with an undergraduate degree in Electronics Engineering and a Master’s degree in Technology and Education.

Attachments

Supplementary Materials

The following event attachments are available to you:

Announcements

PASS 2019 Discount Code Discount code for the Olympia Area SQL Server User Group is:

LGDISSQJU

Call for Speakers

Peter Palka is trying to put together a 6 month calendar of speakers and topics. Peter would like to start having two presentations per meeting. One topic could be a short 15 minute presentation and then the other could be a 60-90 minute topic. 

 If you have done something you think is noteworthy that others could benefit from, Peter would like to hear from you. He is willing to help you turn any ideas you have into a presentation. OASSUG is a user group, provided and supported by local area SQL Server users.

  Remember you don’t have to do a full-blown 90 minute presentation; even just a short presentation would be a great way to support our local SQL Server user group.

 

 

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