Anouncements
PASS Summit 2016 - Discount Code Is Here & Ready to be used by all. Share Away!

Discount Code: LC15TDF8

Registration Info:

The PASS Summit 2016 registration is live and prices will increase soon, so we encourage you to share this code ASAP with anyone interested in attending PASS Summit 2016 to double down and get the best possible rate plus the discount code. The code can, and we hope, is used over and over. Pass along to your friends, co-workers, folks on the street, and tweet it continually using the #Summit16 hashtag. -  http://www.sqlpass.org/summit/2016/RegisterNow.aspx

 Feature Presentation

Tuesday, April 19, 2016

Leveraging CDC and SSIS for ODS/DM/DW Loads

Warren Sifre - Microsoft

Abstract:
One of the challenges with loading ODS/DM/DW is gathering data and reducing performance impact. Change Data Capture (CDC) is a means to capture all the changes of a given table, but how do you load this data to another Database. We will walk through the process and considerations for loading data using SSIS package and how to detect changes to the CDC Configured Tables which has been known to cause SSIS Package failures.

About Warren:

  • Warren Sifre has been involved the IT community since 1998 and has worked in a variety of industries deploying many different products, most of which consisted of using MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since acquired certifications in all major disciplines of MS SQL. Warren has a passion for Information Security research and has been involved in the InfoSec community since 2011 and actively working to increase awareness within organizations. Big Data and Predictive Analytics are also areas of interest and research which leverages the Information Security and Data Analytics experience acquired.
  • Warren is a Lead Data Analytics Consultant for Allegient LLC in their Data Platforms and Analytics practice. He is also a owner/partner of Broadstroke Consulting Inc. Broadstroke Consulting Inc. is a consulting firm specializing in MS SQL Server and Big Data solutions.
  • He currently holds a Microsoft Certified Solutions Expert: Data Platform/Business Intelligence (SQL 2012), Microsoft Certified Solutions Associate (Windows Server 2008), Teradata Certified Professional (14), and many other Microsoft Certifications.
  • Specialties: SQL Server, Teradata, DB Infrastructure Architecture with an emphasis on Performance Tuning and Scalability (to include SAN, VM, Network, Encryption, Security and Maintenance), BI (Infrastructure, Development and Implementation), PowerShell, SSIS, SSRS, MDS, DQS, DataZen, PowerBI, and many more...

Agenda:
5:30 - Professional Networking & Food
6:00 - Announcements
6:15 - Featured Presentation
7:15 - Prize Drawings

Location:

Apparatus HQ
1401 North Meridian St.
Indianapolis, IN 46202

 Other News

 

IndyPASS 2016 Sponsorship Renewal

Know a company that is a good IndyPASS fit?  Invite a rep to the next IndyPASS Meeting and show them what IndyPASS is all about.

2016 Sponsorship details below.

IndyPASS Sponsor

Cost: $500 annual commitment:

•       $400 in cash

•       At least one prize equivalent to $100 in value (Our members will gladly take more if you want to give them!) Benefits:

IndyPASS Supporter

Cost: $500 annual prize commitment

•       At least $500 of SQL or IT related products with a minimum MSRP of $500 Benefits:

Meeting/Food Sponsors

Cost: Various (approximately $200 per meeting) :

•       DBA’s love free food and they remember who bought it!

 IndyPASS Tweets

Follow us at @IndyPASS:
http://twitter.com/indypass

 Sponsors


Apparatus
Indy Data Partners

Pinnacle Partners.
SIOS
Tully Recruiting
 Violin Memory
 Supporters
Quest Software
ingeniously simple tools
 Special Offers

O'Reilly Bookstore

 IndyPASS Logo Merchandise

Based on popular demand, we now have IndyPASS Logo Merchandise available. Get yours today!

IndyPass Mug.jpg