Welcome to MSDN Blogs Sign in | Join | Help

May 2005 - Posts

Tuesday, May 24, 2005 7:06 PM

Efficient Property Promotion from XML Instances

In many cases, when storing XML data, some of the elements/attributes will be more important for storage/querying than others. Access to values inside XML data-type instances requires additional overhead when compared with just selecting relational data
Posted by mrorke | 4 Comments
Tuesday, May 10, 2005 11:36 AM

Adding a Style-sheet Declaration to your XML Output

A common requirement for formatting XML output from XQuery expressions, is to be able to add a style-sheet declaration. Style-sheet declarations consist of a standard processing-instruction node that appears at the top-level of the XML. In the following
Posted by mrorke | 0 Comments
Friday, May 06, 2005 5:43 PM

MSDN Webcast on using XQuery in SQL Server 2005

Michael Rys (a program manager for XML technologies in SQL Server 2005) recently gave a webcast for MSDN where he covers some of the details of the new native XML data type. He gives details of basic usage, static typing, DML and indexing. Michael also
Posted by mrorke | 0 Comments
Friday, May 06, 2005 2:58 PM

New links section for whitepapers

I have added a new section under my links that points to useful whitepapers dealing with XQuery and/or XML inside SQL Server 2005. These articles contain a lot of useful details on the system and I would recommend that everyone using (or planning on using)
Posted by mrorke | 0 Comments
Friday, May 06, 2005 2:42 PM

Good Introduction to Using XML in SQL Server 2005

I just reviewed the web cast of a presentation given by one of our program managers here in the SQL Server XML team. It gives a good overview of the various features of our native XML data type, including insertion, indexing, DML and schema binding. If
Posted by mrorke | 0 Comments
Thursday, May 05, 2005 12:33 PM

De-entitizing Special XML Characters

There are several tricky issues around the serialization of special XML characters inside SQL Server 2005. This was highlighted to me earlier today when I had a question about how to output a URL value that caontains an ampersand (' & ') character
Posted by mrorke | 1 Comments
 
Page view tracker