Category: Installation & Configuration
-
What’s New in SSMS 22 for DBAs
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio.In: Server & Configuration SQL Server Management Studio 22 is the current line, it sits on the Visual Studio 2026 shell, and it has been shipping updates roughly monthly. That cadence is genuinely new for SSMS, and it means “what’s new” is…
Written by
-
Installing Windows Terminal on Windows
Windows Terminal is the modern command-line application for Windows and supports PowerShell, Command Prompt, and WSL in a single interface. On recent versions of Windows (Windows 11 and newer), Windows Terminal is installed by default. If it’s already available on your system, no installation is required. If it isn’t installed, or you’re working on older…
Written by
-
Use Git in SSMS to Version Control Your DBA Scripts
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio. Every DBA has a scripts folder. Most of them live dangerously: a directory on a jump host, copies of copies, a blocking_check_v2_FINAL.sql that is not the final version. Since SSMS 21 the fix has been built into the tool you already…
Written by
-
GitHub Copilot in SSMS: Setup, and What a DBA Should Let It Do
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio.In: Server & Configuration GitHub Copilot became generally available in SSMS at 22.4.1, and most of what is written about it is either a sales page or a dismissal. Neither helps you decide what to actually do with an AI assistant inside…
Written by
-
How to Enable Dark Mode in SSMS
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio.In: Server & Configuration Dark mode in SQL Server Management Studio is finally a supported setting rather than a registry hack. It arrived with SSMS 21 and carries through SSMS 22, where theming has been extended release by release. If you are…
Written by
-
SSMS Query Shortcuts: Run sp_whoisactive on a Hotkey
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio.In: Server & Configuration Press Ctrl+1 in a query window and SSMS runs sp_who. Press Ctrl+2 and you get sp_lock. Most people know those two exist and stop there, which means missing the actual feature: the mechanism behind them is configurable, and…
Written by
-
DBA Scripts: Get Service Broker Health and Database Mail Queue
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration Two Messaging Systems That Run Quietly Until They Don’t Service Broker and Database Mail are both messaging infrastructure, and both are easy to forget are even active, since SQL Server uses Service Broker internally for things like Availability Group health…
Written by
-
DBA Scripts: Get Collation Conflicts and Cross-Database Dependencies
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration Two Things That Break Silently at Migration or Decommission Time Two checks that rarely matter until the exact moment they do: does this database’s collation match the server’s (and every other database it might join against), and does anything in…
Written by
-
DBA Scripts: Get CDC and Change Tracking
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration Two Features, Same Risk: They Both Grow the Transaction Log Change Data Capture and Change Tracking answer a similar question, “what changed and when,” for two different audiences, ETL/replication consumers for CDC, application-level conflict detection for Change Tracking. They’re unrelated…
Written by
-
SSMS Results Grid: Export to Excel, JSON and Markdown
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio.In: Server & Configuration For twenty years the way query results left SSMS was copy, paste into a spreadsheet, fix the columns the paste mangled. SSMS 22 quietly ended that: the results grid now saves straight to Excel, JSON, Markdown and XML,…
Written by
- RESOURCE_SEMAPHORE When SQL Server Is Nowhere Near Its Memory Cap
- Dynamic Data Masking: What a WHERE Clause Still Reveals
- DBA Scripts: Get Log Shipping Status
- SQL Server Row-Level Security: The Filter Does Not Stop Cross-Tenant Writes
- View the Definition of a Stored Procedure in SQL Server
- TempDB Is Full or Still Growing: Find What Is Using It, Right Now
- Backups & Recovery (17)
- DBA Scripts (152)
- High Availability (HA) (13)
- Installation & Configuration (49)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (21)
- Storage & Capacity (16)
- T-SQL Fundamentals (15)
- Troubleshooting (95)
- Wait Types (235)