Typed XML in SQL Server 2005
Denis Ruckebusch's blog on typed XML in SQL Server 2005.
I'm over 2 months late in writing this post. please forgive me for the delay, especially those of...
Date: 10/26/2007
A newsgroup post I read earlier today reminded me that there are cases where failure to get the...
Date: 04/19/2007
The famous Stardust hotel and casino was torn down today. I was fond of the place since this was the...
Date: 03/13/2007
One of my colleagues, Brad Richards just started blogging about SQL CLR performance. If you use SQL...
Date: 03/08/2007
Last time we looked at what happens to the xsi:nil attributes when replacing the value of a simply...
Date: 12/04/2006
A few months ago I wrote a post about the interesting behavior of the xsi:type attribute. Today...
Date: 11/30/2006
In my previous post I mentioned the article I wrote for the September issue of SQL Server Standard...
Date: 11/15/2006
The September issue of SQL Server Standard magazine is devoted to XML. I contributed an article...
Date: 09/01/2006
I was recently asked to look at a customer’s question. This person wanted to write a schema that...
Date: 08/22/2006
As I said in my previous post, the past few weeks have been demanding and I had little time to spend...
Date: 08/11/2006
If you use XML in SQL Server 2005, and especially if you use it in association with schemas, I...
Date: 06/29/2006
A man named Vincent Ferrari is making headlines today. He called AOL’s costumer service to cancel...
Date: 06/21/2006
Since we shipped SQL Server 2005 I have seen a few users ask if there was a simple way to insert an...
Date: 05/17/2006
A typed XML column/variable is constrained by a schema collection. That means only instances that...
Date: 05/12/2006
As promised earlier I'm going to give you an example using a real-world schema. I've chosen to work...
Date: 05/02/2006
Yesterday we released our first Service Pack for SQL Server 2005. You might remember a while back I...
Date: 04/20/2006
In my last post I addressed the issue of non deterministic content models, which can be valid with...
Date: 04/18/2006
If you’ve been importing XML schemas into SQL Server 2005 you might have encountered this error...
Date: 02/06/2006
It's funny how I thought that with SQL Server 2005 out the door I'd have more time to spend on this...
Date: 12/04/2005
This blog’s been very quiet this past couple of weeks, and for a very good reason; we were all hard...
Date: 10/28/2005
When I started this blog 3 months ago my sole intent was to share knowledge pertaining to the XML...
Date: 09/21/2005
If you've been playing with SQL Server 2005's implementation of XQuery for a while you probably know...
Date: 09/19/2005
For once I'm going to venture outside of the realm of typed XML and address an issue that might be...
Date: 09/12/2005
You might encounter a situation where you want to validate incoming XML instances against the...
Date: 09/07/2005
Document and content are two options you can use in SQL Server 2005 when typing an XML column or...
Date: 08/12/2005
I spent a good portion of my day at TechReady as a proctor for the hands-on labs. I met a few people...
Date: 08/03/2005
Yesterday’s post regarding the addition of a location in validation error messages brought back a...
Date: 07/27/2005
Somebody seems to like the fact that we recently added XPaths in validation error messages. I was...
Date: 07/26/2005
Since I’ve recently talked about both static typing and substitution groups maybe it’s time to see...
Date: 07/14/2005
If you’ve been playing with Xml schema collections in SQL Server 2005, you might have noticed that...
Date: 07/11/2005
In this follow-up to last week’s post I’d like to look at more examples, in particular those...
Date: 06/22/2005
My fellow SDET Galex has started his own blog. If you're interested in the new XML functionality...
Date: 06/17/2005
The XML schema specs define a mechanism that allows for the use of derived types in instance...
Date: 06/16/2005
My fellow SDET John Gallardo has written this follow up to the post I wrote yesterday about...
Date: 06/15/2005
This is one of the most common static typing errors you’re likely to encounter. Somewhere in your...
Date: 06/14/2005
XQuery in SQL Server 2005 is a statically typed language. This means type errors may be raised...
Date: 06/13/2005
Welcome to my newly created blog. My name is Denis Ruckebusch. I've been part of the test...
Date: 06/13/2005