SQL Server 2000 SP4 and Reporting Services SP2 beta accepts self nominations

Since not everything we are doing is focusing on SQL Server 2005, it is my pleasure to point you to the SQL Server 2000 SP4 (and RS SP2) beta self-nomination page at http://www.microsoft.com/sql/evaluation/betanominations.asp. SP4 is available both for 32-bit SQL Server 2000 and 64-bit SQL Server (note that in the later case it is really SP1,…

6

Posts on FOR XML

Here are a bunch of links explaining FOR XML. It covers some FOR XML EXPLICIT functionality and focuses on the new capabilities in SQL Server 2005. FOR XML EXPLICIT or the “Query from Hell“ in SQL Server 2005: A less likely encounter Moving FOR XML EXPLICIT to the new PATH mode: Part 1 Part 2…

5

SQL Server 2005, MySpace.com and Quiznos: What do they have in common?

Now that we have shipped SQL Server 2005, I am happy to see that people are interested in using it. Today, I ask you the following riddle: What does SQL Server 2005, MySpace.com and Quiznos have in common? Well, here is the answer: Here is a link to Rick Penwell’s blog on the MySpace next…

4

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…

4

XML Support in SQL Server 2005 has no dependency on http.sys

A recent blog post claimed that the native XML support in SQL Server 2005 has a dependency on http.sys and thus is only available on Win 2003 Server or Win XP/SP2. This is incorrect. XML has no such dependency and should be available on all platforms where SQL Server 2005 is supported. Only the HTTP/SOAP…

3

Official statement on cutting XQuery from the .Net Framework is now on MSDN

We have had some discussions about the cutting of XQuery from the .Net Framework in VS2005. Since some people felt that we have not given an official statement yet (weblogs are not official enough :-)) and there still seem to be some people that are not reading weblogs, we have published the official statement on…

3

Do you see "Failed to load Msxmlsql.dll" when using the April CTP with OpenXML?

As part of our improvements on OpenXML, we have changed the MSXML component from 2.6 to 3.0 (running in 2.6 backwards-compatibility mode) and moved to a private DLL (called MSXMLSQL.DLL) in order to avoid the reboot requirement when installing SQL Server 2005. This change has been released the first time in the April CTP and…

2

New XQuery and XSLT Working Drafts: We are making progress!

The XML Query and XSL Working Groups have released the following Working Drafts of XML Query 1.0, XSL 2.0, XPath 2.0 and supporting documents. The goal of this release is to permit public review of changes made in response to Last Call comments. These documents are very close to the so called Candiate Recommendation that…

2