Tag Archives: NOT

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

Querying Data in SQL Server Part 2

Calculating column values If you want to do calculations on a column like add, subtract, multiply, modulus or division. You can use the arithmetic operators like (+, -, /, *, %). Now in our table TABLE1 we have one column STDID containing integer values & I want to add all the values by 20. The [...]