I got a question from a reader asking me to explain various cases for the use of one of our traceflags.  The flag in question doesn’t matter per se (the only official documentation on the flag, 2301, is at http://support.microsoft.com/kb/920093 ...

New Pricing for SQL Azure is out today (and it is cheaper on storage): http://www.windowsazure.com/en-us/pricing/details/

We had a customer issue today that ended up being by-design but was confusing enough that I offered to write up a blog post so that people could reference it in the future.  It boils down to the question “when should ROW_NUMBER() be computed in a...