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.
We’ve updated the MSDN whitepapers and added new ones. Here are the links:
XML feature overview: http://msdn.microsoft.com/xml/default.aspx?pull=/library/en-us/dnsql90/html/sql2k5xml.asp
XML Best Practices: http://msdn.microsoft.com/xml/default.aspx?pull=/library/en-us/dnsql90/html/sql25xmlbp.asp
XML Optimizations: http://msdn.microsoft.com/xml/default.aspx?pull=/library/en-us/dnsql90/html/sqloptxml.asp
XML Generation from tables: http://msdn.microsoft.com/xml/buildingxml/xmlanddatabase/default.aspx?pull=/library/en-us/dnsql90/html/forxml2k5.asp
XML Options in Microsoft SQL Server 2005: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5xmloptions.asp
Introduction to XQuery in SQL Server 2005: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_xqueryintro.asp
The XML optimizations and XML best practices whitepapers in particular have much more content – some of the new optimizations are very cool! Check these out by following the appropriate links.
When you read these whitepapers, please take a moment to rate their content and their presentation.
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.