Projects

Below is the projects and tools that I am currently working on. Along with links describing those projects and the related code for them.

DBA Diagnostics

Information on the DBA database with it’s tables, procedures, and other database objects

Index Analysis

Index Analysis allows DBAs and developers to analyze the indexes in a database to determine the use, characteristics, and statistics of the index. The project contains the query written in T-SQL and report that can be opened as a custom report in SSMS.

FileSystemHelper SQL Server CLR

FileSystemHelper SQL Server CLR provides a collection of CLR stored procedures and functions for interacting with the file system. Using these stored procedures and functions will allow you to avoid enabling xp_cmdshell on your SQL Server instances.