Wednesday, February 3, 2016

Connect to WS2012 WSUS Internal Database

To connect to the Windows Internal Database (WID) WSUS, install SQL Management Studio and connect to the server using:


\\.\pipe\MICROSOFT##WID\tsql\query

You may confirm the SQL instance name in red against the startup service description using services.msc.

As there is a constant error of "WSUS server is still processing a previous configuration change", this is what I need to execute on the database instance:

USE SUSDB; 
UPDATE tbSingletonData SET ResetStateMachineNeeded = 0

Monday, August 24, 2015

Making Sense of "User-Based Recommender in 5 minutes"

Have you wondered how Amazon recommend new items to you? This is an  example of Machine Learning implementation, which is a type of Artificial Intelligence. I have followed an introductory example of Apache Mahout and shared this on LinkedIn.