Originally posted: ZogBlog::road less traveled, on September 8th, 10:19p EST.
What happened? Marc Schweigert (marksc@microsoft.com) covered a few of the upcoming features in SQL 2005 while we sat back and ate free Pizza.
Who was there? 20 or so Indian's (not American Indian, unless you mean person who migrated from India), 10 or so white guys (many who were in clothes they bought in the 70s), and 3 women (woo-hoo!). Olga was probably the cutest. But none of this has anything to do with development... so, back on topic.
Coolest features?
- Using XQuery (XPath injected into T-SQL) to query, edit and manipulate XML tag data inside SQL
- A new Try-Catch capability has been added to T-SQL
- DTS has been completely re-written
- MMC has been booted!!! (hip-hip hooray!!) in favor of a Management Studio and a BI Studio (both made using the VS shell)
- PIVOT capability (like in Excel)
- CDE (sp?) - I didn't quite grok this, but my SQL-intensive co-worker was practically hooting and hollering
Slides? They promised to post them soon.
Updated (12/10/2004): I just did a quick search... and found them here.
In addition, I met Aimee Sprung (aimees@microsoft.com) (she's a cutie too), the Marketing organizer for the event who informed me about INETA.ORG. Basically, they are a .NET User META group... they send out speakers to your user group to augment its offerings. If I had just been invited to the MGB 2004 in HotLanta (info, pics) I might have seen their video when everyone else saw it.