What? No cmdlets? — SQL Server Powershell

When you start using the SQL Server Powershell extensions, you will find there are not a whole lot of cmdlets. The expectation is indeed that Powershell support means: cmdlets for every administrative operation you can perform. Did we miss something here? Nope, this is by design. We do intend to ship more cmdlets for common…

2

Some background on the use of minishells, such as SQLPS

Jeffrey Snover posted a very clear article about minishells and SQL Server’s use of it:  http://blogs.msdn.com/powershell/archive/2008/06/23/sql-minishells.aspx  Jeffrey is Powershell’s Architect, well respected in the Powershell community, and it’s good to read about his perspective on this.


Evaluating SQL Server Policies through Powershell

I found this ping-back on my previous blog post which gives a good overview of one very useful cmdlet that we ship with the Powershell extensions that SQL Server 2008 will deliver. A very helpful article one of the SQL Server MVPs, Lara Rubbelke, on the use of Invoke-PolicyEvaluation: http://sqlblog.com/blogs/lara_rubbelke/archive/2008/06/19/evaluating-policies-on-demand-through-powershell.aspx  


SQL Server Powershell is here!

I am very excited that SQL Server will ship with a pretty solid first release of Powershell extensions with SQL Server 2008. The SQL Server Powershell extensions deliver on a vision that we’ll expand on in the next releases to come. So what’s in this release of SQL Server Powershell?   –          SQLPS – a…

21