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 2 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 7:22 PM

SSC Rookie

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

Steve Jones - SSC Editor (5/10/2011)

Added spaces into the code. Should look fine now.

Mucho Mejor! Gracias Senior Jones.

@SQLvariant
I have a PowerShell script for you.

Post #1106593

SQLSandwiches

Posted Wednesday, May 11, 2011 5:03 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 10:57 AM
Points: 323, Visits: 1,195

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.

Post #1107407

JakDBA

Posted Friday, May 13, 2011 3:31 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 10, 2013 8:31 AM
Points: 38, Visits: 164

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

Post #1108741

shawnjohnson

Posted Monday, May 16, 2011 9:51 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:51 PM
Points: 306, Visits: 418

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.StartServiceCommand

What am I missing?

Post #1109519

steve.treloar

Posted Tuesday, May 24, 2011 10:27 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 01, 2012 2:55 PM
Points: 16, Visits: 71

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

Post #1114212

Aaron Nelson - SQLvariant

Posted Tuesday, May 24, 2011 11:38 AM

SSC Rookie

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

steve.treloar (5/24/2011)

Great article Aaron!

Thanks Steve!
I did another article the following day on how to calculate data file space usage using PowerShell http://www.sqlservercentral.com/articles/powershell/73289/

I have quite a few blog posts about useful PowerShell+SQL scripts here: http://sqlpowershell.com/

@SQLvariant
I have a PowerShell script for you.

Post #1114266

ifiok.moses

Posted Monday, October 24, 2011 5:46 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 09, 2012 5:27 PM
Points: 4, Visits: 23

Thanks for a nice post. Can't wait for subsequent posts.
BTW i got this error message:

PS C:\Windows\system32> import-module SQLProfiler
Attention. This module only runs on x86 Powershell. Execution interrupted

Any ideas?

Post #1195514

Aaron Nelson - SQLvariant

Posted Monday, October 24, 2011 5:57 PM

SSC Rookie

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

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

@SQLvariant
I have a PowerShell script for you.

Post #1195517

mohammed moinudheen

Posted Monday, January 02, 2012 6:33 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582

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.

Mohammed Moinudheen

Post #1228902

Doctor Who 2

Posted Monday, January 02, 2012 8:43 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 6:38 PM
Points: 97, Visits: 236

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.

Rod

Post #1228924

« Prev Topic | Next Topic »

21 posts, Page 2 of 3

««1 2 3 »»

Permissions