I'm at the 2013 PASS Summit in Charlotte, NC, this week, and presented a session about documenting your databases using SQL Power Doc. I'm blown away that it's been downloaded over 3,000 times since version 1.0 and have received some really great feedback from people using it in their environments.
To celebrate Summit week, the presentation, and the download milestone I'm pleased to announce that version 22.214.171.124 is now available! Full release notes are available here, and you can download the latest version here.
In addition to lots of big fixes, this release includes three significant features:
- I've corrected an issue with connectivity to named instances running locally using the Shared memory protocol. This has been a big annoyance since a lot of people are trying out SQL Power Doc on their local machines where they're running named instances of Developer Edition. Out of the box Developer edition has only shared memory enabled so this is nice to get this fixed.
- I've added columns to the tabs for Server Permissions, Server Roles, Database Permissions, and Database Roles in the Database Engine workbook with the TSQL syntax to recreate the permissions/role associations.
- I've added Windows API calls to resolve the members of AD Groups used for Server logins. This is especially useful for auditing because you can now see the actual members of the group at the time the server was documented.
Big thanks for the 3,000+ people who have downloaded SQL Power Doc so far and I hope you enjoy the new version!