Tag Archives: policy

PowerShell script error – File not digitally signed : FIX

Today I was working on building PowerShell script to establish SQL Server Database Mirroring. To start with PowerShell, I tried to execute my first built of PowerShell Script on SQLPS, I received the following error.File C:\Temp\Mirroring\Script\DBMirrroringSetup.ps1 cannot be loaded. The file C:\Temp\Mirroring\Script\DBMirrroringSetup.ps1 is not digitally signed. The script will not execute on the system. Please [...]

Policy Based Management – SQL Server 2008

Policy–based management is an approach to database administration based on policies and not tasks. With policy-based management, you can determine the policies, restrictions, and behaviors the SQL Servers in your organization will enforce. Microsoft SQL Server provides a policy-based system for managing one or more instances of SQL Server along with tools for performance monitoring, [...]