Tag: Installation

  • DBA Scripts: Server and Configuration

    Part of the DBA-Tools Project. What This Server Is, and How It Got That Way Two pillars, 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 Inventory answers the first half, a snapshot of what’s…

    Written by

    Peter Whyte

  • DBA Scripts: SQL Server Installation and Patching

    Part of the DBA-Tools Project, in the Server and Configuration area. Ten 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. Six posts below,…

    Written by

    Peter Whyte

  • DBA Scripts: Uninstall SSMS via PowerShell

    Part of the DBA-Tools Project. Three Fallback Methods Deep, Because SSMS Uninstalls Don’t Always Go Cleanly The manual SSMS uninstall walkthrough covers the standard path and the reinstall-won’t-go-clean escalation steps by hand. This script automates the same removal and goes further: for SSMS 21+, it tries vswhere-based detection, then a registry-command passthrough, then winget, in…

    Written by

    Peter Whyte

  • DBA Scripts: Install and Update SSMS via PowerShell

    Part of the DBA-Tools Project. The Scripted Version of Installing SSMS, for Repeatable and Fleet Installs Install and Update SQL Server Management Studio (SSMS) already covers the manual, click-through install via the Visual Studio Installer, the right walkthrough for a one-off install on your own workstation. This script is the same job automated: silent install…

    Written by

    Peter Whyte

  • DBA Scripts: Uninstall SQL Server

    Part of the DBA-Tools Project. 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, and patch log this toolkit has ever written for an instance and produces a…

    Written by

    Peter Whyte

  • DBA Scripts: Install and Configure SQL Server

    Part of the DBA-Tools Project. 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 recommended sp_configure settings afterward with a before/after comparison. Every change from both scripts is…

    Written by

    Peter Whyte

  • DBA Scripts: Pre-Install and Post-Install Checks for SQL Server

    Part of the DBA-Tools Project. Bookend Checks for an Installation You Can Trust Two scripts, same shape (PASS / WARN / FAIL, a summary verdict), sitting on either side of an install: pre-install-check.ps1 confirms the machine is actually ready before you run setup, post-install-validation.ps1 confirms the instance is actually configured sensibly after you’re done. Neither…

    Written by

    Peter Whyte

Blog Categories

Latest Posts

Blog Tags

Access (3) Always On Availability Groups (4) Auditing (7) Backups (5) Blocking Locking (6) Collectors (7) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (28) Disk Space (5) Extended Events (8) Features (6) High Availability (6) Indexes (7) Installation (7) Instance (3) Inventory (6) Jobs (3) Maintenance (6) Migration (13) Monitoring (24) Performance (21) Performance Troubleshooting (9) PowerShell (4) Query Behaviour (5) Security (7) SQL Agent (5) SQL Scripts (21) SQL Server Administration (10) SQL Server Configuration (7) SQL Server Errors (5) SQL Server High Availability (4) SQL Server Internals (3) SQL Server Management Studio (SSMS) (6) SQL Server Monitoring (7) SQL Server Networking (9) SQL Server Security (9) Storage and Capacity (9) T-SQL (9) Temp DB (3) Tracing (7) Transaction Logs (5) Troubleshooting (14) Windows Server (4)