While it's still only the CTP1 timeframe, getting a glimpse of the changes in system objects can start preparing you for what's coming - especially when there are potential breaking changes, as you'll see below.  Sure, a few of these things can change (and hopefully be fixed!) as the product gets closer to release, but once you have the ...

In my last post in this series, I talked about the common habit of creating an IDENTITY column on every single table.  Today I want to talk about a more broad concept: relying on undocumented (and therefore probably undefined, and certainly far from guaranteed) behavior and objects.   ORDER BY in a view This is probably the most ...