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...

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...

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...

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...

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...

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...