One of the most interesting new features in SQL Server 2005 is Service Broker. If you need more details on what it is and why you would want to use it, I will let the expert tell you . But, if you want to get it setup and configured on your machine now...

In my last post , I said we would look at how we could return a table that contains a directory listing of all the .xml files on my machine. Using the SQL/CLR LoadFile method we created in the last post, our goal is to come up with a single T/SQL statement...

Up until now, XML documents have generally languished as mere files in the lowly file-system, our relational database systems haven’t seen them as important enough to warrant inclusion, up until SQL Server 2005 that is. In SQL Server 2005, XML documents...

As we work on wrapping up the Microsoft SQL Server 2005 release (formerly known as 'Yukon'), I am taking some time to play with some of the newer features, looking for those last, hard to find, bugs that maybe still hiding out. As I come across topics...