Albuquerque SQL Server User Group

What's Happening?

Next Meeting: Fri, Jul 13 2018

July Meeting: Detecting and Capturing Change for Data Warehousing - with Chris Hyde

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Albuquerque-SQL-Server-User-Group/events/250388042/

The Albuquerque SQL Server User Group (ABQSQL) will be having its next meeting on Friday, July 13th from 11:30 AM to 1:00 PM at Hospital Services Corporation, 7471 Pan American Freeway NE.

Chris Hyde will be sharing his thoughts about the various methods of detecting change in your business systems for loading your data warehouse. Please join us for his presentation “Detecting and Capturing Change for Data Warehousing”. Ask Chris your SQL questions, get to know your peers, and have lunch on us!

Presentation description: "There are many ways of detecting and capturing changes to the data in your business system in order to populate your data warehouse. In this session we will compare and contrast several methods for loading slowly-changing dimensions in your ETL solutions, including SSIS design patterns, T-SQL code, change data capture (CDC) and temporal tables. Attendees will gain a full understanding of the pros and cons of each of these solutions and become confident in choosing and implementing them in their own ETL solutions."

Attend this FREE SQL training event!

Kindly RSVP so we know how much pizza we should buy!

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.pass.org/.

When

iCal
UTC : Fri, Jul 13 2018 17:30 - 19:00
Event Time : Fri, Jul 13 2018 11:30 - 13:00 Mountain Daylight Time
Your Local Time: Fri, Jul 13 2018 17:30 - 19:00

Where

7471 Pan American Freeway West NE
Albuquerque, New Mexico

Direction: None

Featured Presentation

Detecting and Capturing Change for Data Warehousing

Speaker: Chris Hyde, Owner and Principal Consultant Hydrate Consulting LLC

Summary: There are many ways of detecting and capturing changes to the data in your business system in order to populate your data warehouse. In this session we will compare and contrast several methods for loading slowly-changing dimensions in your ETL solutions, including SSIS design patterns, T-SQL code, change data capture (CDC) and temporal tables. Attendees will gain a full understanding of the pros and cons of each of these solutions and become confident in choosing and implementing them in their own ETL solutions.

About Chris: Chris Hyde is an independent SQL Server BI and DBA consultant based in Albuquerque, NM, and is the leader of the Albuquerque PASS local user group. He is a part of the Friends of Redgate program and was recently named in the Idera ACE class of 2018.  He loves loud music and cricket, but not usually at the same time.

Attachments

Please be sure to check out our Meetup.com page, and RSVP there for our monthly meetings.

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.pass.org/.

Sponsors

PASSChapterLogo100.jpg  

 

 


 

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