When SQL Server is slow, where do you start? I look at querying performance counters from inside SQL Server as a quick way to see what is going on.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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 – 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 slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.