This article will provide an overview of SQL Power Doc, a powerful script to document SQL Server including prerequisites, purpose, installation, processing, and output. Automation seems to be an increasing need in the IT industry. At present, PowerShell leads the game in Windows-based environments since it is capable of handling highly complex workflows. PowerShell is the go-to choice when it comes to automating even requirements such as configuration management. I got the opportunity to assess SQL Power Doc recently. I have worked with PowerShell a lot (I have even written a book on it) and have built my share of automation and designing tools using it. When I took a look at SQL Power Doc, I felt the tool did have its share of capabilities to help DBAs in its own way. Let me detail some of my experiences while exploring this tool.
What Is SQL Power Doc?
SQL Power Doc was written by Kendal VanDyke. It is a command line PowerShell manifest consisting of several PowerShell modules that will help you build a solid foundation to Discover, Document and Diagnose SQL Server instances and Windows Operating system details. Additionally, you’ll gain some insight into what directions you can go for future exploration. It basically invokes PowerShell cmdlets and give you the necessary details front and center.