SQLAuthority News – Birds-of-a-Feather (BOF) Lunch – SQL PASS Summit, Seattle, 2009

I received few emails regarding where can people meet me at SQL PASS event in Seattle. I am currently in Bellevue attending Itzik Ben-Gan’s class. I am immensely enjoying the class, and I shall post details about the class once it is over. If you are attending SQL PASS and…
Read More

SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008

Change data capture (CDC) is a new feature in SQL Server 2008 designed to capture insert, update, merge, and delete activities applied to SQL Server tables and to avail those changes in an easy-to-understand format. Conventionally, detecting changes in a source database to transfer these changes to a data warehouse…
Read More

SQLAuthority News – Best Practices for Integration Services Configurations

Best Practices for Integration Services Configurations by Jamie Thomson This article explains what SQL Server Integration Services configurations are used for, why you should use Integration Services configurations, and what options you have for leveraging configurations. It will also make some simple recommendations that are based on my experiences of…
Read More