InfoWorld

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

Use PowerShell when you have many scripts to deploy. Use PowerShell if you have a hard time remembering the SQL cursor syntax or think it’s just too much trouble to manage for simple ops, such as ...
MCPmag

How To Quickly Test a SQL Connection with PowerShell

Unfortunately, not every SQL database is always available when we expect it to be. When you're creating automation scripts to discover, add, update or remove records from a remote SQL database, you ...
Ars Technica

Powershell. SQL Query. How to determine if a query returns no results?

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 minutes ...
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 ...
InfoWorld

Building a multi-zone and multi-region SQL Server Failover Cluster Instance in Azure

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.