T-SQL Tips and Solutions, Part 1
When writing T-SQL code, I find there are certain routines I do over and over again. Like, inserting data into
May 13, 2021
Author: Jared Kirkpatrick
How to Apply your Craft to Your Hobby: SQL Data Analysis and Athletic Training
I am very grateful for the career I have passionately pursued these last 20 years, working for small, medium, large,
January 4, 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
Building a T-SQL Framework
Depending on the objective, building a framework allows the architect to imbed the fundamental segments of a structure so that
March 2, 2016
Much ado about GUIDs
How does one enforce referential integrity across separate databases, or servers for that matter? The answer is simple—there is nothing
October 20, 2015