Select Page

Change Data Capture (CDC) and BIML

Change Data Capture (CDC) is an enterprise feature of SQL Server since version 2008. 12 It’s a non not very intrusive way to collect only the changes in selected tables of your source system.3 And thus providing a way to effectively handle your data warehouse...

Truncate all Tables

There are many reasons for me to blog. One of the less vain is to recover and reuse code I wrote earlier. In my current project we have a need to test, test and retest the initial load of the data warehouse. For this purpose I wrote this T-SQL script that: This post...

Viewing or Saving the Compiled Biml File(s)

Some time ago a BIML enthusiast asked me for the location of the temporary files that BIDSHelper create when you generate the SSIS packages in BIDSHelper. I couldn’t help him and explained that the Biml Engine first compiles the Biml documents,  applying any...

Many Happy User Peaks

I wrote this blog post in august 2012, but somehow I forgot to post it. At the start of 2014 I wish every one many happy user peaks and wisdom in creating them… Recently I have been involved in converting a business intelligence (dashboard) web application. Making it...