Rethinking RBAR
Much has been written about the performance implications of the dreaded RBAR, a term coined by Jeff Moden many years
December 9, 2019
Category: SQL Server
Don’t fall in love with features you won’t use
As 2009 dawned, I was shopping for a new (read: used) car. The one I drove most of the time
October 1, 2019
The Finished Product: Framework, pt. 5
We now have a finished T-SQL framework, and this is the last post of the series. We start with the
September 3, 2019
T-SQL Batching: Framework, pt. 4
In this fourth installment of the framework series, we will add a T-SQL batching feature to our existing framework we
August 27, 2019
Strangest Things, Pt. 3: Linked Servers in SQL
As a consultant, you experience different environments, with different architectures, different skill sets, and different processes. Usually there’s just one
August 13, 2019