First of all, I'd like to thank all those who took the time to attend my presentation today (Nov 8, 2005). I hope you found it useful. The launch of SQL Server 2005, Visual Studio 2005 and BizTalk Server 2006 is a matter of great pride and honor for us...

I made at presentation on September 1st on our XQuery implementation at the International Conference on Very Large Databases at Trondheim, Norway. The paper contains a lot of useful information, which, I hope, you will enjoy. The link is: http://www.vldb2005...

Setup upgrade to June CTP of SQL Server 2005 is unavailable. Typically, you would uninstall the existing build of SQL Server 2005, install the June CTP, and attach your database files to the server. After Beta 2 of SQL Server 2005, we have made...

SQL Server 2005 June CTP was released earlier this month. It contains many improvements and is a very important milestone on the way to RTM. If you haven’t upgraded yet, please do so! For the native XML support, I’d like to point out the following. ...

I have seen a few scenarios in which a value is extracted from an XML data type instance in SQL Server 2005. The query performs some checks on the value such as its type (e.g. whether it is numeric) or compares it with a constant, and returns a value...

Hello! This posting contains T-SQL script for working with typed (i.e. XML schema bound) XML. I used it during the MSDN webcast on Tue, Dec 7, 2004, on “Introducing XML in SQL Server 2005”. Yesterday’s posting ( http://weblogs.asp.net/spal/archive/2004...

I made an MSDN webcast on Tue, Dec 7, 2004, on “Introducing XML in SQL Server 2005”. I showed a couple of T-SQL scripts that many of you found useful. This posting contains the demo script for working with untyped XML data. My apologies for the delay...