HOW TO Microsoft SQL Server Windows 10 Windows 7 Windows 8 / 8.1 Windows Server 2008 Windows Server 2012 Windows Vista Windows XP

HOW TO download SQL Server Service Packs or Windows Updates Offline Installers

Microsoft Update Catalog contains the list of Windows Updates and also the Updates of Microsoft Products that can be installed via Windows Update functionality.

Using the Search bar it is possible to filter the results to search, for example writing “SQL” you will find a list of Service Packs, Updates, Future Packs and Critical Updates for different versions of SQL Server.

Steps to download and install updates from the Windows Update Catalog

To download updates from the Windows Update Catalog, follow these steps:

  1. Click Download.
    Note If you are prompted, click Accept to accept the license agreement.
  2. Select the location where you want to save the updates. You can either type the full path of the folder, or you can click Browse to locate the folder.
  3. Click Continue to start the download.
  4. When the download is complete, click Close to close the Download Window.
  5. Close the Windows Update Catalog Window.
  6. Find the location that you specified in step 2.
  7. Double-click each update, and then follow the instructions to install the update. If the updates are intended for another computer, copy the updates to that computer, and then double-click the updates to install them.

Source: How to download updates that include drivers and hotfixes from the Windows Update Catalog

Did my HOW TO help you? Leave a reply.

HOW TO Microsoft Tips & Tricks Windows 10 Windows 7 Windows 8 / 8.1 Windows Vista Windows XP

What’s the password of the WiFi I’m connected to?

This post can be applied only to the Microsoft Windows operating systems.

You are connected to a WiFi using your pc with Windows, and you need to know what is the password used to connect into the network

I know two methods to achieve this goal.

Method 1:

  • Right-click in the taskbar in the WiFi icon (marked in red in the image)
  • Click on Open Network & Internet settings
  • Click on the menu Wi-Fi
  • Click on Change adapter options
  • Right-click on your Wi-Fi adapter
  • Click on Status
  • Click the button Wireless Properties
  • Navigate to the Security tab
  • then tick Show characters checkbox to show the WiFi password in the Network security key field.

Method 2:
Open the Command Prompt or Windows PowerShell and run the following command replacing “WiFiName” with the name of the WiFi network you are connected to

netsh wlan show profile name="WiFiName" key=clear | findstr Key

The Key Content will display the WiFi password in the command prompt as a result.

Note: “WiFiName” is not case sensitive but if you don’t write correctly your WiFiName no error and no result will be displayed.

Do you think that my Tip & Trick is useful? Leave a reply.