Documenting your SQL Server
Not many people like writing documentation. DBA's especially. So when you have to document information on your SQL Servers how do you go about it? As part of a large migration project from SQL Server 2000 to SQL Server 2012 we had to produce handover documentation on every server (non-prod and prod) before it could be accepted by the BAU DBA team. This could have been a time consuming process with the potential for a lot of inconsistencies. But after some R&D we decided to use SQL Power Doc.
SQL Power Doc is a collection of Windows PowerShell scripts and modules that discover, document, diagnose SQL Server instances and their underlying Windows OS. This was perfect for creating the baseline to know what the SQL Server environment looked like when it was handed over and have a comparison for the future.
Check it out at: