Short Variables

T-SQL Decommenter Part IV

Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.

Converting Binary Numbers To Hex

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.

T-SQL Decommenter Part III

Detailed explanation of the recursive section of the T-SQL Decommenter.

T-SQL Decommenter Part II

Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.

T-SQL Decommenter Part I

Introduction to a T-SQL query that remove comments from T-SQL code

Mixed Joins

Finding the Percentage

COLUMNPROPERTY in SQL Server 2016/2017

Conditionally Order By Different Column

Order records based on a different column depending on which absolute value is greater.