Tag: Installation
-
DBA Scripts: Pre-Install and Post-Install Checks for SQL Server
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Installation & Patching You are standing up a new SQL Server instance, or you have inherited one and want to know what state it is really in. These 2 read-only PowerShell scripts sit either side of setup: pre-install-check.ps1 tells…
Written by
-
DBA Scripts: Server and Configuration
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. What This Server Is, and How It Got That Way Both pillars here answer one underlying question: before performance, before security, before anything else, what is this SQL Server instance, and how did it come to be configured the way it is. Server…
Written by
-
DBA Scripts: SQL Server Installation and Patching
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration Scripts covering a SQL Server instance’s whole install-to-patch lifecycle: confirm a machine is ready, install unattended, apply sensible defaults, validate the result, keep it patched, and remove it cleanly when it’s done, for both the SQL Server engine and SSMS.…
Written by
-
DBA Scripts: Uninstall SSMS via PowerShell
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio.In: Server & Configuration › Installation & Patching When the Uninstaller Fails SSMS has to come off a machine, and Settings → Apps failed, left it half removed, or is no use across a fleet. This script finds every SSMS install in…
Written by
-
DBA Scripts: Install and Update SSMS via PowerShell
🛠️Part of the SSMS Complete Guide, installing, configuring and fixing SQL Server Management Studio.In: Server & Configuration › Installation & Patching Where To Go Next SSMS Complete Guide, installing it, keeping it updated, and fixing it when it misbehaves. DBA Scripts, the SQL Server scripts you will actually run once SSMS is open. DBA Scripts:…
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
- How to Back Up a SQL Server Certificate and Its Private Key
- How to Back Up a Database in SQL Server
- Cannot Connect to WMI Provider: SQL Server Configuration Manager Will Not Open
- SQL Server Configuration Manager: Where to Find It and What a DBA Uses It For
- DBA Scripts: Get Failed Login Summary
- Query Was Fast Yesterday, Slow Today: Find What Changed
- Backups & Recovery (18)
- DBA Scripts (154)
- High Availability (HA) (13)
- Installation & Configuration (58)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (24)
- Storage & Capacity (17)
- T-SQL Fundamentals (15)
- Troubleshooting (102)
- Wait Types (236)