Getting Back to a Rhythm of SQL Events
Over the years, we have been eager participants and supporters of SQLSaturday, PASS Summit, user group events, etc. We value
June 24, 2021
Category: SQL
T-SQL Anti-Patterns: SQL User Defined Functions (UDFs) that turn your set operation into a cursor
One of the things we see as consultants are consistent patterns of behavior by T-SQL developers that cause big performance
March 3, 2021
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
Spectre and Meltdown Exploits
In recent weeks, a significant security risk was exposed. This exploit has been named in two fashions: Spectre and Meltdown. We at SSG
January 18, 2018
sp_server_diagnostics – Black Box Recorder
A few months back I began a series about the SQL Black Box Recorder, that you can read here, with
July 26, 2016
SQL Black Box Recorder part II
A few months back I began a series, about the SQL Black Box Recorder that you can read here, with
April 6, 2016
Indexed Views – Performance Panacea or Plight
Indexed View(s) An indexed view is a view where the result set from the query (the view definition) becomes materialized in
January 28, 2016