I used generate scripts for a historical SQL Server 2017-to-2005 migration. It was a logical migration rather than a backward backup restore.
SQL SERVER – SSMS – Enable Line Numbers in SQL Server Management Studio
When I guide a DBA over a screen share, line numbers make it easy to point at the right spot. Here is how to enable line numbers in SSMS.
In-Memory OLTP Migration Checklist in SSMS: Step by Step
The In-Memory OLTP migration checklist shows which tables and stored procedures can move to memory-optimized objects. This post sizes up the tables with T-SQL, walks through the wizard in Management Studio and explains how to read the reports.
SQL SERVER – Unable to See SQL Server Configuration Manager. How to Open it?
A reader had no Start menu shortcut for SQL Server Configuration Manager and could not find it. Here is how to open it anyway.
SQL SERVER – Save Auto Recover Information – SSMS
SSMS can save your unsaved queries if it crashes, yet few people know the setting. Here is where to find Auto Recover under Tools, Options and why it matters.
SQL SERVER – How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?
A DBA asked for a shortcut to drop more than one table at once in SSMS without writing T-SQL. Here are the simple steps, using just the keyboard.
SQL SERVER – Unable to Bring SQL Cluster Online – Reason: The Account is Disabled
After security hardening, a client’s SQL cluster resource sat in Online Pending, then failed: the account is disabled. Here is how we found and fixed it.