Enterprise Policy Management Framework

  •        57

The Enterprise Policy Management Framework is a reporting solution on the state of the enterprise against a desired state defined in a policy. Extend Policy-Based Management to all SQL Server instances in the enterprise. Centralize and report on the policy evaluation results.

http://epmframework.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

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.

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.

O Library


O Library is a SQL 2008/2012 Framework that enables developer to add a .Net feeling to their T-SQL code and aims to bring a bit of fun into T-SQL development.

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.



SQL Server 2008 Extended Events SSMS Addin


SQL 2008 Extended Events are a powerful new way of troubleshooting problems with SQL Server. One short coming is that there is no UI support for this new feature. The Extended Events Manager is a SSMS Addin to bridge this gap.

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.

SQL Compact data and schema script utility


This console app and SQL Server 2008 Management Studio add-in helps you better manage your SQL Compact development efforts. It allows you to script schema and data to a .sql file, which can be used in any context. It also scripts DML for use in SSMS scripts.

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

SQL Server FineBuild


FineBuild provides 1-click install and best-practice configuration of SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005

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.

ExpressProfiler


ExpressProfiler is a simple but good enough replacement for SQL Server Profiler. Can be used with 2005/2008/2008r2/2012/LocalDb, either express or standard

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.

Epmf - PowerShell: Enterprise Policy Based Framework for SQL Server


PowerShell: Enterprise Policy Based Framework for SQL Server

SQL 2005 Service Manager


Welcome to the SQL 2005 Service Manager project. SQL 2005 Service Manager is a replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server. It allows the management and monitoring of all local SQL Server related ...

SQL Trim


Function removes white spaces (incl. ones in the middle). For Microsoft SQL Server 2005/2008

SQL Server Separation of Duties Framework


Implement to provide a means for the DBA to execute processes which require elevated privileges. Solution is used when organizations dictate that a DBA does not have sysadmin privileges.

Fulltext Management for SQL Server (Express)


This Addin for SQL Server Management Studio allows you to manage your fulltext catalogs easily. It even works for SQL Server Express editions, so now you can use a nice GUI instead of unhandy SQL commands.