top of page
Search

Documenting your SQL Server

  • Adam Thurgar
  • Jul 30, 2018
  • 1 min read

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


 
 
 

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...

 
 
 
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...

 
 
 
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...

 
 
 

Comments

bottom of page