After renaming the Windows server, repair SQL Server’s local name with sp_dropserver and sp_addserver, then verify dependent services.
Query Options in SSMS: Settings That Change Your Results
Query Options are the per-window settings in SSMS that change how a query runs and how its results look. This post covers results to grid, text or file, the character limits that cut long values, the SET options that change answers, and why SSMS and your application can disagree.
What the model Database Passes to Every New Database
Audit the model database template for recovery model, options, objects, and file size, then verify growth settings on new databases.
Moving Databases to a New Server Behind a SQL Server Alias
Move databases behind a SQL Server alias or DNS CNAME by planning name redirection, backup and restore, Kerberos SPNs, and connection tests.
Recycling the Error Log on a Schedule and Keeping Enough History
Keep SQL Server logs readable by recycling the error log weekly, retaining enough archives, setting a size cap, and checking history.
Server Configuration as Code
Configuration as code keeps SQL Server instance settings in reviewed scripts, with environment values, drift checks, and repeatable application.
Keeping a Patch Test Environment Honest
A Patch Test Environment must match production data, settings, jobs, and versions closely enough to reveal real patch risks.