SQL Centre of Excellence

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.

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DEV207

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.

image

blog comments powered by Disqus

Page List

Page List