Next Meeting

Thursday,

July

24

OPASS July 2014 Meeting W/ Bradley Schacht

  • In-Person @ 4649 W. 1st ST. Sanford, Florida, United States (map)
  • 18:30 - 20:30 Eastern Daylight Time
  • Language: English

The Orlando SQL user group (OPASS) meets the third or fourth Thursday of every month at Logan's Roadhouse in Sanford, FL. We feature a different speaker every month covering a variety of topics. This is a free event centered around Microsoft SQL server, where everyone is welcome and encouraged to attend. Come join us for free learning, networking, food, and fun.

Featured Presentation:

Change Data Capture (CDC) Made Easy With SSIS 2012

Bradley Schacht, Senior BI Consultant Pragmatic Works

One of the hidden gems introduced in SQL Server 2008 was change data capture. Loading your data warehouse has never been easier thanks to new components in SSIS 2012 designed specifically to consume CDC data. This amazing feature automates the process of detecting inserts, updates and deletes in your data; a vital step in determining type 1 and type 2 record updates. This session will begin by discussing the setup and configuration of CDC. Next Brad will jump into SQL Server Data Tools and walk you step by step through creating an SSIS package to load a dimension that will leverage all the new tasks and components. After this session you will have a very powerful tool in your SSIS tool belt.

About Bradley:
Bradley Schacht is a senior consultant and trainer at Pragmatic Works in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Admin". He uses his experience on many parts of the Microsoft BI platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

Register for OPASS July 2014 Meeting!

 Meeting Time

We typically meet on the third Thursday of each month from 6 - 9 pm. 

 Meeting Location

Logan's Roadhouse

4649 W. 1st ST.
Sanford, FL 32771

We normally start with about 10 minutes of news and announcements.  We then have 10-15 minutes of networking.  Right before the food is served, we give our sponsor for the month a chance to present for 10-20 minutes.  At about 6:45 we start our feature presentation. Finally we end by raffling off any SWAG our sponsors have graciously supplied.

 

Sign up here for news, and join us on our LinkedIn group for networking, discussion, and job posts.