addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

CBusPASS February User GRoup Meeting

  • Feb 13, 2014 · 6:00 PM
  • Goodwill Columbus

Change Data Capture

Speaker: Vern Jewett, SQL database administrator and developer Improving Enterprises

Summary: Microsoft introduced Change Data Capture with SQL 2008.  Anyone who, like me, wrote triggers to capture historical data prior to that, knows how much effort it saves.  But if a table being tracked by CDC has column modifications applied, the data capture does not track the new columns.  I’ll present a simple but effective technique utilizing views, to preserve all your history from CDC, through all the changes.

About Vern: Vern Jewett, of Improving Enterprises, is a SQL database administrator and developer.  He has been in software development for over 20 years, with certifications in Microsoft SQL Server, Security+, .NET, Java, and PowerBuilder.  He is currently working at the Columbus Regional Airport Authority, as a Data Mart designer and developer.



Join or login to comment.

10 went

Our Sponsors

  • Microsoft

    Microsoft gives us the use of their facilities for free monthly

  • TEKSystems

    TEKSystems is providing financial support to CBusPASS

  • IGS Energy

    IGS provides us a hosting location

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy