Saving Labor

Manage Your Business Rules in T-SQL Query

Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses.  And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]

SQL WAITFOR Command to Delay SQL Code Execution

In this article, we look at the SQL Server WAITFOR command to allow delays in processing either for a specified time or a set amount of time.

T-SQL Language Changes in SQL Server 2022

SQL Server 2022 is in preview in August 2022. I assume this version will be released later this year, and I have been testing it with the idea that I will be looking at an upgrade sometime in the next year for a few servers. There are a lot of changes in the database platform, […]

EXCEPT Details

Understanding the Metadata Function DATABASEPROPERTYEX()

Learn how to use the DatabasePropertyEX() function to query your database for settings.

Operator Precedence

Schema Only Database Backup

Use DBCC CLONEDATABASE to make a Schema Only Database Backup

Using CONTINUE

INSERT EXEC statement cannot be nested, the Simple Solution

Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.