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.Related pillar: Server & Configuration 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…

    Written by

    Peter Whyte

  • 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 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…

    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, copy/paste SQL Server scripts and health checks.Related pillar: Server & Configuration

    Written by

    Peter Whyte

  • DBA Scripts: Install and Update SSMS via PowerShell

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Server & Configuration

    Written by

    Peter Whyte

  • DBA Scripts: Uninstall SQL Server

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Server & Configuration 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…

    Written by

    Peter Whyte

  • DBA Scripts: Install and Configure SQL Server

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Server & Configuration 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…

    Written by

    Peter Whyte

Start Here

The Pillars

Blog Categories

Latest Posts

Blog Tags

Access (4) Always On Availability Groups (4) Auditing (7) Backups (6) Blocking (4) Blocking Locking (6) Collectors (7) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (24) Disk Space (5) Extended Events (8) Features (6) High Availability (6) Indexes (7) Installation (7) Inventory (8) Jobs (3) Maintenance (7) Migration (15) Monitoring (27) Performance (21) Performance Troubleshooting (9) PowerShell (4) Query Behaviour (5) Security (10) SQL Agent (5) SQL Scripts (17) 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 (7) Storage and Capacity (7) T-SQL (10) Temp DB (3) Tracing (7) Transaction Logs (4) Troubleshooting (24) Windows Server (4)