Next Meeting: Fri, Oct 25 2013
October User Group Meeting
Event Type: In-Person & Online
Online Meeting URL: http://dicksonresources.us1.list-manage1.com/track/click?u=ec35a7262ff748bf7f330dfcb&id=119a91848a&e=e22dddf23b
As usual, food and drinks will be provided free of charge. We ask that you please RSVP on our new registration link (NO LATER than 4pm on Thursday) Register so that we can account for the food and name tags.
Our sponsor this month is CTS. CTS is a privately held, regional IT consulting firm that provides business intelligence, quality assurance, application integration, software development, and portals and collaboration consulting services to enterprise clients. CTS has offices in Atlanta, Ga.; Birmingham, Ala.; Charlotte, N.C.; Chattanooga, Tenn.; Nashville, Tenn.; and Mobile, Ala. For more information on CTS, please visit their website at www.askcts.com.
UTC : Fri, Oct 25 2013 16:30 - 18:00
Event Time : Fri, Oct 25 2013 11:30 - 13:00 (GMT-06:00) Central Time (US & Canada)
Your Local Time: Fri, Oct 25 2013 16:30 - 18:00
15 Lindsley Ave
Direction: free street parking available.
Change Data Capture for Developers and DBAs
Joe Settles, Application Development Senior Specialist HealthSpring
Change Data Capture (CDC) provides a method to store and retrieve changes from Inserts, Updates and Deletes made to SQL Server data. Metadata stored with the captured changes facilitates easy change retrieval for many potential uses like transfer to a data warehouse. This presentation shows how CDC works using multiple code demonstrations. The first demo illustrates how to configure CDC and capture changes. The next demonstrates practical data capture scenarios using Template Explorer code samples. Finally, we will explore approaches to tuning CDC and time permitting overview SSIS Controls for CDC in SQL Server 2012.
Joe Settles has more than 25 years of IT experience in industries such as manufacturing, education, health care, and banking as well as nonprofits. He has also run several small companies. In the early 90's Joe founded Integrated Technologies, Inc. to help companies reduce costs through technology integration, custom databases and automation of business functions. In 2003 he joined one of his healthcare clients and helped build the company from 20 to 500 employees in less than seven years. He is currently at Cigna / HealthSpring developing financial applications using SQL Server. His previous work included projects for General Electric, First American Bank, Magnatek, AmMed Direct, United Way, and JC Bradford to name a few. Joe holds an MS in Industrial Engineering from UT, an MS in Chemical Engineering from UK and a BA in Chemistry from Vanderbilt.