Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Denis Ruckebusch's blog on typed XML in SQL Server 2005.
Moving on
I'm over 2 months late in writing this post. please forgive me for the delay, especially those of...
Date: 10/26/2007
Silent XQuery failures
A newsgroup post I read earlier today reminded me that there are cases where failure to get the...
Date: 04/19/2007
Stardust memories
The famous Stardust hotel and casino was torn down today. I was fond of the place since this was the...
Date: 03/13/2007
A new SQL CLR blog
One of my colleagues, Brad Richards just started blogging about SQL CLR performance. If you use SQL...
Date: 03/08/2007
xsi:nil magic (part 2/2)
Last time we looked at what happens to the xsi:nil attributes when replacing the value of a simply...
Date: 12/04/2006
xsi:nil magic (part 1/2)
A few months ago I wrote a post about the interesting behavior of the xsi:type attribute. Today...
Date: 11/30/2006
About my article in SQL Server Standard Magazine
In my previous post I mentioned the article I wrote for the September issue of SQL Server Standard...
Date: 11/15/2006
The latest issue of SQL Server Standard magazine is all about XML.
The September issue of SQL Server Standard magazine is devoted to XML. I contributed an article...
Date: 09/01/2006
Complementing XSD with CHECK constraints
I was recently asked to look at a customer’s question. This person wanted to write a schema that...
Date: 08/22/2006
xsi:type magic
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
Explaining the reasons behind some of XML datatype's limitations
If you use XML in SQL Server 2005, and especially if you use it in association with schemas, I...
Date: 06/29/2006
If you leave me now…
A man named Vincent Ferrari is making headlines today. He called AOL’s costumer service to cancel...
Date: 06/21/2006
Inserting an XML instance into another even though SQL type ‘xml’ is not supported in XQuery.
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
Restricting the contents of a typed XML column using triggers
A typed XML column/variable is constrained by a schema collection. That means only instances that...
Date: 05/12/2006
Importing the Microsoft Office 2003 schemas into the database
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
Download SP1 today!
Yesterday we released our first Service Pack for SQL Server 2005. You might remember a while back I...
Date: 04/20/2006
Importing an existing XML schema into SQL Server 2005
In my last post I addressed the issue of non deterministic content models, which can be valid with...
Date: 04/18/2006
Fixing non deterministic schemas
If you’ve been importing XML schemas into SQL Server 2005 you might have encountered this error...
Date: 02/06/2006
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...
Date: 12/04/2005
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...
Date: 10/28/2005
Branching
When I started this blog 3 months ago my sole intent was to share knowledge pertaining to the XML...
Date: 09/21/2005
DML operations on multiple nodes
If you've been playing with SQL Server 2005's implementation of XQuery for a while you probably know...
Date: 09/19/2005
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...
Date: 09/12/2005
Validating without typing
You might encounter a situation where you want to validate incoming XML instances against the...
Date: 09/07/2005
Document and content
Document and content are two options you can use in SQL Server 2005 when typing an XML column or...
Date: 08/12/2005
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...
Date: 08/03/2005
Using the XPath provided in XML validation error messages
Yesterday’s post regarding the addition of a ___location in validation error messages brought back a...
Date: 07/27/2005
Improved error messages
Somebody seems to like the fact that we recently added XPaths in validation error messages. I was...
Date: 07/26/2005
Static typing and substitution groups
Since I’ve recently talked about both static typing and substitution groups maybe it’s time to see...
Date: 07/14/2005
Substitution groups and their effects on type derivation
If you’ve been playing with Xml schema collections in SQL Server 2005, you might have noticed that...
Date: 07/11/2005
Effects of the type substitution mechanism on static typing (part II)
In this follow-up to last week’s post I’d like to look at more examples, in particular those...
Date: 06/22/2005
New blog by a SQL Server 2005 tester.
My fellow SDET Galex has started his own blog. If you're interested in the new XML functionality...
Date: 06/17/2005
Effects of the type substitution mechanism on static typing (part I)
The XML schema specs define a mechanism that allows for the use of derived types in instance...
Date: 06/16/2005
For more info on XQuery singleton issues
My fellow SDET John Gallardo has written this follow up to the post I wrote yesterday about...
Date: 06/15/2005
Single node required
This is one of the most common static typing errors you’re likely to encounter. Somewhere in your...
Date: 06/14/2005
An introduction to static typing.
XQuery in SQL Server 2005 is a statically typed language. This means type errors may be raised...
Date: 06/13/2005
Welcome
Welcome to my newly created blog. My name is Denis Ruckebusch. I've been part of the test...
Date: 06/13/2005