SQLAdmin

Install SqlServer module: Install-Module -Name sqlserver Typical warning: Untrusted repository You are installing the modules from an ...

With SQL Server 2012 SQLPS was changes from a mini-PowerShell to a PowerShell module. This makes is much simpler to import the functionality...

For a long time I have checked the databases by DBCC CHECKDB , but I would like to check the database in PowerShell with SMO to include the...

Recreating a database in a higher environment is a common task. Quite often it is not that smart just to restore a back, as you then get dat...

It looks like a SMO object is implicit converted to a String object, when it is used in a function call by a parameter name. I have a func...

A differential database backup of a single database can be done like this using SMO and PowerShell: [void][System.Reflection.Assembly]::Lo...

Having worked on a (new) backup solution for my employer, I have spend several hours fighting with examples not working. Until I found the e...