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 12»»

Me, myself and Powershell Expand / Collapse
Author
Message
Posted Monday, December 5, 2011 10:01 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:40 AM
Points: 7,001, Visits: 8,439
Comments posted to this topic are about the item Me, myself and Powershell

Johan


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
Posted Tuesday, December 6, 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, July 17, 2014 10:43 AM
Points: 3,309, Visits: 6,700
Good Job Johan... Nice examples.

-Roy
Post #1217254
Posted Tuesday, December 6, 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
Posted Tuesday, December 6, 2011 12:39 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:40 AM
Points: 7,001, Visits: 8,439
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


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
Posted Wednesday, December 7, 2011 1:07 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:21 PM
Points: 2,270, Visits: 3,780
Thank you Johan, really good article.

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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:06 AM
Points: 337, Visits: 1,981
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
Posted Wednesday, December 7, 2011 5:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:40 AM
Points: 7,001, Visits: 8,439
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


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
Posted Wednesday, December 7, 2011 8:21 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:06 AM
Points: 337, Visits: 1,981
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
Posted Wednesday, December 7, 2011 8:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:40 AM
Points: 7,001, Visits: 8,439
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


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
Posted Wednesday, December 7, 2011 8:55 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 1:42 AM
Points: 448, Visits: 322
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 12»»

Permissions Expand / Collapse