SQL Server Support for PowerShell!

MSDN Blog Postings » SQL Server Support for PowerShell!

MSDN Blog Postings » SQL Server Support for PowerShell! — Tue, 13 Nov 2007 09:38:35 GMT

PingBack from http://msdnrss.thecoderblogs.com/2007/11/13/sql-server-support-for-powershell/

Microsoft SQL Server 2008

Fredrik Wall — Tue, 13 Nov 2007 11:00:24 GMT

I och med ITForum i Barcelona så händer det välldigt mycket i Microsoftvärlden just nu. Och för oss som

SQL Server y PowerShell

Be Geek My Friend — Tue, 13 Nov 2007 12:21:37 GMT

Entre las cosas por las que espero con ansiedad la salida de SQL Server 2008 estan sin duda entre las

re: SQL Server Support for PowerShell!

Rob Cannon — Tue, 13 Nov 2007 20:44:20 GMT

Any hope of seeing Powershell integration inside Visual Studio? I want to run scripts that that are part of a solution or project that will interact with VSTS and then let Visual Studio know to update it's view of VSTS.

PowerShell : nouvelle version de PowerGUI, apparition dans la CEC et SQL Server 2008

CoqBlog — Sun, 25 Nov 2007 19:04:52 GMT

Tout d'abord, une nouvelle version de PowerGUI est disponible, avec notamment l'apparition du debugger

re: SQL Server Support for PowerShell!

Olivier — Thu, 06 Dec 2007 11:46:48 GMT

I have tried to run this PowerInitSMO.psl but it is not giving any effect. what can be the cause.

You are SO in the know

Billie Jo Murray — Wed, 12 Dec 2007 03:58:51 GMT

Wow!! You are SO cool for having information that we don't, and you're so coy about letting us know that you have this information that we dont.

I also like how you elude to the fact that you have even MORE information, "but can't tell us". So shut up already, why even say that?

People in this industry measure self-worth by letting others know they have information, but won't tell others what that informations is. I'mn fo frickin sick of it! Shut up already!!!

re: SQL Server Support for PowerShell!

PowerShellTeam — Wed, 12 Dec 2007 09:18:23 GMT

> I'mn fo frickin sick of it! Shut up already!!!

Having a bad day? :-)

I didn't mean to be teaser. I wanted to convey the fact that there is strong internal adoption but I can't announce other people's confidential information. You are right though - that combination turned the entry into a tease.

All that said, you can all get in on these secrets and more by joining Microsoft and getting on the internal mailing lists. (Let's see if I can turn this into a recruiting opportunity :-) ).

Jeffrey Snover [MSFT]

Windows Management Partner Architect

Visit the Windows PowerShell Team blog at: http://blogs.msdn.com/PowerShell

Visit the Windows PowerShell ScriptCenter at: http://www.microsoft.com/technet/scriptcenter/hubs/msh.mspx

re: SQL Server Support for PowerShell!

Doug Finke — Sat, 22 Dec 2007 17:24:47 GMT

Jeffery

How do I go about getting recruited?

re: SQL Server Support for PowerShell!

Serg — Fri, 26 Jun 2009 22:28:38 GMT

I am trying to use Powershell SQL script and invoke it from C#.

First, I initialize sql provider using Initialize-SqlpsEnvironment.ps1 (http://blogs.technet.com/patricg/attachment/3121583.ashx). Then I cd to sql\localhost and getting sql instance. Everything works perfectly from command line, but when I am using C# like next, I got no results back.

sRc = RunspaceConfiguration.Create();

sInvoker = new RunspaceInvoke(sRc);

string script = @".\sqlProvider.ps1";

Collection<PSObject> results = sInvoker.Invoke(script);

I know that I can do this from C# itself, but need to use script as script will be used in different places by sysadmins.

Am I missing something that this code doesn't work?

Thanks for help,

Serg