Index all microsoft hotfixes


Microsoft has a crappy hotfix index mechanism. I want to change this, and I’ve done this by indexing all support.microsoft articles myself.

To do this you need a SQL server with the following table configuration
Capture

Then you run the indexer script. It goes through all hotfixes inefficiently but gets the job done.
All support.microsoft.com/kb pages are indexed. From 1 to 4000000

Result in MSSQL looks something like this:

Capture

Due to web formatting the script can’t be displayed here. Instead I’ve linked it below as a .txt file
Script

Of course, there is a hotfix browser that is used to search and view these but it’s not done yet.