PowerShell Tips & Tricks: Getting more detailed error information from PowerShell

Allen White wrote this handy blogpost on how to handle error message and get more information out of an error record: http://sqlblog.com/blogs/allen_white/archive/2009/06/08/handling-errors-in-powershell.aspx There is an addtional method to get more information available. I found myself sending this little code snippet in email to many, and almost always I get the response that it saved that…

Talking about SQLPS (SQL Server Powershell extensions) on Runas Radio

I was recently interviewed on RunAs Radio on the new Powershell extensions that we developed for SQL Server 2008. If you want to learn more about SQL Server Powershell download the podcast here : http://www.runasradio.com/default.aspx?showNum=75 If you listened to it then please post your feedback here. Happy listening!


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…


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…


Add oil to fire: SMO and Monad — a flammable combination

Euan pointed me to an interesting article about the use of Monad together with SMO. Those who know me well, know I am somewhat of a scripting biggot and still install Cygwin on all of my boxes as I cannot live without bash, awk, perk, sed, expr and the various other UNIX tools that I have…