Welcome to the Columbus SQL Server Users Group

Welcome

We have meetings on the second Thursday of every month. 

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short introduction and Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:30 - Networking & social time
6:30 - 6:45 - Welcome and announcements
6:45 - 7:45 - Presentation(s)
7:45 - 8:30 - Door prizes and Question & Answer session

Upcoming Events

Next Meeting: Thu, Dec 11 2014

CBusPASS December 2014 User Group

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

Hey SQL Server warriors, here we go again (in the Microsoft Office at Polaris)!

Give yourself a gift before the holidays!  Attend a session on BIML (that's BI Markup Language), presented by Chris Schmidt and Harsh Jain.  This technology will change how you approach building ETL.

TOPIC

BIML: Oh Brave New ETL World!

It's estimated that 70% of data warehousing development is in ETL (extract, transformation, and load) between the different source systems, your data warehouse, and/or your data mart. Recently a new tool has entered the marked that promised to revolutionize the way we think about ETL processes. Gone are the days where we need to manually code every component, every event handler, and painstakingly ensure that every package adheres to corporate standards.

In this session, Chris and Harsh will introduce you to the world of BIML and how it can change your world. We'll show you how to quickly create a template in BIML that will make sure all of your packages adhere to corporate standards, and then use metadata to quickly generate dozens of packages to populate your dimensions and facts. Stop spending weeks developing SSIS packages that can be built in hours! You won't want to miss this session that will get your boss to say "I don't think we're paying you enough!

AGENDA

We'll start with dinner at 6pm at Microsoft, followed by networking and the presentation from Chris and Harsh.   Centric Consulting is hosting dinner.  Please join us! 

You can also register as a PASS member for free at sqlpass.org.  This is encouraged but not required for attendance.

TIME & LOCATION

December 11, 2014 
6:00pm-8:00pm

Microsoft Polaris Office 
8800 Lyra Drive 
4th Floor 
Columbus, OH

SPEAKER

Chris Schmidt is a data architect with Centric Consulting and has experiencing designing business intelligence solutions for a wide variety of companies in multiple industries. His passions include the entire Microsoft BI stack, with a special emphasis on SSIS and SSAS. 

Harsh Jain is a data warehouse developer with Centric Consulting and has more than 4 years’ experience developing ETL on a variety of platforms, including SSIS and Informatica. He holds an MIS degree from the University of Cincinnati and is enjoys helping companies solve their data integration challenges.

When

iCal
UTC : Thu, Dec 11 2014 23:00 - 01:00
Event Time : Thu, Dec 11 2014 18:00 - 20:00 (GMT-05:00) Eastern Time (US & Canada)
Your Local Time: Thu, Dec 11 2014 23:00 - 01:00

Where

8800 Lyra Dr
Columbus, Ohio

Direction: None

Featured Presentation

BIML: Oh Brave New ETL World!

Speaker: Chris Schmidt, Senior Business Intelligence Consultant Pragmatic Works

Summary: Hey SQL Server warriors, here we go again (in the Microsoft Office at Polaris)! Give yourself a gift before the holidays! Attend a session on BIML (that's BI Markup Language), presented by Chris Schmidt and Harsh Jain. This technology will change how you approach building ETL. TOPIC Building SQL Server in the Cloud It's estimated that 70% of data warehousing development is in ETL (extract, transformation, and load) between the different source systems, your data warehouse, and/or your data mart. Recently a new tool has entered the marked that promised to revolutionize the way we think about ETL processes. Gone are the days where we need to manually code every component, every event handler, and painstakingly ensure that every package adheres to corporate standards. In this session, Chris and Harsh will introduce you to the world of BIML and how it can change your world. We'll show you how to quickly create a template in BIML that will make sure all of your packages adhere to corporate standards, and then use metadata to quickly generate dozens of packages to populate your dimensions and facts. Stop spending weeks developing SSIS packages that can be built in hours! You won't want to miss this session that will get your boss to say "I don't think we're paying you enough! AGENDA We'll start with dinner at 6pm at Microsoft, followed by networking and the presentation from Chris and Harsh. Centric Consulting is hosting dinner. Please join us! You can also register as a PASS member for free at sqlpass.org. This is encouraged but not required for attendance. TIME & LOCATION December 11, 2014 6:00pm-8:00pm Microsoft Polaris Office 8800 Lyra Drive 4th Floor Columbus, OH SPEAKER Chris Schmidt is a data architect with Centric Consulting and has experiencing designing business intelligence solutions for a wide variety of companies in multiple industries. His passions include the entire Microsoft BI stack, with a special emphasis on SSIS and SSAS. Harsh Jain is a data warehouse developer with Centric Consulting and has more than 4 years’ experience developing ETL on a variety of platforms, including SSIS and Informatica. He holds an MIS degree from the University of Cincinnati and is enjoys helping companies solve their data integration challenges.

About Chris: Chris is a Senior Business Intelligence Consultant at Pragmatic Works with more than 6 years experience in developing business intelligence solutions. Chris is extremely passionate about helping companies achieve insight through data.

Attachments

Announcements

Presentation Files