Welcome to MSDN Blogs Sign in | Join | Help

July 2005 - Posts

Setup Secure SQL Server Service Broker across databases in less than 10 seconds!

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
Posted by stuartpa | 7 Comments

Table Valued Function magic in SQL Server 2005 using the new SQL/CLR integration

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
Posted by stuartpa | 9 Comments

Getting those XML files into your brand spanking new relational database system

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
Posted by stuartpa | 10 Comments

Wrapping up Microsoft SQL Server 2005 - looking at the new features

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
Posted by stuartpa | 3 Comments
 
Page view tracker