Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Day Zero with PowerShell Expand / Collapse
Author
Message
Posted Tuesday, May 10, 2011 7:22 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 10:42 AM
Points: 41, Visits: 123
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
Posted Wednesday, May 11, 2011 5:03 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 17, 2014 11:29 AM
Points: 331, Visits: 1,254
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
Posted Friday, May 13, 2011 3:31 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 9, 2014 10:43 AM
Points: 39, Visits: 192
Simply Great Work and i started learning Power Shell Atlast with your help. Looking forward for more classes.
Post #1108741
Posted Monday, May 16, 2011 9:51 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:41 AM
Points: 505, Visits: 636
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
Posted Tuesday, May 24, 2011 10:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 1, 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
Posted Tuesday, May 24, 2011 11:38 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 10:42 AM
Points: 41, Visits: 123
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
Posted Monday, October 24, 2011 5:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 9, 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
Posted Monday, October 24, 2011 5:57 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 10:42 AM
Points: 41, Visits: 123
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
Posted Monday, January 2, 2012 6:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
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
Posted Monday, January 2, 2012 8:43 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:19 PM
Points: 181, Visits: 422
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 »

Add to briefcase ««123»»

Permissions Expand / Collapse