I been spending last few months in this project for the connected systems developer competition. After looking at some of the features of SQL server 2005, the one things that attracted me a lot as an Integration person is SERVICE BROKER, which helps your to build scalable, reliable, asynchronous messaging style communication between two SQL Servers (whether its local or situated remotely). Cool thing is SERVICE BROKER is included in the free version of the product SQL EXPRESS as well (there are ...
[More]