Time to Look at PowerShell


clockOne of the things that became clear after the preview of the next version of Windows Server (code named Windows Server 8) and the direction that Microsoft announced at its recent BUILD 2011 conference is the fact that Microsoft is seriously moving toward using PowerShell as its preferred management tool. While the GUI isn’t going away Microsoft has added almost 2000 PowerShell cmdlets to Windows Server 8 – radically expanding the areas that can be managed with PowerShell.

While not everyone knows it SQL Server can already be managed using PowerShell. SQL Server 2008 and 2008 R2 both provide PowerShell cmdlets that let you navigate the database, create database objects, and run queries. You can start SQL Server’s PowerShell cmdlet by entering sqlps on the command prompt or by opening SSMS and right clicking on an object.

While most DBAs don’t use PowerShell yet now would be great time to get started learning it. There is a learning curve for PowerShell but once you get the hang of it it’s reasonably straightforward. There’s no doubt that PowerShell will be an important management tool going forward and it’s more capable than you might think.

For a more complete introduction to using PowerShell with SQL Server you might want to check out:: http://msdn.microsoft.com/en-us/library/cc281954.aspx

In addition, you might want to read Accessing SQL Server Data from PowerShell by Robert Sheldon.

Please or Register to post comments.

What's SQL SELECT Blog?

SQL Server news, FAQs, tips, and techniques from Michael Otey, technical director for SQL Server Pro.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×