Reeves Smith shows enhancing reference data in Master Data Services, building on data he added earlier with the MDS add-in for Excel.
SQL SERVER – How to Change Server Name?
I renamed my VM and needed SQL Server to match. Here is a query that shows the host and server names from every source, and how to change server name.
Interview Question of the Week #028 – T-SQL Script to Detect SQL Server Version and Property
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 – 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.