SQL Server 2017 Cumulative Update #29
SQL Server 2017 Cumulative Update #29 is available, with 18 enhancements. The build number is 14.0.3436.1.
Monthly Archive: March 2022
Interview with Kevin Kline for Orange Matter
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.
Advanced report examples using PIVOT and GROUPING SETS
In this tip I show how I combine GROUPING SETS and PIVOT to get crosstab-style reports without Excel.
FORMAT is a convenient but expensive function, part 2
In the second part of this series, I show two ways to shift expensive computations to write time.