Name: Steve Wake - Change Data Capture (CDC) and SSIS
Start: 2015-03-18T17:30:00-06:00
End: 2015-03-18T20:30:00-06:00
Location: Solar Winds (formerly Confio) in Boulder

First Presentation, Paul Paiva

SQL Snippet: How to restore many databases quickly.

Main Presentation:

Capture Change and Apply it with CDC & 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.

Steve Wake is a Consultant at RevGen Partners (http://revgenpartners.com) with more than 20 years of experience in various IT organizations. 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 SQL community, speaking at events across the country, blogging at http://wakebi.com , and is currently President of the Denver SQL Server UG (http://denversql.org).

Paul

Boulder SQL

Technology

Database Development

Database Professionals

SQL Server

Business Intelligence

SQL Azure

Advanced SQL Server

Business Intelligence & Data Warehousing

Amazon Relational Database Service (Amazon RDS)

Data Analytics

Data Visualization

Big Data

Data Management

Steve Wake - Change Data Capture (CDC) and SSIS

Solar Winds (formerly Confio) in Boulder

Share

Boulder SQL

Steve Wake - Change Data Capture (CDC) and SSIS

Boulder SQL

Details

Members are also interested in