ニュース

Ars Technica13年

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 ...
InfoWorld16年

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

Use PowerShell to script objects on a schedule or in a special order. Use PowerShell if you need to switch between windows and SQL commands or even share data between the two.
Redmond Magazine2月

Using PowerShell To Back Up SQL Server Express Edition

Even now, a full workstation backup seems like overkill. As I have recently discovered though, you can use a PowerShell script to back up a SQL Server Express database.