Wednesday, December 12, 2018
Task Pane 
Remember Me
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?

[show results]
CDC you can have your cake and eat it | Geoff Clark
Author: Grant Paisley Date Posted: 6/5/2013 10:13:17 PM

How it fits into SQL product set.
What it is good for.
How it works (Architecture) – reads log asynchronously, mainly CLR based
Demo setting up CDC, reading CDC tables
How to handle table changes, max two instances

Demo Handling structure changes
How to use it to maintain a Warehouse.
How to initially load.
Demo Initialising from a snapshot and if time a backup.
Creating the ETL process – BIML, SSIS.
Handling the sliding window when CDC is cleaned up.
Demo: Illustrating sliding window

Geoff has worked with SQL Server since 1991, he was the technical architect at BAA for one of the earliest SQL database project, going live with the original betas’ of both Windows NT and SQL Server on multiprocessor computers. Geoff began his professional career as a consultant for ICL based in the City of London, designing and capacity planning network database based transaction processing and reporting applications before moving to Ingres relational databases on Sun and then SQL Server.
Geoff recently worked on a Data Warehouse in a large CI environment, including designing an ETL solution based on CDC technology.
Geoff has presented at SQL User Groups and SQLBits.

MCT, MCSE: Data Platform

Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30PM Networking (Pizza & Drinks provided) 6:00PM Session | On: Tuesday, July 9, 2013