Detect SQL Server version with structured SERVERPROPERTY values, map major releases, inspect update level, and confirm the host platform.
PostgreSQL Local Variable: DECLARE in a plpgsql Function
A PostgreSQL local variable is declared in the DECLARE section of a plpgsql function or DO block. This post tests a function with two variables, the NULL start value, scope, CONSTANT, STRICT, a name clash error and the psql alternative.
SQL SERVER – Puzzle – Working with functions to Concatenate columns
A code review puzzle: 15 fields joined with ISNULL on every column. Can you concatenate columns with NULL values in a simpler way using SQL Server functions?
SQL SERVER – Using Project Connections in SSIS – Notes from the Field #088
Connection managers are the gateway for most SSIS reads and writes. In Notes from the Field #088, Tim Mitchell explains how to use Project Connections in SSIS.
Pre-Flight Checks at the Top of a Script With THROW
Learn pre-flight checks with practical SQL Server examples, clear checks, and the limits you need before changing application data.
SQL SERVER – Identifying Blocking Chain Using SQL Scripts
A roundup of my earlier posts on blocking, plus a SQL script using sys.dm_os_waiting_tasks to identify the blocking chain and see who is waiting for whom.
SQL SERVER – Creating Dataset Using VALUES Clause Without Creating A Table
You can use the VALUES clause to build a small dataset like a table without creating one. Here is the syntax, which works from SQL Server 2008 onwards.