Lightning fast

Last time I've revisited Google Play order processing, there was a 6 hour gap between order submission and the card being charged. The delay was artificial, naturally. I'm not exactly sure what was the reasons for such a design, probably, that was an allowance for return and refund; if the customer's remorse kicks in before the card is charged, Google doesn't have to pay the card transaction fee.

Effective July 2017, the gap is no longer on the order of hours; now it's 5-7 minutes.

Team Foundation Server schema

UPDATE: some more on the TFS schema here and here. On the recent developments: here.

I happen to run an on-premises instance of Microsoft Team Foundation Server for a medium sized software shop. TFS has pretty good reporting capabilities, but out of the box, almost no cross-collection reporting. Fortunately, those who are blessed with admin rights in TFS get to connect to the production database server.

Who does that?

Amazing discovery of the day: Microsoft Excel respects Scroll Lock.