Category: Installation & Configuration
-
DBA Scripts: Uninstall SSMS via PowerShell
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio. Where To Go Next This page covers one part of working with SSMS. The full reference ties the install, configuration and troubleshooting pieces together. SSMS Complete Guide, installing it, keeping it updated, and fixing it when it misbehaves. DBA Scripts, the…
Written by
-
DBA Scripts: Install and Update SSMS via PowerShell
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio. Where To Go Next This page covers one part of working with SSMS. The full reference ties the install, configuration and troubleshooting pieces together. SSMS Complete Guide, installing it, keeping it updated, and fixing it when it misbehaves. DBA Scripts, the…
Written by
-
DBA Scripts: Uninstall SQL Server
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Installation & Patching Removing an Instance Cleanly, and Knowing What Happened Afterward uninstall-sql.ps1 detects installed instances, confirms the target explicitly, and runs setup.exe /ACTION=Uninstall, with an option to remove data directories afterward. generate-install-report.ps1 reads back through every install, configure,…
Written by
-
DBA Scripts: Install and Configure SQL Server
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Installation & Patching Unattended Install, Then Sensible Defaults Applied on Top Two scripts covering the doing half of a SQL Server install: install-sql.ps1 drives setup.exe with validated, logged parameters instead of clicking through the GUI, and configure-sql.ps1 applies the…
Written by
-
DBA Scripts: Get OS and Hardware Info
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Server Inventory What Is This Server Actually Running On Before you can reason about performance, capacity, or whether a setting makes sense, you need the basics: how much CPU and memory the box actually has, what OS it’s running,…
Written by
-
DBA Scripts: Get Instance Configuration Score
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Server Inventory Get Instance Configuration Snapshot gives you every raw sp_configure setting; useful, but it doesn’t tell you which of those hundred-plus rows actually matter. This script is the graded version: roughly 20 checks spanning memory, security, backups, integrity,…
Written by
-
What’s New in SSMS 22 for DBAs
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio. 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 a moving target.…
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. 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 the tool that…
Written by
- sp_who vs sp_who2 vs sp_whoisactive in SQL Server
- The Evolution of SQL Server: Every Version from 1989 to 2025
- Cannot Execute As the Database Principal (Error 15517)
- Silent Failures: The SQL Server Problems That Never Raise an Error
- SQL Server Login Migration: What Gets Silently Left Behind
- CREATE USER WITHOUT LOGIN vs Contained Database Users
- Backups & Recovery (16)
- DBA Scripts (151)
- High Availability (HA) (12)
- Installation & Configuration (45)
- Maintenance (24)
- Migration & Upgrades (14)
- Monitoring (8)
- Performance Tuning (35)
- Security (Encryption & Permissions) (20)
- Storage & Capacity (14)
- T-SQL Fundamentals (11)
- Troubleshooting (55)
- Wait Types (235)