Michael Rys - XML in SQL Server | scobleizer

Michael Rys, a program manager on SQL Server's engine team, talks with us all about XML in the upcoming SQL Server 2005.

He gives us some demos about 27:22 into the video.

Follow the Discussion

Follow
Oops, something didn't work.

Try again?

Sign In to be begin to follow these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.

Getting "follow" information

Stop following these comments

Start following these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.

Removing your "follow"

Setting up your "follow"

Did you know you can
sign up for email notifications?
- Subscribe to this comments

B® I vote for managed code!

Aug 12, 2005 at 11:56 PM

Hey cool stuff!

I won't write more.. I'll start my virtual pc right away and start playing around =)
erik_ Whooops!

Aug 13, 2005 at 3:34 PM

Hmm, I quickly skipped to the demo, because I don't got time atm to view the full video. They learn me at school to normalize everything, and with this xml insert this isn't happening or ?... should I just watch the full video tommorow?
TommyCarlier Widen your gaze

Aug 14, 2005 at 4:36 AM

erik_ wrote:

Hmm, I quickly skipped to the demo, because I don't got time atm to view the full video. They learn me at school to normalize everything, and with this xml insert this isn't happening or ?... should I just watch the full video tommorow?

I often watch the C9 videos at double speed: everything is still understandable, the demos look just as good, and you only spend half of the usual time watching.
chrisgrainger

Aug 14, 2005 at 7:38 AM

What about the sound, can you hear it at all or is it sped up?

I personally like the fully enjoy the Channel 9 videos and usually sit down at the end of a hard day and watch them. I always make time!
TommyCarlier Widen your gaze

Aug 14, 2005 at 9:13 AM

The sound is sped up, but it's still all understandable. It doesn't sound as if they used Helium And hearing Scoble laugh at double speed is just as enjoyable as normal speed.
Johannes Johannes Hansen, Denmark

Aug 15, 2005 at 5:41 PM

I really don't get the advantage of the XML column over regular relational data even though I've been to numerous events explaining the topic of XML in SQL Server 2K5. Nobody has ever presented a specific usecase for this column type that just makes me go "ahhh yes! that's cool!!!". In the cases I've heard I always have a feeling that it would be more valuable to transform the data into relational data. Am I the only one?
ernestofreyre Ernesto

Aug 16, 2005 at 6:14 AM

Rys, i have one small example for you, supouse you have some data you will keep in a relational database, you must know a priori, all kinds of data types, leaving no space for auto-extensibility, so with a XML type column you could define customized data types acordingly to the applications and have infinite numbers of data structures within a single "static" relational database model.

I have been using this kind of solutions for a while with great results, and i always had to use a text or ntext column type for storing the XML data, parsing it after, but if SQL 2K5 comes with it, even better.
shaju

Aug 17, 2005 at 2:36 PM

This was very useful and interesting video.

Thanks Michael Rys.

Cheers!!!!
Piotrek

Aug 20, 2005 at 5:14 AM

Johannes wrote:

I really don't get the advantage of the XML column over regular relational data even though I've been to numerous events explaining the topic of XML in SQL Server 2K5. Nobody has ever presented a specific usecase for this column type that just makes me go "ahhh yes! that's cool!!!". In the cases I've heard I always have a feeling that it would be more valuable to transform the data into relational data. Am I the only one?

You're not

Of course it looks intresting for a all-XML-data supply chain, for improved security, for interroperability between XML able products. But no "ahhh yes! that's cool!!!" that gives you the power to code in the night.

I'm waiting the results of the http://www.csdevcompetition.com/ contest...
M.Rys

Aug 28, 2005 at 3:19 PM

Thanks for the comments.

Regarding the killer use cases for XML: I try to address this somewhat in the non-demo part. If your XML describes basically relational data that you want to repurpose, slice and dice in different ways, shredding it into relational form and doing normalization is a good idea. If the XML OTOH is representing a markup document (such as a WordML or XHTML document), or the XML represents a logical unit (aka object) which you want to store and retrieve as efficiently as possible while still having the ability to query into its components, storing the data as XML is easier and often preferrable.

Best regards
Michael