Michael Rys

Musings on XML, XQuery and more...

<October 2008>
SuMoTuWeThFrSa
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678


Navigation

Papers

SQL Server XML Whitepapers

Weblogging Links

MS Bloggers

Recommended Books

Other Blogs

Recommended Links

Presentations (Upcoming)

Presentations (Recent)

Subscriptions

News


Upcoming Presentations


TechEd 2007, Orlando, June 4 to June 8, 2007


Books I co-authored



www.flickr.com
This is a Flickr badge showing public photos from Michael Rys. Make your own badge here.
eXTReMe Tracker

Post Categories

Article Categories



SQL Server 2005 and Visual Studio 2005 Launches

Today is the big launch. Steve B. is giving the launch keynote in San Francisco. I am currently sitting in a meeting room at a competitor's place where I am at for a W3C XQuery meeting watching the live webcast during our lunch break :-). I already provided a list of many (but not all) of the new and improved features of SQL Server 2005. Today's launch has some additional cool tidbits:

On the XML side, we have no benchmarks yet (we should probably design some). But we have several both internal and external customers that built and deployed applications with SQL Server 2005's XML features. One of our internal sites replaced a 4000 line FOR XML EXPLICIT query with a 300 line FOR XML PATH query. Several of the early adopters of SQL Server 2005 already make use of the new XML datatype for storing documents. Some have documents that conform to their respective industry standard schemas. Others use XML and XQuery to process data that quickly changes its shape or is provided by their customers. Since I have not asked for their permission to be named on my blog, I probably better don't give out their names. I will see, if we can show-case one or two over the next couple of months if there is interest. In any case, such real world customer scenarios are in the end much more important than artificial benchmarks. And your feedback on performance and functionality will help us give you an even better experience in future releases.

Some other noteworthy SQL Server 2005 tidbits from the launch:

  • The SQL Server 2005 Express Edition has a management tool! It is currently a CTP release, but mainly to be able to give it a beta cycle. It is available for download from the MSDN site for free (as are VS 2005 Express and SQL Server Express).
  • About 50 hosting services will provide support for VS 2005 and SQL Server 2005 starting today. Maybe I should find some spare time to build something myself :-).

As to my launch involvement: I will be speaking at the two Swiss launch events later this month and I will also give the launch keynote in Athens, Greece on December 6th. On the way back I got invited to speak at and meet with the Swedish SQL Server user group in Stockholm. If you hang out in any of these areas, I am looking forward to meet you!

posted on Monday, November 07, 2005 11:35 AM by mrys


# re: SQL Server 2005 and Visual Studio 2005 Launches @ Monday, November 07, 2005 3:01 PM

I'll actually be in Lausanne when you are presenting but unfortunately can't make it -- consulting calls. Best of luck though -- looks like it will be a great day.

Damian (PromptSQL)

Damian Mehers

# re: SQL Server 2005 and Visual Studio 2005 Launches @ Monday, November 07, 2005 11:25 PM

Just one question:

What madman wrote a 4000-line FOR XML EXPLICIT query instead of just doing the work in the app tier!?

Adam Machanic

# re: SQL Server 2005 and Visual Studio 2005 Launches @ Tuesday, November 08, 2005 12:53 PM

Hi Adam

Over the last years, I met a few people that wrote even larger FOR XML EXPLICIT mode queries (the largest that I remember hearing about was about 6000 lines). The interesting part is that they were all very happy with the performance, but hated the maintainability of the query.

Doing the construction of the hierarchy on the server often performs much better than doing it in client-code, since you have less data movement from the server to the client.

mrys

# What do you want to see regarding XML support in the next version of SQL Server? @ Saturday, November 26, 2005 4:25 AM

Now that we have shipped SQL Server 2005, I would really like to hear from you what you want us to do...

Anonymous

# What do you want to see regarding XML support in the next version of SQL Server? @ Saturday, November 26, 2005 4:29 AM

Now that we have shipped SQL Server 2005, I would really like to hear from you what you want us to do...

Anonymous

# Michael Rys - What do you want to see regarding XML support in the next version of SQL Server? @ Tuesday, November 29, 2005 12:09 PM

Anonymous

# Report from the W3C XQuery and XSLT WG Meeting @ Thursday, November 02, 2006 3:11 PM

Hello all
I hope I still have some readers... Sorry for having been quiet over the last year. I will...

Anonymous




Powered by Dot Net Junkies, by Telligent Systems