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