The plus sign adds or glues text depending on the types on each side. I show the surprise, the error 245 it can cause, and how text keys get hurt.
Find and Replace With Regular Expressions in SSMS
A regex replace can turn forty column names into ISNULL expressions in seconds. Here is the pattern, the safety habits, and the trap of a zero default.
The Row Version Tag: Page Splits After Turning On RCSI
Turn on RCSI and every row you update gets a little bigger. On packed pages that means page splits, and I show the numbers on a small demo table.
Database Scalability: Vertical and Horizontal Explained
One server with 64 cores or two with 32 cores? A customer asked me to help decide. Here is a simple look at database scalability, vertical and horizontal.
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.
Interview Question of the Week #027 – Move TempDB from One Drive to Another Drive When Low Disk Space
Diagnose low disk pressure in tempdb before moving files, inspect transaction and allocation usage, and plan a verified Windows restart.
.jpg)
Great Indian Developer Summit 2015: Three SQL Sessions and a CPU Check
Great Indian Developer Summit 2015 brought me to Bangalore and Hyderabad for three SQL Server sessions. This page keeps the dates, topics and photos. It also adds a CPU check I would start with today, tested on SQL Server 2025, because one session was about CPU performance.