Denver SQL Server User Group March 2015 #denversql

Thanks to everyone that attended my "Near Real-Time Data Warehouse Updates with CDC and SSIS" presentation at the Denver SQL Server User Group meeting last night. For anyone that wants my slides and demo scripts, you can download them from the link below:



Thanks again and I hope to see you all again at a future Denver SQL Server User Group meeting!

Boulder SQL Server User Group March 2015 #bouldersql

I had a great time presenting to the Boulder SQL Server User Group last night, thanks to Mark Tillman and Paul Paiva for having me present "Change Data Capture (CDC) and SSIS". Lots of great interaction from the attendees. For anyone that wants my slides and demo scripts, you can download them from this link:



Thanks again to everyone from the Boulder SQL Server User Group and the attendees that came out last night!

Presenting at Colorado User Groups! #sqlfamily #sqlpass

I will be presenting at both the Boulder SQL Server User Group and Denver SQL Server User Groups next week! I'm looking forward to doing my Change Data Capture (CDC) with SSIS talk at both groups. I've been doing this talk at SQLSaturdays across the country, but this will be the first time that I have done it in Colorado since April 2014 at SQLSaturday #297 in Colorado Springs.

For more details about the Boulder SQL Server User Group meeting on Wednesday, March 18th at 5:30pm and to RSVP, please visit their Meetup.com website.

For more details on the Denver SQL Server User Group meeting on Thursday, March 19th at 5:30pm, please visit denversql.org.

Looking forward to meeting all of you that can make it out to Boulder and/or Denver on Wednesday and/or Thursday next week!

Mile High Tech Con - Demo/Slides #MHTechCon

Thank you to everyone that attended my "Capture Change and Apply it with Change Data Capture and SSIS" session at Mile High Tech Con on Saturday. I have uploaded the zip file that has both the demo solutions and the slides.


Thanks to Marc Beacom and all of the other volunteers at the Mile High Tech Con, was a great event and glad that there will be another technical event here in the Denver area each year!

Charlotte BI Group - August Meeting

I had the pleasure of presenting my "Capture Change and Apply It with Change Data Capture and SSIS 2012" session at Tuesday evening's Charlotte BI Group to a full room with lots of great questions asked by the attendees. For those that attended, thank you very much for your comments and questions and to the organizers of the group: Javier, Melissa, Jason and Rafael thank you all for letting me present and meet with your group.

For those that want to see the slides that I presented and try out the demos that I showed in the presentation, below is a link to download everything.


The requirements for these samples to work are SQL Server 2012 Evaluation, Developer or Enterprise Editions, AdventureWorks2012 and AdventureWorks2012DW. Also as I mentioned in the session you must have full admin rights to the SQL Server instance that you are going to try and setup CDC on, so a local instance on your own workstation/VM is recommended.

Thanks again and I will see you all again in October at PASS Summit 2013 in Charlotte and/or SQLSaturday #237!

Midlands SQL Server User Group - June 2013 Monthly Meeting

Thank you to all of those that came to the Midlands SQL Server User Group meeting tonight in the Columbia, SC area. I presented my "Capture Change and Apply it With Change Data Capture & SSIS 2012" session and there were lots of good questions that I hope will lead to at least some of the attendees trying out CDC in their environments!

Below is the link that I promised during the session to download both the presentation slides and all of the scripts and code that I used in the demo.


The requirements for these samples to work are SQL Server 2012 Evaluation, Developer or Enterprise Editions, AdventureWorks2012 and AdventureWorks2012DW. Also as I mentioned in the session you must have full admin rights to the SQL Server instance that you are going to try and setup CDC on, so a local instance on your own workstation/VM is recommended.

SQLSaturday #200 - Philadelphia

Thanks to everyone that attended my "ABCs of CDC with SSIS 2012" at SQLSaturday #200. Got lots of great questions during the session and great reviews/feedback after the session as well. As promised, here is the link to download all of the materials from the session.

I had a fantastic time in Philly visiting with my Dad, who lives in the area and getting to do the tourist thing for a couple days. Even got to try the famous Pat's Cheesesteak (witout onions) and visit the Valley Forge National Park. Lots of fun and hoping that I don't wait another 15 years to get back to Philadelphia.

Thanks again to all of the organizers/sponsors/speakers/volunteers of the SQLSaturday #200 event, things ran very smooth and it was a good turnout. I was honored to be part of the bi-centennial event and to meet so many new people.

Denver SQL Server User Group - May 16, 2013

Last night I presented "Capture Change and Apply it with Change Data Capture and SSIS" at the Denver SQL Server User Group meeting as a representative of our sponsor for May, Pragmatic Works. Session went well, got some really good questions and comments to make the session even better which I will be working on before I present it again at the Midlands SQL Server User Group next month!

For those that want to use all of my sample code from the presentation, feel free to download it from the embedded link below and try it out on your own computer. The requirements for these samples to work are SQL Server 2012 Evaluation, Developer or Enterprise Editions, AdventureWorks2012 and AdventureWorks2012DW. Also as I mentioned in the session you must have full admin rights to the SQL Server instance that you are going to try and setup CDC on, so a local instance on your own workstation/VM is recommended.

Thanks again to all of those that attended the Denver SQL Server User Group meeting last night!

ABCs of CDC with SSIS 2012 - Addendum

I have been presenting the "ABCs of CDC with SSIS 2012" session for a few months now at various User Groups and SQLSaturdays and I learn something new about CDC (Change Data Capture) and the other similar options available in SQL 2012 each time I present it. As I was searching for information the other day I discovered a feature that was delivered with the RTM (Release to Manufacture) version of SQL 2012 that I had not heard about before, Change Data Capture for Oracle by Attunity.

This feature is a way for SQL Server DBAs to get all of the benefits of CDC from Oracle databases. The executables for this feature are on the install media for SQL 2012 in the Tools\AttunityCDCOracle folder (available in both x64 and x86 versions). The 2 executables are AttunityOracleCdcDesigner.msi and AttunityOracleCdcService.msi. Both of these executables are installed on a Windows Server, not on the Oracle system itself (unless you are running Oracle on Windows). So the server that you are installing on needs to be able to connect to the Oracle database(s) that you are trying to capture data and changes on. The Service executable is the one that always runs on the Windows Server and pulls all of the changes from the Oracle database(s) to the Windows Server to be stored on a SQL Server instance in the same form that CDC on SQL Server stores changes. The Designer executable is the administration front-end for setting up the service, which will launch as an MMC (Microsoft Management Console) snap-in.

Once you have these changes in the SQL Server database, then you can use all of the same processes you use for SQL Server CDC data, including using the new CDC components in SSIS 2012.

For more details on getting this installed, this link will take you to the TechNet article covering this feature.

To see the applications in action, this link will take you to the video of a presentation done at PASS Summit 2011 by Matt Masson and representatives from Attunity (fast forward to around 10:50 to see this feature).

The best part of this is that since it is a built-in feature of SQL Server 2012, it's free to use with SQL Server 2012!