Geeks With Blogs

News

This blog has moved to ericnelson.wordpress.com

 Subscribe in a reader

Add to Google Reader or Homepage


Links
View my teams slideshare
These postings are provided "AS IS" with no warranties, and confer no rights.



IUpdateable has moved to ericnelson.wordpress.com Please visit http://ericnelson.wordpress.com

I am beginning to think it could be humble sqlps.exe. SQL Server 2008 includes powershell support – it is very, very nice. I have barely scraped the surface of sqlps but I know it is a feature that needs to be more widely talked about. You can launch from the GUI by right clicking on an object and sqlps will start at just the right spot.

How about a dir of my databases:sqlps1

Or even better – a dir of the parameters of a stored procedure:

sqlps2

To find out more you can check out the PowerShell Overview or Dan of the SQL team has a 50minute TechEd video covering it off rather nicely (skip the first 20minutes if you are already familiar with Powershell)

There is also a detailed explanation of why the team went for a mini-ps approach. Well worth a read.

Posted on Wednesday, January 21, 2009 2:11 PM SQL Server | Back to top


Comments on this post: The best feature in SQL Server 2008 is sqlps.exe?

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Eric Nelson | Powered by: GeeksWithBlogs.net