Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Johan Bijnens » Me, myself and Powershell
Add to briefcase
16 posts, Page 1 of 2
12»»

Me, myself and Powershell Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
ALZDBA
Posted Monday, December 05, 2011 10:01 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, June 17, 2013 2:13 PM
Points: 6,866, Visits: 8,071
Comments posted to this topic are about the item Me, myself and Powershell

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1216773
Roy Ernest
Posted Tuesday, December 06, 2011 10:11 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:29 AM
Points: 3,280, Visits: 6,626
Good Job Johan... Nice examples.

-Roy
Post #1217254
skron
Posted Tuesday, December 06, 2011 10:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 2:42 PM
Points: 227, Visits: 56
I have found Powershell to be invaluable to me as a DBA. I have been able to replace a large chunk of monitoring tools with it. Keep giving us the good examples.
Post #1217291
ALZDBA
Posted Tuesday, December 06, 2011 12:39 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, June 17, 2013 2:13 PM
Points: 6,866, Visits: 8,071
Roy Ernest (12/6/2011)
Good Job Johan... Nice examples.


Thank you, Roy. I hope it gets people started.

skron (12/6/2011)
I have found Powershell to be invaluable to me as a DBA. I have been able to replace a large chunk of monitoring tools with it. Keep giving us the good examples.


Thank you skron for sharing your experience.
That's the kind of info we - sql devoted people - need if we want to get people started and experiencing how Powershell can help out fairly easy.
Please share some use cases and code samples if you can.

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1217370
mohammed moinudheen
Posted Wednesday, December 07, 2011 1:07 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 17, 2013 10:29 PM
Points: 2,178, Visits: 3,599
Thank you Johan, really good article.

Mohammed Moinudheen
Post #1217610
Samuel Vella
Posted Wednesday, December 07, 2011 2:21 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, June 15, 2013 10:38 AM
Points: 329, Visits: 1,869
skron (12/6/2011)
I have found Powershell to be invaluable to me as a DBA. I have been able to replace a large chunk of monitoring tools with it. Keep giving us the good examples.


It's quite handy as a developer as well powershell is great for scripting out objects in a much more flexible and repeatable manner than SSMS allows.
Post #1217654
ALZDBA
Posted Wednesday, December 07, 2011 5:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, June 17, 2013 2:13 PM
Points: 6,866, Visits: 8,071
mohammed moinudheen (12/7/2011)
Thank you Johan, really good article.


Thank you, Mohammed.

Samuel Vella (12/7/2011)
skron (12/6/2011)
I have found Powershell to be invaluable to me as a DBA. I have been able to replace a large chunk of monitoring tools with it. Keep giving us the good examples.


It's quite handy as a developer as well powershell is great for scripting out objects in a much more flexible and repeatable manner than SSMS allows.



Thank you, Samuel.
Please share some use cases and code samples if you can.

DBA/sysadmins really need to get started exploring Powershell!





Number of reads after 24hours: 4,955 reads. I'm quite happy with that


Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1217799
Samuel Vella
Posted Wednesday, December 07, 2011 8:21 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, June 15, 2013 10:38 AM
Points: 329, Visits: 1,869
ALZDBA (12/7/2011)

Thank you, Samuel.
Please share some use cases and code samples if you can.

DBA/sysadmins really need to get started exploring Powershell!


Use cases:
Dev environment with 100's of tables, stored procedures, views functions etc... some of which need to be promoted to the production environment.
A combination of excel and powershell means you can maintain a list of items and quickly pull the creation scripts out of the development environment.

The spreadsheet and associated macros are probably worth an article in their own right
Post #1217953
ALZDBA
Posted Wednesday, December 07, 2011 8:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, June 17, 2013 2:13 PM
Points: 6,866, Visits: 8,071
Samuel Vella (12/7/2011)
ALZDBA (12/7/2011)

Thank you, Samuel.
Please share some use cases and code samples if you can.

DBA/sysadmins really need to get started exploring Powershell!


Use cases:
Dev environment with 100's of tables, stored procedures, views functions etc... some of which need to be promoted to the production environment.


That would be an interesting topic.


A combination of excel and powershell means you can maintain a list of items and quickly pull the creation scripts out of the development environment.

The spreadsheet and associated macros are probably worth an article in their own right



Very true.

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1217983
hemanth.damecharla
Posted Wednesday, December 07, 2011 8:55 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 27, 2013 8:41 PM
Points: 448, Visits: 320
Automating daily tasks is not only easy with Posh but, fun as well

Chad Miller's MSCS code on poshcode site is a wonderful starting point if you want to get a hang of WMI. I would like to thank Chad for posting this particular piece of code http://poshcode.org/2886.

I tried it as challenge to get all the data in one shot (Cluster, Groups, Resources and resource types), it was an awesome feeling when I was able to do it. After that, you can build a hash with the data; add some methods and vallah, you don't have to look at cluster admin console again

PowerShell is aptly named.

-Hope is a heuristic search ~Hemanth
Post #1218004
« Prev Topic | Next Topic »

Add to briefcase
16 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.