PDC 2005 Videos and Slides and demos are now online

The PDC 2005 videos are now online (via http://blogs.msdn.com/mswanson/archive/2005/10/24/484434.aspx). Oleg has distilled the XML and language specific presentations. And finally, from that list, here is the pointer to my presentation: DAT405: SQL Server 2005: Deep Dive on XML and XQuerySpeaker: Michael RysManaging semi-structured and markup data is becoming an increasingly important aspect of data management….


The light at the end of the tunnel is bright sunshine!

We have RTM’ed today! Today, we have released SQL Server 2005 and VisualStudio 2005 and the .Net Framework 2.0 to manufacturing. This means the code is baked, done, shipped,… :-). It will be downloadable from MSDN within the day and available through the other channels in a couple of days. Follow the link for a…

Welcome Jinghao Liu to the Blogosphere

It is my pleasure to introduce you all to Jinghao’s weblog. He is our test lead and so far seems to cover the SQL Server 2005 XML support in Chinese :-). Please go and take a look and say 你好.

First Wars, then Tsunamis, Famines and Hurricanes, and now Earthquakes

The last year has been tough on many. Many people have been and are getting killed in wars and conflicts (Iraq, Sudan/Dafour), got devastated by Tsunamis, starve due to famines and loose their lively-hood and sometimes even lives due to Hurricanes and Taifuns such as Kathrina and Stan. And now we have the devastating earthquake…

XML related changes to the September CTP

While we are less than a month away from the official launch week of SQL Server 2005, I am still providing you with the promissed change list for the XML area in SQL Server 2005’s September CTP. And please accept my apology for the delay. Please continue here for the changes.


Changes to the default encoding handling of XML when passing XML from the client to the server.

In SQL Server 2005 versions up to the June CTP, the XML parser on the server-side defaulted to UTF-16 for documents without a leading byte-order mark and without an explicit encoding in the XML declaration. Since this was incompatible with the XML standard that defaults to UTF-8, we had reports of bugs where UTF-8 documents…

Why are you searching for "sp_xml_preparedocument Failed load msxmlsql"?

Since we got “upgraded” from .Text to Community server, we are not getting good referrer log information anymore. However, since I added some additional traffic tracking I can see a bit better again, what people are looking for(still not as good as .Text. And one of the most surprising aspects (beyond those that search my…