Prevent Presentation Disasters by Pausing Windows Updates

It’s no secret that Windows 10 likes to forcibly apply updates, and occasionally these forced updates can occur at very inopportune times. I’ve heard tales of forced updates ruining demonstrations and presentations not only at SQL Saturdays, but also at this year’s PASS Summit.

What most people don’t seem to realize is that this type of disaster can be prevented rather easily. Here’s how to prevent surprise updates in Windows 10:

Have The Right Version

All the settings shown here first appeared in the Windows 10 Creators Update, version 1703. By this point you probably have it on your machine (in fact, as I write this, the Fall 2017 Creators Update, version 1709, is now being pushed out to users.) But if you’re unsure of your windows version and want to check, right-click on the start button and choose “system” to bring up information about your PC.


So long as you have version 1703 or later, you’re good!

Advanced Windows Update Options

Navigate to this menu by clicking on the Start button and searching for “Advanced Windows Update Options”.

Once this window opens, you’ll see several options that can be configured:

(click to enlarge)

Towards the bottom is the silver tuna: the “Pause Updates” switch. As the very helpful description states, pausing updates stops their installation for up to 35 days (unless you un-pause it sooner). Once those 35 days are up, you must bring your device up-to-date before you are allowed to pause again.

Moving up from the Pause Updates switch are two drop downs that allow deferment of updates. “Feature updates”, which are released semi-annually, can be delayed for up to a year. “Quality updates”, the cumulative monthly updates, can be deferred by up to a month.

Moving up again, you will find the Windows servicing channel. The channels available to you depend on which edition of Windows 10 you are running, and a matrix is available here. Adding to the confusion is the fact that Microsoft is changing the names of the channels in the Windows 10 Fall 2017 Creators Update (version 1709).

The Current Branch is considered appropriate for home users, and receives updates as soon as they are available. Beginning in version 1709 this will be renamed to “Semi-Annual Channel (Targeted)”.

The Current Branch for Business receives updates a few months after they are made available, and is directed towards business users. Beginning in version 1709 this will be known as the “Semi-Annual Channel”.

Thank you, Microsoft, for taking some pretty straight-forward names and changing them to be nearly identical and way more confusing.

My Recommendations

Here’s what I do: if I have a presentation or other important event coming up, I pause updates a week or two beforehand. This gives me adequate time to test everything in a stable environment as well as the peace of mind that unexpected updates won’t occur. I also allow my feature and quality updates to be deferred by up to 15 days. That way, if an update does pop up out of nowhere, I’m not forced to install it immediately.

This post is syndicated from Bob’s personal blog site at

PASS Linux for the SQL Server DBA Webinar - Dec 13

Join David Klee for a session on Linux administration for the SQL Server DBA as part of the PASS SQL Server on Linux webinar series marathon on December 13th!

Times are certainly changing with Microsoft’s recent announcement to adopt the Linux operating system with the SQL Server 2017 release, and you should be prepared to support it. But, what is Linux? Why run your critical databases on an unfamiliar operating system? How do I do the basics, such as backing up to a network share or add additional drives for data, logs, and tempdb files? This introductory session will help seasoned SQL Server DBAs understand the basics of Linux and how it differs from Windows, all the way from basic management to performance monitoring. By the end of the session, you will be able to launch your own Linux-based SQL Server instance on a production ready VM.

Register now for this exciting webinar series!

MSSQLTips Webinar with SIOS - Thursday 1p Eastern

Come join SIOS and Heraflux for an exciting webinar discussing the inherent challenges with infrastructure problems, database performance, and bridging the silos within the IT organization.

  • Learn why legacy tools fall short in helping you fully solve SQL Server problems
  • Comparison: Step through how to troubleshoot the cause of a SQL Server problem vs. using Machine Learning
  • Get answers you need to help prevent future SQL Server performance challenges

Attend this webinar to learn more.

Webcast Date

Thursday, November 16, 2017
6:00 PM UTC | 1:00 PM EST

Register for this webinar here.