Next Meeting - June 18, 2013
Please note: This is the 3rd Tuesday in June.
at Microstaff IT
Capture Change and Apply it With Change Data Capture & SSIS
Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server & SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.
Speaker: Steve Wake, Pragmatic Works
Steve Wake is a Sr. BI Consultant at Pragmatic Works with more than 20 years of experience in various IT organizations. Steve is a Microsoft Certified Professional with an MCSE in SQL Server 2012 Business Intelligence and MCITP in SQL Server 2008 Business Intelligence. Steve has experience in Manufacturing, Retail, Charities, Telecommunications and Financial Services organizations & switched to consulting to share/expand/teach on his experiences with Microsoft Business Intelligence. Steve is also very involved in the local community, speaking at events across the country and is currently President of the Denver SQL Server User Group. Steve blogs regularly at http://blog.wakebi.com and is on Twitter @stevewake, LinkedIn and Google+.