SQL Power Doc is a collection of Windows PowerShell scripts and modules that discover, document, and diagnose SQL Server instances and their underlying Windows OS & machine configurations. SQL Power Doc works with all versions of SQL Server from SQL
Server 2000 through 2012, and all versions of Windows Server and consumer Windows Operating Systems (e.g. XP) from Windows 2000 through Windows Server 2012 and Windows 8. SQL Power Doc is also capable of documenting Windows Azure SQL Databases.
Guides & Documentation
- SQL Power Doc collects exhaustive information about your SQL Server instances - more than any other documentation tool
period. Here's the complete list.
- Start here for a complete list of what's required to use SQL Power Doc
- If you've never touched Windows PowerShell before, or even if you have but you're a bit shaky on installing modules and running scripts, this is where you'll want to start. This guide provides a detailed walkthrough of everything you need to do to use SQL
- SQL Power Doc isn't limited to just SQL Server - because it collects information about Windows it can also be used to perform an inventory of your entire Windows environment. This guide will show you how.
- Version 126.96.36.199 (View Changelog)
- Added version recognition for SQL 2014
- Misc. bug fixes & functional improvements
- Updated code gathering database permissions to include objects not found in sys.objects but which have permissions on them (e.g. Assemblies, Asymmetric Keys, Certificates, etc.)
- Version 188.8.131.52 (View Changelog)
- Misc. bug fixes
- Added logic to resolve members of a Windows Group server login
- Added columns to Excel workbooks to show definitions for server permissions, server roles, database permissions, and database roles
- Version 184.108.40.206 (View Changelog)
- Version 220.127.116.11 (View Changelog)
- Improved error handling in several modules
- Fixed bugs reported since version 18.104.22.168
- Added 11 new & updated 3 existing database engine assessment checks
- Version 22.214.171.124
- The NetShell module included with SQL Power Doc is distributed with permission from
- The inspiration for several of the diagnostic checks in SQL Power Doc came from Brent Ozar Unlimited's
sp_Blitz™ stored procedure. While they do similar things, sp_Blitz™ looks at some things that are beyond the scope of SQL Power Doc. If you've looking to squeeze every bit of performance out of a
SQL Server instance sp_Blitz™ is a great resource to check out.