Saturday, February 19, 2011

How does the SQL Server engine guarantees that Change Data Capture has extracted the necessary transactions from the transaction log file before log truncation occurs.

As you know Change Data Capture harvests transactions from the log file. I was wondering what happens when the log file gets truncated during transaction log backups or when an automatic checkpoint takes place on a database in simple recovery mode causing log truncation. What if the CDC job has not harvested those records in the portion of the log to be truncated. I had the feeling that the SQL Engine ensured that this would not happen but I wanted to understand the internals of this process. turns out, with all the information available about CDC it was hard to find a straight answer on this. But I did. 

Wednesday, January 12, 2011

My SQL saturday #62 schedule

My SQL Saturday #62 schedule:

This are the sessions I think I will be attending:

8:30      Efficient Data Wharehouse Design
9:45      SSIS Cafeteria
11:00    Cool tricks to pull from your SSIS hat
12:15    Accelerating BI Development with BI xPress
1:30      MDX 201
2:45      SQL Smackdown: SSIS Vs PowerShell
4:00      Creating a Metadata Mart w/ SSIS - Data Governance

It will be very SSIS oriented as you can see.

Hope to get a chance to catch up with many of you during this SQL Event