それでは、PowerShellを使ったSQL Server 2008の操作方法について見ていこう。 PowerShellを単体で起動して、SQL Serverに接続することももちろん可能(詳細はこちらを参照)だが、SQL Server Management Studioから、そのままPowerShellを起動することもできる。まずSQL Server ...

それでは、SMOを使用してデータベースの作成を行ってみることにしよう。まず、SQL Server Management Studioから「データベース」を右クリックして「PowerShellの起動」をクリックする。すると「Databases」フォルダからPowerShellが起動するので、以下のコマンドを実行 ...

Let's examine the challenges of running Windows-dependent PowerShell scripts from Linux and compares three practical approaches -- dual booting, WinBoat and Windows Server RemoteApp -- to maintaining ...

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

PowerShell can save you a lot of time on Windows admin tasks, but to use it effectively you need to understand how it works. Here's a crash course in Windows PowerShell scripting basics to get you ...

Back in 2008, I wrote a piece called PowerShell Tips and Tricks, which covered the then-relatively new Windows scripting language and some cool things you could do with it. Although PowerShell has ...