MCPmag

PowerShell vs. SQL Server Management Studio

When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...
MCPmag

Introduction to SQL Server Management Objects with PowerShell

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...
Redmond Magazine

PowerShell Based SQL Server Backups Revisited, Part 1

A couple of months ago, I wrote an article on how to use PowerShell to back up a database within SQL Server Express Edition. Even though the technique that I described in that post works, the script ...
GitHub

run-a-powershell-v3-script-from-a-sql-server-agent-job.md

As was just mentioned, PowerShell within SQL runs Version 2. If you were unaware that you could run PowerShell from within SQL Server Management Studio (SSMS), right-click on a folder, and select ...
Redmond Magazine

Creating Azure SQL Databases with PowerShell and Azure Resource Manager Templates

There are lots of ways to create MSSQL databases via PowerShell. We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or, if ...
GitHub

overview-of-powershell-cmdlets-for-always-on-availability-groups-sql-server.md

A PowerShell cmdlet can complete by successfully initiating an action. This does not indicate that the intended work, such as the fail over of an availability group, has completed. When scripting a ...
InfoWorld

When you should and shouldn’t use PowerShell in SQL Server

PowerShell is cool, but it's not always appropriate. Here's a quick list to help you decide when to use it PowerShell is one of the coolest new things to come out of Microsoft in a long while, and ...