SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Aaron Nelson / Day Zero with PowerShell / Latest Posts

RE: Day Zero with PowerShell

Doctor Who 2 — Mon, 02 Jan 2012 08:50:04 GMT

I wish I'd ask this when I first replied, but I forgot. Anyway, what is that [b]Administrator: Windows PowerShell ISE[/b] window? Whenever I've gotten into PowerShell before I would just hit Run and then type "PowerShell", so what's this? And should I use that, instead of using the Run | PowerShell option?

RE: Day Zero with PowerShell

Doctor Who 2 — Mon, 02 Jan 2012 08:43:09 GMT

I really appreciate this, as PowerShell is something I've wanted to get into for a while. I've used it, but only minimally. This series will help me tremendously, I'm sure.

RE: Day Zero with PowerShell

mohammed moinudheen — Mon, 02 Jan 2012 06:33:46 GMT

Aaron,I should have read this article the first time it was published. This is one cool thing you have written on Powershell and has got me interested in this subject. I need to make sure not to delay learning about Powershell.Thank you.

RE: Day Zero with PowerShell

Aaron Nelson - SQLvariant — Mon, 24 Oct 2011 17:57:42 GMT

Yes. I think you just need to open up the x86 version of the ISE and you'll be fine.

RE: Day Zero with PowerShell

ifiok.moses — Mon, 24 Oct 2011 17:46:23 GMT

Thanks for a nice post. Can't wait for subsequent posts.BTW i got this error message:[b]PS C:\Windows\system32> import-module SQLProfilerAttention. This module only runs on x86 Powershell. Execution interrupted[/b]Any ideas?

RE: Day Zero with PowerShell

Aaron Nelson - SQLvariant — Tue, 24 May 2011 11:38:09 GMT

