I have imagined this article to be some sort of outline of available solutions for SQL administrators. Now, in this blog post discusses various free solutions for detecting and inventorying Microsoft SQL Server instances. I've found a few, so check them out in the blog post!