SQL Power Doc

  •        97

SQL Power Doc is a collection of Windows PowerShell scripts & modules that discover, document, & diagnose SQL Server instances & their underlying Windows OS.




Related Projects


T-SQL codegen script that creates audit trail triggers for SQL Server 2005 / 2008. Back-out procs, view to deleted rows, & rowhistroy function. Version 2 adds user context, SQL stmt, insert log, and base table DDL options. by SQL Server MVP Paul Nielsen. 4 yrs of bug fixes.

Data Dictionary Creator

Data Dictionary Creator (DDC) is a simple application which helps you document SQL Server databases. It stores all the information in Extended Properties, so it's easier to keep the documentation in sync with the database as it changes.

SQL Server PowerShell Extensions

The primary goal of SQL Server PowerShell Extensions (SQLPSX) is to provide intuitive functions around the SMO objects which are backward compatible with SQL 2000. A secondary goal is to provide an application which reports flatten/effective security settings.

Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server

SPADE simplifies the process of standing up a new SQL Server instance by applying standard Operating System pre-configurations, Installing SQL Server and then applying post-configurations and creating standard objects.

SQL Server DB & SSIS Powershell Deployment

A lightweight way to automate SQL Server builds and deploy SSIS packages to development environments. Uses Red Gate SQL Compare, SVN and Powershell. Ideal for DW/BI projects.


DBDocumenter, an interactive tool designed to generate the SQL Server 2000/2005/2008 documentation. It supports, export of documentation to HTML(WEB) format. It helps the developer , who's design the Data Layer for the application. He/she can easily find the name of column etc...

ReportingServicesTools - Reporting Services Powershell Tools

This project contains PowerShell scripts that allows you to perform various operations with SQL Server Reporting Services. In order to use the scripts included in this project successfully, please download/clone the entire project as there are dependencies between the scripts.All of our scripts were written with the assumption that you will be executing them against SQL Server 2016 Reporting Services default instance (i.e. mssqlserver). However, we understand this may not be the case for you. So for each script, you will see that we have provided a way for you to specify the name and/or version of your SQL Server Reporting Services instance name. Sometimes the version of your SQL Server instance is also required. If you do not provide one, we will assume that you want to execute this against the default instance.

SQL Server Central Management System

The SQLCMS uses and extends a series of features in SQL Server 2008 to manage and monitor SQL Server Instances, from versions 2000-2008. It is a series of modular components that also allows integration with other solutions such as MOM or OpenView installations.

turtle SQL

turtle SQL, a product designed to generate the SQL Server 2005/2008 documentation. It supports, export of documentation generated to Excel, Pdf and XML.

Sql Server Permissions Auditor

Sql Server Permissions Auditor helps audit permissions on your Sql Server 2005 and up database. The software will audit permissions on tables, stored procedures, and look for several patterns of concern in stored procedures. It requires admin permissions to run. The first ...

Restart SQL Audit Policy and Job

Resolve SQL 2008 Audit Network Connectivity Issue.


Module designed to simplify working with SQL Server from Powershell

powerTrace - a PowerShell snapin for SQL Server Trace files

This is a snapin for Microsoft PowerShell which allows for the loading and exploration of SQL Trace files using PowerShell. This provider has been initially designed to work with trace files from SQL Server Analysis Services.

GetMsSqlDump - a mysqldump-like tool for MSSQL

GetMsSqlDump is the mssql counterpart (or something similar) of mysqldump, written for Microsoft SQL Server, in PowerShell. I'd call it mssqldump if it weren't in use. Using this script you can dump your database content into a file in a form of INSERT INTO statements.

DB>doc for Microsoft SQL Server

Tool to generate documentation for Microsoft SQL Server database structure. Generates documentation in HTML, XML or WikiPlex format.

PowerShell Data Processing Extension for SQL Server Reporting Services

Plug this into SQL Server Reporting Services to create reporting based on your PowerShell scripts. The PowerShell DPE transforms your PowerShell output into a DataSet that can be consumed by SSRS.

ExportSQLScript - Export MS SQL 2008R2/2008/2005/2000 objects to script

Command line driven utility to export MS SQL objects to script files suitable for database creation and revision control. Uses 2008R2 Server Management Objects (SMO) which are compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

GraphView - GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to efficiently manage graphs

GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to manage graphs. It connects to a SQL database locally or in the cloud, stores graph data in tables and queries graphs through a SQL-extended language. It is not an independent database, but a middleware that accepts graph operations and translates them to T-SQL executed in SQL Server or Azure SQL Database. As such, GraphView can be viewed as a special connector to SQL Server/Azure SQL Database. Developers will experience no differences than the default SQL connector provided by the .NET framework (i.e., SqlConnection), only except that this new connector accepts graph-oriented statements.GraphView is a DLL library through which you manage graph data in SQL Server (version 2008 and onward) and Azure SQL Database (v12 and onward). It provides features a standard graph database is expected to have. In addition, since GraphView relies on SQL databases, it inherits many features in the relational world that are often missing in native graph databases.

SQL Data Capture - Black Box Application Testing

A tool for capturing and analyzing data modifications; an audit trail generator with a data modifications viewer. Helps with testing, troubleshooting and exploring application functionality. ASP.NET 3.5 C#, SMO application. Audit and CRUD generators are included.

Standalone SQL Agent

The Standalone SQL Agent provides SQL Express users with the ability to use the SQL Server Agent features of the database system even though Microsoft has decided to remove the SQL Agent from the SQL Express product. This project is developed using Visual Basic.NET 2008.