The following are some useful Open Source tools available to assist with managing and administering a MS SQL Server:
SqlMonitoring Tool
http://sqlmonitoring.codeplex.com/
Also mentioned in http://www.codecapers.com/post/free-scom-alternative-for-sql.aspx
Open DBDiff
http://opendbiff.codeplex.com/
Performance Analysis of Logs (PAL) Tool
http://pal.codeplex.com/
Hopefully others will find them as useful as I have with simplifying my day-to-day DBA tasks.