Introduction to SQL Server XML Schemas, Part 1

This video introduces you to XML schemas and how to work with them in SQL Server. Why do you need an XML schema? One big reason is that it allows you to strongly type your XML columns - in other words, it forces users/developers to save documents that match the format you require.

Kendal Van Dyke is a Senior DBA with Channel Intelligence in Celebration, Florida. He uses XML extensively in the database at work and believes that the improvements to XML handling in SQL 2005 substantially change how and why we handle XML.

Matt Dobson on 11/18/2008

informative.

Dave on 11/27/2008

A good basic example for those who don't already know how to do this in SQL Server.

John O'Sullivan on 12/3/2008

A great video Is it possible to download the sample SQL scripts from the videos ?

Eric Beser on 12/3/2008

Should show updating of data as well as inserting data. Otherwise excellent video

Francis on 12/3/2008

Excellent intro! I'm looking forward to the remaining parts.

Munawar on 12/3/2008

very good

Stephen Anslow on 12/3/2008

Very hard to see the screen content - took almost 2/3 the length of the video to zoom, resize, etc to even see still-fuzzy content.

Jeff on 12/3/2008

Nice and informative. I wish to see a video around 10 to 15 minutes long so a little bit deeper and wider coverage can be provided.

cechode on 12/19/2008

short and to the point. thank you

Prasanna Prabhu on 2/3/2009

Should have provided few more sample INSERT conditions, to demonstrate what all FAILS & what all SUCEEDS insert

M Hoss on 2/19/2009

Thanks for the short demo...

Rizwan Gulamhussein on 2/23/2009

Excellent! Love to learn this way.

Dean Gross on 2/7/2010

well done

Andy on 5/25/2010

What was a minefield, was cleared in 3:04 mins. Great Intro!

Olu on 3/8/2011

Very good - I've learnt a lot. I quite like the fact that you can define the format of the expected data and thus prevent a lot of errors.

Dennis Wetherall on 3/15/2011

You are a great teacher! Thanks.

Carla Wilson on 4/29/2011

I had to watch it twice to catch everything, and pause several times, but excellent information.

Ousainou Jallow on 5/18/2011

VERY FAST AND SHORT

Jason on 5/18/2011

Question... Is there a way to send in extra tags that might not be defined in the XML schema? Like a table sent in that has extra columns that can be ignored? I only want to validate the columns received in the XML. I primarily am using XML Schema for performance reasons.

Carlos B. Vasquez on 5/18/2011

Awesome!!!

Jeff Benedict on 5/18/2011

Great Job

john.baughn on 5/18/2011

Short and to the point. Nice.

WChaster on 5/18/2011

Look so much like a database table, when would you use an XML schema over a database

matt shea on 6/8/2011

very clear

Steve Harris on 6/9/2011

need more explanation about xml and how to access it

Eric on 1/11/2012

Loved it! Well-prepared, well-rehearsed, and packed with information! I have little XML in SQL Server experience, so I definitely want to try your example. Where can I find the T-SQL that was shown in the video? ericbragas@yahoo.com