Day Zero with PowerShell

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Aaron Nelson » Day Zero with PowerShell

21 posts, Page 1 of 3

1 2 3 »»»

Day Zero with PowerShell

Rate Topic

Display Mode

Topic Options

Author

Message

Aaron Nelson - SQLvariant

Posted Tuesday, May 10, 2011 12:01 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 12:54 PM
Points: 41, Visits: 120

Comments posted to this topic are about the item Day Zero with PowerShell

@SQLvariant
I have a PowerShell script for you.

Post #1105861

Thomas Williams

Posted Tuesday, May 10, 2011 12:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 5:12 PM
Points: 1, Visits: 78

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

Post #1105886

colin.frame

Posted Tuesday, May 10, 2011 3:24 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 9:37 AM
Points: 92, Visits: 131

Thomas - yes. Also "ft -a" instead of "ft-a" in the example script.

Other than that, finally got me going with PowerShell - thanks Aaron!

Post #1105957

Aaron Nelson - SQLvariant

Posted Tuesday, May 10, 2011 4:39 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 12:54 PM
Points: 41, Visits: 120

Yes, there whould definitely be a space.

Sorry, the editor isn't properly rendering the code that I posted.

@SQLvariant
I have a PowerShell script for you.

Post #1105998

Dexter Jones

Posted Tuesday, May 10, 2011 8:17 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, February 14, 2013 1:56 PM
Points: 52, Visits: 265

This is great...just great...

One of the ~~excuses~~ 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!

Post #1106156

Steve Jones - SSC Editor

Posted Tuesday, May 10, 2011 8:42 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 11:20 AM
Points: 31,437, Visits: 13,752

Added spaces into the code. Should look fine now.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1106178

Aaron Nelson - SQLvariant

Posted Tuesday, May 10, 2011 8:56 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 12:54 PM
Points: 41, Visits: 120

DJ (5/10/2011)

Nice article, Aaron. It is very nice to have the requirements assembled in one place.

Thank you!

Thanks DJ, glad you liked it. There should be more 'good reasons' to use PowerShell coming out very soon Wink

@SQLvariant
I have a PowerShell script for you.

Post #1106200

Eric Stimpson

Posted Tuesday, May 10, 2011 3:15 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, January 17, 2013 9:57 AM
Points: 59, Visits: 113

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$SQL2
008 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

Post #1106533

SQLRNNR

Posted Tuesday, May 10, 2011 6:08 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754, Visits: 12,337

Thanks much for all of these tips.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1106582

Aaron Nelson - SQLvariant

Posted Tuesday, May 10, 2011 7:18 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 12:54 PM
Points: 41, Visits: 120

For running the example script you will probably need to elevate your shell (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.

@SQLvariant
I have a PowerShell script for you.

Post #1106591

« Prev Topic | Next Topic »

21 posts, Page 1 of 3

1 2 3 »»»

Permissions