Welcome to the Cincinnati Professional Association for SQL Server!

CincyPASS is a professional organization/user group dedicated to all aspects of SQL Server from database administration to application development and business intelligence.

Our meetings occur every month on the 3rd Tuesday, in the Microsoft office located at 4445 W Lake Forest Drive, Suite# 100, Blue Ash, OH 45242. Please ensure to register to help us plan for food. Unless noted otherwise the monthly meeting agenda will be

  • 5:30 - Networking and Food
  • 6:00 - PASS news and Announcements
  • 6:15 - Featured Presentation
  • 7:15 - Q&A Session / Door Prizes


Next Meeting: Tue, Aug 20 2019

Implementing SQL Server Audit Trails: CDC vs Temporal Tables vs Triggers

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/CincyPASS/events/263155931/



UTC : Tue, Aug 20 2019 21:45 - 23:45
Event Time : Tue, Aug 20 2019 17:45 - 19:45 Eastern Daylight Time
Your Local Time: Tue, Aug 20 2019 21:45 - 23:45


7755 Montgomery Rd
Cincinnati, Ohio

Direction: None

Featured Presentation

Implementing SQL Server Audit Trails: CDC vs Temporal Tables vs Triggers

Speaker: Kevin Goff, SQL Server Consultant/Instructor Independent

Summary: Many organization requires full change history of all database data - what values changed, who changed the values, and when Until SQL Server 2008, the most full-proof way to capture changes was with Database Triggers. And then Microsoft added CDC (Change Data Capture) to the database Engine in SQL 2008. Finally, Microsoft implemented Temporal Tables in SQL Server 2016. If you are looking at the implementing full change history for the first time,or if you have been using one approach and would like to know the specifics of the other approaches, this session is for you. In this session, I'll walk through multiple scenarios for CDC, Temporal Tables and Triggers. I'll show the benefits of each one, and things you need to be aware of.

About Kevin: Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP Database architect/developer/speaker/author Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics Frequent speaker at community events in the Mid-Atlantic region. Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics






Back to Top