note

[DB][PowerShell] SQL Server バックアップを曜日単位で共有フォルダにコピー

SQL Server 製品版では、定期的なバックアップをメンテナンスプランで構成することが多いと思います。 BACKUP DATABASE コマンドの出力先に共有フォルダを指定することも可能ではありますが、SQL Server 実行ユーザーに権限が必要ですし、ローカルにバックアップ ...
GitHub

SQL Power Doc is a collection of Windows PowerShell scripts and modules that discover ...

Before you can document your SQL Server environment with SQL Power Doc you'll to meet the following requirements: Permissions - SQL Power Doc makes connections to ...
note

#514 PowerShellで実践するPKI構築：AD CS導入からIIS/SQL暗号化までの全手順

PowerShell による証明書設定作業の詳細レポート このレポートでは、Aras CE 学習環境の構築において実施した証明書関連作業に焦点を当て、そこで使用した PowerShell コマンドを体系的にまとめます。Windows Server 管理の初学者でも理解しやすいよう、各コマンド ...
GitHub

PowerShell scripts to general SQL Server workload against AdventureWorks database schemas

This tool is currently only supported on Windows and PowerShell. It has not yet been tested on PowerShell Core. It will though work remotely against SQL Server on Linux. NOTE: For SQL Server 2014 and ...
Microsoft

SQL PowerShell: July 2016 update

This post was authored by Ayo Olubeko, Program Manager, Data Developer Group. The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of ...
Visual Studio Magazine

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