Maintenance: Patches: Which Ones to Apply, When, and How
You’ll learn how patches changed starting with SQL Server 2017, what’s inside a cumulative update, how to pick which patches to apply, and how to apply them.
In this video, I talk about the SQL Server Release Services blog, which has moved here.
- Backups 1: 3 Common Strategies
- Backups 2: Restores
- Backups 3: Setting Up Maintenance Plans
- Backups 4: Setting Up Ola Hallengren’s Maintenance Scripts
- Backups: Reading from Databases During Restores
- Configuration: Anti-Virus
- Configuration: Instant File Initialization
- Configuration: Lock Pages in Memory (LPIM)
- Configuration: Prepare for Emergencies with the Remote DAC
- Configuration: Sending Emails with Database Mail
- Configuration: sp_configure Settings
- Configuration: TempDB Files and Sizes
- Corruption 1: How it Happens, and How to Detect It
- Corruption 2: DBCC CHECKDB for VLDBs
- Maintenance: Agent Jobs
- Maintenance: Shrinking Files
3 Comments. Leave new
SQL Server Release Blog is now here: https://techcommunity.microsoft.com/t5/SQL-Server/bg-p/SQLServer/label-name/SQLReleases
this is the scariest lesson of all masters and fundamental classes 🙂
HA!