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
Tag: T-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
Working with the registry in SQL Server
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the
April 2, 2020
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
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
Weaning yourself off of SQL Profiler (Part 1)
In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting
June 9, 2015
Using Linked Servers the Right Way
Linked Servers are a very popular way to access distributed data in environments with lots of SQL Server instances on
October 28, 2012