I just watched one of the project Juneau web casts. While there are lots of great features and I do see the long term value, I nearly fell of my chair looking at the “sample” stored Proc shown live on stage at Tech Ed 2011.
It’s a cursor looping through all the customer records assigning a segment to them and generating one update statement per row. While the ability to debug the cursor in the proc and view/set variables at run time is cool, surely we can use better examples that don’t make sql dudes cringe.
if you can avoid cringing at some the t-sql shown, this webcast is a good walk though of the database centric features available in Visual Studio 2010 and project Juneau.