マイナビニュース

【管理効率化への挑戦】PowerShell × SQL Serverが実現する"新しいDB管理"

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

【管理効率化への挑戦】PowerShell × SQL Serverが実現する"新しいDB管理"

最後に、PowerShellとSQL Serverを組み合わせた少し実践的なサンプルを見てみよう。 会員制のWebサイトなどで、日々の会員数の推移をメールでレポートとして受け取りたい、というケースはしばしばあるだろう。そこで「特定のテーブルのレコード件数をメール ...
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 ...
Redmondmag.com

Planning for PowerShell Script Usage in a Multiplatform Environment

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

How can I store in a central location lots of PowerShell scripts and execute on timer

Lets say I'm going to have 50 various PowerShell scripts to do "stuff".<BR><BR>All of this work is being done for a single application and that application uses 3 different SQL Server 05 (soon to be ...
Computerworld

PowerShell for beginners: Scripts and loops

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

PowerShell tutorial: The basics of PowerShell scripting

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

Introduction to Windows PowerShell

In 2006, Windows Script Host (WSH) and the Command Prompt shell got a new sibling when Microsoft released a completely new environment called Windows PowerShell. PowerShell has some similarities to ...