Wednesday, May 10, 2017

Tech Tips: Disabling Windows Update

Everybody probably trying to look for how to or even you ask why do you need to switch off Windows Update in the first place. You are probably running on Windows 10 if you have stumble upon this post and ever since Windows 10 is introduced, it is something pain in the arse for users with limited network bandwidth or someone in urgent to use of full network bandwidth.

Some people even asked, why is my Internet getting freaking-slow after Windows 10. Yes, the answer is clear, Windows Update. Microsoft have decided to let the service to go autopilot and you probably see they run almost every time you start up your machine. Wicked or Mindful? Ask Microsoft. 

Lets get to the point !

Step 1:


- Click/Touch/Press on your Start key
- Type in 'services'
- Click on the 'Services' with a cogwheel logo

Step 2:

- Find Windows Update, right click on it and click Stop
- Do the same for another service 'Background Intelligent Transfer Service' as well.

BITS is used since early windows to utilize idle network bandwidth for downloading the Windows Update, exposed through COM and can be utilized in other way. More information for the COM can be found here.
https://www.codeproject.com/Articles/17639/Using-the-Background-Intelligent-Transfer-Service

Step 3:
Actually your done. But just in case do check your network bandwidth by right clicking on the taskbar and open up your task manager.




This step actually suspend the Windows Update process and they will resume when you reboot.

SUPER SIMPLE MODE.
1. Launch command prompt in administrator
2. Copy this and throw them into your CMD
- net stop wuauserv
- net stop bits

Extra Tips :
If you are running on WiFi, you can just follow this :

Search for "Change Wi-Fi settings", click on Advanced Options, enable the Metered Connection.

This will delay the updates until you decide to turn it off again.

END

* I do not actually recommend you to turn off Windows Update permanently but this is just a temporary solution in case you need it. Windows Update are a crucial element of Windows itself and updating Windows to the latest one is always recommended. Security wise, stability wise. 

Netezza Administration : Getting each Database size

Run query ! Just like MAGIC ! - SELECT current_timestamp AS SAMPLE_TIME        ,t. database AS DATABASE_NAME        , round(nvl (...