Typed XML in SQL Server 2005
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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive Date: 10/28/2005
Branching
When I started this blog 3 months ago my sole intent was to share knowledge pertaining to the XML...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive Date: 09/12/2005
Validating without typing
You might encounter a situation where you want to validate incoming XML instances against the...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive Date: 07/27/2005
Improved error messages
Somebody seems to like the fact that we recently added XPaths in validation error messages. I was...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive 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...
Author: MSDN Archive Date: 06/13/2005
Welcome
Welcome to my newly created blog. My name is Denis Ruckebusch. I've been part of the test...
Author: MSDN Archive Date: 06/13/2005