Database Configuration Management
I've uploaded a collection of projects and code related to database configuration management for use in managing and reporting on multiple SQL Server instances and databases across multiple environments.
Stargazer
Stargazer is a metadata support solution that also collects information on Sql Agent jobs for reporting.
The job reporting code was written by Ed Pollack at https://www.Sqlshack.com/tracking-job-performance-Sql-server.
T-Sql and Microsoft Sql Server are used.
The purpose of Stargazer is to store metadata (for example, server names) once and use it for many solutions.
Fully qualified domain names are supported for managing multiple environments.
Enterprise
Enterprise is a Sql Server configuration management and warehouse solution. Much of its code is derived from SqlPowerDoc (https://Sqlpowerdoc.codeplex.com).
The code is written in T-Sql and Powershell. Microsoft Sql Server, Analysis Services Tabular and PowerBI are the products used.
The purpose of Enterprise is to provide information for reporting and infrastructure as a service (IaaS) projects.
Enterprise collects data and loads into Inventory tables within Sql Server. The following information is collected:
Base runs
Sql Server base runs
Computer information
General configuration information for the Sql instance
Database information including backup history
Service information for the Sql services
Linked server information including options and security configuration
Enterprise Policy Management
EnterprisePolicyManagement is a copy of the solution posted at https://epmframework.codeplex.com/.
I have rearranged the jobs and consolidated the policies and conditions, along with writing some of my own.
The code is written in T-Sql and Powershell. Microsoft Sql Server is used.
The purpose of EnterprisePolicyManagement is to provide policy evaluation and collection against a Sql Server estate.
Policies and conditions will vary based on business and technical need.
Voyager
Voyager is a Sql Server configuration management solution that evaluates and visualizes policy evaluation from Policy Based Management and Desired State Configuration.
The code is written in T-SQL and Powershell. Microsoft Sql Server, Analysis Services Tabular and PowerBI are the products used.
The purpose of Voyager is to visualize policy evaluation and provide a way to set a desired state for Sql Server instances.
Desired State Configuration provides a way to define configurations, test them and set them as state.
Reporting is done in PowerBI on PowerBI Report Server. The data from Policy Based Management and Desired State Configuration is combined.
Sentinel
Sentinel is a reporting and management application built on top of Policy Based Management for Sql Server and the EPM Framework (https://epmframework.codeplex.com).
It was originally written by James Milner and altered by Raymond Gallagher.
T-Sql and Microsoft Sql Server are used along with reports designed for Sql Server Reporting Services.
The purpose of Sentinel is to provide configuration and policy management for a Sql Server estate.
Sentinel provides an alternative application and methodology to viewing the data available through the EPM Framework.
Please click here for the projects and code.