Working on SP1

It’s funny how I thought that with SQL Server 2005 out the door I’d have more time to spend on this blog and other long-delayed projects. Boy was I wrong! We kicked the SP1 work in high gear the minute we shipped SQL Server. I probably cannot reveal much at this point but if you’re a user…

1

The long road to SQL Server 2005 ends here.

This blog’s been very quiet this past couple of weeks, and for a very good reason; we were all hard at work putting the finishing touches to SQL Server 2005. We RTM’ed yesterday and if you’re an MSDN subscriber you can already download it (along with Visual Studio 2005). I joined the SQL Server team…


Branching

When I started this blog 3 months ago my sole intent was to share knowledge pertaining to the XML data type in SQL Server 2005. I didn’t think I’d write about anything else. I didn’t even think there was anything else I wanted to write about. Well, it turns out I was wrong. When I…


DML operations on multiple nodes

If you’ve been playing with SQL Server 2005’s implementation of XQuery for a while you probably know that “delete” is the only operation that allows for multiple target nodes. For example, let’s imagine that we have the following table CREATE TABLE mySchemas (xmlCol XML)go Let’s say we use this table to store XML schemas (this…

2

How to preserve whitespaces

For once I’m going to venture outside of the realm of typed XML and address an issue that might be of concern to users of untyped XML as well. We’ve been asked a few times if we had a solution to preserve non-significant whitespaces in an XML instance. The short answer is “Yes”. First, let’s…

1

Windows Media Center’s popularity on the rise

According to this report Media Centers are gaining in popularity. I bought one myself a week ago and I’m very happy with it. I was looking at purchasing a new desktop, mainly for work-related activities, and for my wife to edit her digital pictures. As I kept thinking about it I realized that I wanted a media…

7

Validating without typing

You might encounter a situation where you want to validate incoming XML instances against the contents of an xml schema collection, but you still want to store your XML data as untyped. We’re going to look at a very simple way to do this. All you have to do is add a CHECK constraint to…


Sad and grateful all at the same time

I apologize in advance for a post that has nothing to do with SQL Server but I have this urge to express the sorrow and anger I’ve been feeling these past few days. Before you go any further please be mindful that the opinions expressed in this post are solely mine and may not be shared by…

6

Document and content

Document and content are two options you can use in SQL Server 2005 when typing an XML column or variable with an XML schema collection.To put it simply document means only XML documents should be accepted (exactly one top level element) while content means fragments should be accepted (0 or more top level elements). By…


Back from TechReady

I spent a good portion of my day at TechReady as a proctor for the hands-on labs. I met a few people who were going through the “XML Capabilities” tutorial. Unfortunately my duties in the lab prevented me from attending our PM’s talk on XML. On the bright side I got a chance to run the…