What's Happening?

Next Meeting: Fri, Feb 24 2017

Let's Get Meta: ETL Frameworks Using Biml - Kate Grass

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

 

When

iCal
UTC : Fri, Feb 24 2017 18:30 - 20:00
Event Time : Fri, Feb 24 2017 11:30 - 13:00 (UTC-07:00) Mountain Time (US & Canada)
Your Local Time: Fri, Feb 24 2017 18:30 - 20:00

Where

7471 Pan American
Albuquerque, New Mexico

Direction: None

Featured Presentation

Let's Get Meta: ETL Frameworks Using Biml

Speaker: Kate Grass, President Grass Williams Enterprises, Inc.

Summary: Do you have SSIS projects that have grown unwieldy, become difficult to troubleshoot or suffer from performance issues? Or maybe you’re getting ready to start a new ETL project and want to learn more about how you can gain efficiency while adding value to your solution? In this session we’ll discuss the concept of an ETL framework and the potential elements that can be incorporated within one. We will look at the advantages of implementing a framework based on metadata and look at some database design options for storing that metadata. To start you off on your framework building journey, we’ll introduce Biml and BimlScript and provide some simple code demos to showcase how Biml can be used to help automate your SSIS package generation. This session will be geared for those with a beginner to intermediate knowledge of SSIS and SQL. While we won’t be teaching Biml in great detail, you’ll get an overview of the technology and pointers on where to learn more.

About Kate: Kate Grass is a digital nomad who has worked with SQL Server in the manufacturing, nonprofit and service sectors. Her experience runs the gamut from Database Design to Application and Report Development to ETL and Business Intelligence with a generous mix of other skills in between. After over 15 years in Arizona, she took her passion for all things data and said goodbye to the office life. She now lives and works in an RV, traveling around the United States with her husband and two dogs. As President and SQL Consultant for Grass Williams Enterprises, she is thrilled that every day is "Take your Dog to Work Day" and that the view out the office window is ever-changing.

Attachments

Supplementary Materials

The following event attachments are available to you:

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.sqlpass.org/.