I recently sat down with long-time friend Kevin Kline, who grilled me a little about my new role at Stack Overflow, our industry in general, and why we sometimes stay in jobs we don't enjoy.

In this tip, I show how I combine GROUPING SETS and PIVOT to get crosstab-style reports without Excel.

In the second part of this series, I show two ways to shift expensive computations to write time.