I was a little surprised to find that a SQL Server tool I'd just recently heard of, SQLClue v126.96.36.199, was written and supported by an old buddy of mine, Bill Wunder (blog).
When I last saw Bill, he and Donald Farmer (blog | twitter | previous SQLMag article) were in the midst of a no-holds-barred judge-off before a panel of Czech supermodels to finally settle the question of who had the most beautiful and alluring man-locks. I had to turn away in disgust to my only reliable friend, a half-full bottle of rot-gut single malt, because, frankly, we \[bald\] men hate being objectified. Especially by beautiful European supermodels. And if it ever happens to me, ever, anywhere, in my entire life, even just once, I intend to act really angry. \[The entire proceeding paragraph is a boldfaced lie. Even the part about the single malt - my beloved Lagavulin is no rot-gut\]
SQLClue, What's it do?
SQLClue, in both its graphic and command-line interfaces, has a wide variety of features:
- Compare configuration and setup information across many SQL Servers. Archive changes over time.
- Automated change tracking and version of database objects as they change.
- Data Center Runbook tracking to capture all the processes and tasks that a DBA team is doing, thereby insuring no loss of institutional knowledge.
There's a lot more in the tool. But that might be enough to peak your interest.
Take a look at SQLCLue here. Bill has also been really good about updating the docs. So there's lots of information about the tool on his website. (I won't be writing about SQLClue in SQL Server Magazine, since it's not a free tool. But I thought you'd enjoy hearing about it here.)
More content at http://KevinEKline.com