Welcome to the Nashville SQL Server Users Group

Our regular monthly meetings occur on the last Friday of each month from 11:30 AM - 1:00 PM. Lunch is served during the first half hour and the scheduled session begins at noon. We meet at Nova Copy which is located at 15 Lindsley Avenue, Nashville, TN 37210.

 

Next Meeting: Fri, Oct 25 2013

October User Group Meeting

Language: English
Event Type: In-Person & Online
Online Meeting URL: http://dicksonresources.us1.list-manage1.com/track/click?u=ec35a7262ff748bf7f330dfcb&id=119a91848a&e=e22dddf23b
RSVPURL: http://dicksonresources.us1.list-manage1.com/track/click?u=ec35a7262ff748bf7f330dfcb&id=413e929b5a&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.

 

When

iCal
UTC : Fri, Oct 25 2013 16:30 - 18:00
Event Time : Fri, Oct 25 2013 11:30 - 13:00 Central Daylight Time
Your Local Time: Fri, Oct 25 2013 16:30 - 18:00

Where

15 Lindsley Ave
Nashville, Tennessee

Direction: free street parking available.

Featured Presentation

Change Data Capture for Developers and DBAs

Speaker: Joe Settles, Application Development Senior Specialist HealthSpring

Summary: 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.

About Joe: 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.

Attachments


Alternate/Additional BI Meetings

Our user group is already great but we think we can make it better.  Soon we will be offering an additional meeting that will cater to the Business Intelligence crowd. EVERYONE is welcome. This meeting will be held in the Cool Springs/Brentwood area. The meeting time and location have not been secured yet but we can tell you that we are shooting for an early evening time in the middle of the week.  We will plan to have meetings every-other month until we build up a following.

If you know anyone that would like to attend, present or sponsor these meetings please have them contact  tamera.clark (at) gmail (dot) com.

 

 

TAKE THIS SURVEY! Help us get the ball rolling: https://www.surveymonkey.com/s/N5W28Y7

 

 

Exclusive Offers for User Group Members

Oreilly Book Discounts

 Thanks to Oreilly for providing us books to give away and providing a discount code for our users. Buy ebooks at 50% off and print books at 40% off: When you purchase a book or ebook on oreilly.com use the UG Program discount code: DSUG

 

Great Microsoft Learning Offers

Microsoft Learning has released a collection of valuable offers for the PASS user group community. Get the Microsoft Learning products that you want for less. Take advantage today of these special offers for home and office users, IT professionals, and developers by visiting: www.microsoft.com/learning/offers

 

Carry all your tech books with you anytime with one-click reference on Microsoft technologies

Microsoft Press has developed a virtual library for IT Professionals, developers and information workers who want to learn about Microsoft products and related technologies. And we want to share it with the Microsoft user group members. To learn more about the E-Reference Library, please click here (http://www.microsoft.com/learning/books/ereference/default.mspx).