I watched the live feed of World Mobile Congress today a little worried for what I might hear out of Microsoft.  While it was fully understood that today would be about the 7 OS I really was not sure how I would feel at the end.  I have been on 6.5 for the past six months and have had quite a bit of buyers remorse.  The thought was in my head that this might be the end of the road for Windows Mobile in my life.

I am still in a small amount of shock at just how right Microsoft got this.  It is not so much that I doubted their ability to pull it off, just that they have not shown the commitment to mobile in the past.  It would appear that 7 is truly becoming the lucky number at Microsoft.

A great video has been posted on Channel 9 showing a walkthrough of the software with Joe Belfiore who did most of the content discussion today.  As a ZuneHD owner (thanks again Magenic!) I am extremely excited about the potential experience of the new OS.  Combined with the rather rigid (compared to earlier Microsoft requirements) hardware specifications I imagine this will be a rather fantastic experience.

The next event to look to will be MIX where most of the developer discussion will take place.  This looks to be a great year for Microsoft in the mobile space.

By way of the Dan Jones blog, the next version of SQL Server will be codenamed "Denali" and is still on rough track to be officially titled SQL Server 2011.  No details yet on features, just the codename at the moment.  Still good to know what to add for searches on the next version. :)

I know it has been quite a while since I posted to the blog, a topic for another time, but I wanted to put this out here as I have used it three times this week to answer a couple different questions.

The system view sys.key_constraints replaces functionality found in sysconstraints in SQL Server 2000 and earlier versions.  While sysconstraints still exists in SQL Server 2008 it is slated for removal in a future version of SQL Server.  The view stores details for primary and unique keys.

What we are after today is the name, parent schema, parent table, and (most importantly) the column list making up our keys.

Here is the code:

SELECT  kc.name AS KeyName
       ,SCHEMA_NAME(kc.[schema_id]) AS ParentSchemaName
       ,OBJECT_NAME(kc.[parent_object_id]) AS ParentObjectName
       ,type_desc AS KeyType
       ,create_date AS KeyCreationDate
       ,STUFF((
                SELECT  ', ' + c.name
                FROM    sys.index_columns AS ic
                        INNER JOIN sys.columns AS c On c.column_id = ic.column_id
                                                       AND c.[object_id] = ic.[object_id]
                WHERE   ic.index_id = kc.unique_index_id
                        AND ic.[object_id] = kc.[parent_object_id]
                ORDER BY ic.key_ordinal
              FOR
                XML PATH('')
              ), 1, 1, '') AS ColumnDefinition
FROM    sys.key_constraints AS kc
WHERE   type = 'UQ'
ORDER BY ParentObjectName ;

As referenced above, I have some changes coming in my focus.  Expect to see more code and less talk out of this blog in the near future.  Enjoy!

I was in a conversation this morning with a couple other SQL guys (Twitter again) and the subject of Dynamic Management Views (DMVs) came up in regards to SQL Azure.  Running through the MSDN details it did not seem that they were supported.  After a couple emails with the SQL Azure team I have been given assurances that they will be added in a few months. 

The DMVs that will be available are only those which have database scope.  This is another great step in making SQL Azure a very viable alternative to local hardware.

Just had an awesome exchange with two members of the SQL Server community over Twitter.  While many people scratch their heads at what exactly to do with this tool (other than let everyone know they are eating, sitting, or worse.) the SQL community has exploded as of late.

All it took to get the conversation started was a question with a "#sql" tag.

I really enjoy a setting where a skinny geek in Atlanta can be talking with someone in Seattle and another in Slovenia about internals of a product we all make our livelihood from.  Good times indeed...

Sing this to the Bruce Springsteen version replacing Santa Claus...

Rocky will be in the ATL for a number of meetings, starting Tuesday with a Geek Dinner at 5 Season's Brewery in Alpharetta. 

On Wednesday Rocky will be joining us at ALEMUG to talk about Oslo.  This will be a very interesting discussion based on some of the recent developments in trajectory with Oslo.

If you are unfamiliar with Rocky he is the Principal Technology Evangelist at Magenic, a well known author, and is responsible for the CSLA framework that helps people build business objects.

Do yourself a favor and swing by for one (or both) of these events.  Rocky is a great guy and always has an interesting viewpoint of technology.

My list of items in Program Files (x86) keeps shrinking and thank goodness for that.  The continued drive to 64 bit is joined by SSMS and is available here.  This build also supports SQL Azure if you need additional sales pitch.

The OSLO story just continues to amaze and perplex me.  I am a bit late with the reference but Doug Purdy posted on the 10th about the next transformation of OSLO, now being called SQL Server Modeling.  What should not be missed are the roughly 60 comments on this post - many of those taking an adversarial feel.

While a part of me enjoys the existence of SQL Server continuing I was really hoping to see some sort of transcendent technology coming our way.  I suppose the PDC conference next week could still have some big "wow" moment but that now seems less and less likely.

I would love to hear from you, dear reader...what do you think about this change in name (and likely direction)?

The SQL Azure Team Blog has an update on some changes in the CTP2.  First and foremost, the product is now feature complete.  Second, if you have been using the October CTP you have now been provisioned over to the go-live production clusters.

Additional Transact-SQL enhancements have been made as well, with Table Value Parameters being the most interesting to me.

PDC 2009 will see lots of discussion about SQL Azure so if you are making the trip to Los Angeles be sure to catch a session.

One more note on SQL Azure, if you are using Visual Studio 2010 beta check out the SQL Azure Explorer on CodePlex.  The add-in gives you the ability to navigate your instance as you would a normal SQL Server instance.  Good stuff!

The first meeting of the Atlanta Leading Edge Microsoft User Group (ALEMUG) was a great success.  We had a decent turn out considering the rainy weather (not sure why people don't go to user groups when it rains in ATL, but that is another matter).

We had a couple quick presentations on covariance versus contravariance and two talks on new C# 4.0 features.

A giant thank you to everyone that came out tonight and made the evening such a great time!

Sergey Barskiy rocking the dynamic types

Everyone listening intently

Mike Strobel wows the crowd with code contracts

Jeff Ammons (left) shows off his Red Gate swag winnings while I mug for the camera