How Do You Return Only User Databases with Get-SqlDatabase

The differential PoSh backup

PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server

Aaron Nelson explains how you can take an existing SQL query, run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers.

The default PoSh backup

Backing Up SQL Server Databases is Easier in PowerShell than T-SQL

Learn how easy the new SQLServer module makes backups of SQL Server databases.

Managing Packages Using Windows PowerShell

Windows hasn't had a package manager in the style of the Advanced Packaging Tool (APT) of Linux distributions. Apt-get is a great way of installing packages and other software. We have Chocolatey, of course which has a growing library of software and even allows you to automatically update software. Now PowerShell has an 'official' way of using any system, such as NuGet, Chocolatey, GitHub or PSget. It is definitely useful and likely to mature into an indispensable tool for Windows users. Nicolas explains wh.

Getting the version of Powershell

Getting Modules

Managing SQL Server with PowerShell

Powershell SSMS SQL Registrations