• Adam Thurgar

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:

https://archive.codeplex.com/?p=sqlpowerdoc


10 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t