You can wrap SQL code in SSMS so long lines fit the window and you never scroll sideways. This post gives the exact menu path, what each option on that page does, a long query to test it with and a shortcut for switching it on and off.
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.
SQL SERVER – A Brief Note on SET TEXTSIZE
Is there any difference between the LEFT function and SET TEXTSIZE? A quick script shows how each one trims a long VARCHAR(MAX) value in the results.
Reading Default Data and Log Paths With InstanceDefaultDataPath
Changing the default folder does not move a single existing file. Here is how to read the defaults and spot databases that ignore them.