The SSIS Balanced Data Distributor (BDD) spreads incoming rows across outputs with multithreading. How it works and the scenarios where it improves performance.
SQL SERVER – What is AdventureWorks?
What is AdventureWorks? Why I use this SQL Server sample database in my examples, how it replaced Northwind and Pubs, and where to get it.
SQL SERVER – SQL Server RDL Specification
The RDL Specification describes Report Definition Language, the XML schema behind SQL Server reports. I list the 2000, 2005 and 2008 versions.
SQL SERVER – Introduction to Service Broker and Sample Script
Here is my introduction to Service Broker and sample script: messaging and queuing between instances, conversations and dialogs in SQL Server 2005.
SQL SERVER – Order of Hotfix and Service Pack
What is the right order of hotfix and service pack installs? You do not need every older service pack. Install the latest service pack and hotfix and you are done.
SQLAuthority News – Download – SQL Server 2008 Developer Training Kit
Download the SQL Server 2008 Developer Training Kit by Microsoft to learn how to build web applications with the new data types in SQL Server 2008.
SQLAuthority News – TechEd India 2009 – Day 0 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Catch Me Live
I am at TechEd India 2009 in Hyderabad, leading a session on SQL Server Management Studio 2008 new features. Catch me live and grab my SQL Server cheat sheet.