January 2014
Best approaches for grouped running totals

I follow up on a running totals post with an article describing different ways to achieve the same types of results for more complex grouping and aggregation.

No, you can't trust IDENT_CURRENT

I demonstrate how IDENT_CURRENT cannot be relied upon for reporting your new IDENTITY value, even under SERIALIZABLE.

Justifying the new Mac Pro

I explained how I justified purchasing a new Mac Pro, and show that it is very tough to order a comparable PC at similar price points.