Tag: Patching
-
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
-
DBA Scripts: Patch SQL Server and Check Status
Part of the DBA-Tools Project. Config-Driven Multi-Server Patching, and a One-Command Status Check Invoke-SqlPatch.ps1 reads a server list and CU definitions from a config file, compares each instance’s installed version against the target, downloads the installer if needed, and applies it, locally or remotely over WinRM. patch-summary.ps1 is the fast companion check: every SQL Server…
Written by
Blog Categories
- Backups & Recovery (7)
- DBA Scripts (130)
- High Availability (HA) (7)
- Installation & Configuration (14)
- Maintenance (4)
- Monitoring (13)
- Performance Tuning (11)
- Security (Encryption & Permissions) (4)
- T-SQL Fundamentals (11)
- Troubleshooting (20)
- Wait Types (235)
Latest Posts
- DBA Scripts: Run a Full SQL Server Health Check
- Diagnose SQL Server’s ‘String or Binary Data Would Be Truncated’ Error
- Shrinking a SQL Server Database Causes Fragmentation: Measured, Not Just Stated
- DBCC CHECKDB Found Corruption: What to Actually Do Next
- Parameter Sniffing in SQL Server: A Measured Example, Not Just the Theory
- Table Variables vs Temp Tables in SQL Server: What the Optimizer Actually Sees
Blog Tags
Access (3) 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) Instance (3) Inventory (8) Maintenance (7) Migration (15) Monitoring (27) Performance (21) Performance Troubleshooting (9) PowerShell (4) Query Behaviour (5) Security (9) 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)