[quote][b]steve.treloar (5/24/2011)[/b][hr]Great article Aaron! [/quote]Thanks Steve!I did another article the following day on how to calculate data file space usage using PowerShell [url=http://www.sqlservercentral.com/articles/powershell/73289/]http://www.sqlservercentral.com/articles/powershell/73289/[/url]I have quite a few blog posts about useful PowerShell+SQL scripts here: [url=http://sqlpowershell.com/]http://sqlpowershell.com/[/url]

RE: Day Zero with PowerShell

steve.treloar — Tue, 24 May 2011 10:27:29 GMT

Great article Aaron! Now that I have it installed and functional. (I've been procrastinating for a long time) I would really like to see more on what people are using PowerShell for on a daily basis. How can PowerShell make my life easier? I am not a DBA. I and another guy, manage about 100 MickySoft servers, six of them are SQL, for which we have a couple DBA's to do most of the data manipulation and application programming for. I have a SharePoint farm implemented, but the DBA's don't do much of anything there. I'm looking forward to more articles on PowerShell relative to SQL.Thanks. -Steve

RE: Day Zero with PowerShell

shawnjohnson — Mon, 16 May 2011 09:51:20 GMT

Great article! I've been working at learning PowerShell for a little while now and look forward to future articles.I can manually stop the agent on my test server myself and when I run the script it will tell me that it is stopped but the script won't start it. I get this error:Start-Service : Cannot find any service with service name 'SQLSERVERAGENT'.At line:12 char:14+ Start-Service <<<< + CategoryInfo : ObjectNotFound: (SQLSERVERAGENT:String) [Start-Service], ServiceCommandException + FullyQualifiedErrorId : NoServiceFoundForGivenName,Microsoft.PowerShell.Commands.StartServiceCommandWhat am I missing?

RE: Day Zero with PowerShell

JakDBA — Fri, 13 May 2011 15:31:37 GMT

Simply Great Work and i started learning Power Shell Atlast with your help. Looking forward for more classes.

RE: Day Zero with PowerShell

SQLSandwiches — Wed, 11 May 2011 17:03:10 GMT

Good stuff! Wish I had found this article a year ago. I struggled getting started before. I hope this helps people just getting their feet wet.

RE: Day Zero with PowerShell

Aaron Nelson - SQLvariant — Tue, 10 May 2011 19:22:08 GMT

[quote][b]Steve Jones - SSC Editor (5/10/2011)[/b][hr]Added spaces into the code. Should look fine now.[/quote]Mucho Mejor! Gracias Senior Jones.

RE: Day Zero with PowerShell

Aaron Nelson - SQLvariant — Tue, 10 May 2011 19:18:17 GMT

For running the example script you will probably need to [u]elevate your shell [/u](I keep forgetting that I have a pre-emptive work-around in place for this). Just hold down the Ctrl + Shift Keys and then click on the shortcut for the ISE. Then run the script in that window. I'll work on getting a Summary for the Execution Policies however your best/most complete answer is in the Help files. June does a good job with those.

RE: Day Zero with PowerShell

SQLRNNR — Tue, 10 May 2011 18:08:46 GMT

Thanks much for all of these tips.

RE: Day Zero with PowerShell

Eric Stimpson — Tue, 10 May 2011 15:15:27 GMT

Thanks DJ. Can you maybe explain the purpose of the Set-ExecutionPolicy command? Also, when I tried the sample code, I got an error when trying to restart a server which I manually stopped:Start-Service : Service 'SQL Server Agent (SQL2008) (SQLAgent$SQL2008)' cannot be started due to the following error: Cannot open SQLAgent$SQL2008 service on computer '.'.At line:6 char:14+ Start-Service <<<< + CategoryInfo : OpenError: (System.ServiceProcess.ServiceController:ServiceController) [Start-Service], ServiceCommandException + FullyQualifiedErrorId : CouldNotStartService,Microsoft.PowerShell.Commands.StartServiceCommand

RE: Day Zero with PowerShell

Aaron Nelson - SQLvariant — Tue, 10 May 2011 08:56:18 GMT

[quote][b]DJ (5/10/2011)[/b][hr]Nice article, Aaron. It is very nice to have the requirements assembled in one place.Thank you![/quote]Thanks DJ, glad you liked it. There should be more 'good reasons' to use PowerShell coming out very soon ;-)

RE: Day Zero with PowerShell

Steve Jones - SSC Editor — Tue, 10 May 2011 08:42:12 GMT

Added spaces into the code. Should look fine now.

RE: Day Zero with PowerShell

Dexter Jones — Tue, 10 May 2011 08:17:24 GMT

This is great...just great...One of the [strike]excuses[/strike] obstacles for not getting started with PowerShell has been just getting things set up to be able to actually use the thing. This seemed to be a secret passed among an elite priesthood in dark misty passage ways. Not a place for mere mortals to tread.Now, along comes Aaron Nelson and puts everything in a single, easy to digest article.You've totally blown my excuse to not use PowerShell! Sheesh.Ok, seriously. Nice article, Aaron. It is very nice to have the requirements assembled in one place.Thank you!

RE: Day Zero with PowerShell

Aaron Nelson - SQLvariant — Tue, 10 May 2011 04:39:22 GMT

Yes, there whould definitely be a space. Sorry, the editor isn't properly rendering the code that I posted.

RE: Day Zero with PowerShell

colin.frame — Tue, 10 May 2011 03:24:48 GMT

Thomas - yes. Also "ft -a" instead of "ft-a" in the example script.Other than that, finally got me going with PowerShell - thanks Aaron!

RE: Day Zero with PowerShell

Thomas Williams — Tue, 10 May 2011 00:49:34 GMT

Should there be a space in the "Set-ExecutionPolicy RemoteSigned" command?

Day Zero with PowerShell

Aaron Nelson - SQLvariant — Tue, 10 May 2011 00:01:17 GMT

Comments posted to this topic are about the item [B]Day Zero with PowerShell[/B]