<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
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
16 posts, Page 2 of 2
««
1
2
Me, myself and Powershell
Rate Topic
Display Mode
Topic Options
Author
Message
ALZDBA
ALZDBA
Posted Wednesday, December 07, 2011 10:35 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861,
Visits: 8,045
hemanth.damecharla (12/7/2011)
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
Power
Shell is aptly named.
I can't stress the FUN part enough.
There is indeed a whole bunch of practical info and great samples out there.
Chad is one of the people posting on a regular basis and knowing his stuff.
Thank you for the feedback.
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 #1218121
pkrudysz
pkrudysz
Posted Wednesday, December 28, 2011 6:14 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:10 AM
Points: 48,
Visits: 257
Oftentimes folks applaud PowerShell for things, and I see that those things can be done and automated just as easily in t-sql. I am looking for a list of PowerShell stuff that CANNOT be done in SQL, and that a DBA can find handy. One example I can think of is accessing non-SQL performance counters. Anything else useful for a DBA?
Post #1227305
ALZDBA
ALZDBA
Posted Thursday, December 29, 2011 12:50 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861,
Visits: 8,045
e.g.
- setting startup parameters if your service account doesn't have local sysadmin at windows level.
- granting auth at windows level ( e.g. to push backup files to a safe zone )
- are you using SMO to configure sqlserver things ?
you name it, you got it.
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 #1227665
pkrudysz
pkrudysz
Posted Thursday, December 29, 2011 4:15 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:10 AM
Points: 48,
Visits: 257
ALZDBA (12/29/2011)
- setting startup parameters if your service account doesn't have local sysadmin at windows level.
- Cool.
ALZDBA (12/29/2011)
- granting auth at windows level ( e.g. to push backup files to a safe zone )
- xp_cmdshell
ALZDBA (12/29/2011)
- are you using SMO to configure sqlserver things ?
- No, no need. I use sqlserver (SSMS/T-SQL) to configure sqlserver things
Post #1227712
ALZDBA
ALZDBA
Posted Thursday, December 29, 2011 7:53 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861,
Visits: 8,045
pkrudysz (12/29/2011)
ALZDBA (12/29/2011)
- setting startup parameters if your service account doesn't have local sysadmin at windows level.
- Cool.
ALZDBA (12/29/2011)
- granting auth at windows level ( e.g. to push backup files to a safe zone )
- xp_cmdshell
ALZDBA (12/29/2011)
- are you using SMO to configure sqlserver things ?
- No, no need. I use sqlserver (SSMS/T-SQL) to configure sqlserver things
Of course you can do it all manually, time and again.
You are correct, xp_cmdshell can take you a long way.
Powershell
only
provides the means to hook up to more than just what's available in DOS (xp_cmdshell) and vbscript.
That means for many systems people, that don't program e.g. c#.net, .. they have to learn only one language syntax, hook up to their target namespace and use that software's proper methodes to configure whatever needed.
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 #1227789
ALZDBA
ALZDBA
Posted Thursday, January 05, 2012 11:09 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861,
Visits: 8,045
Please allow me to point to a very interesting project at codeplex:
Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server
pre-configure windows, install sql, post install scripts, ....
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 #1230990
« Prev Topic
|
Next Topic »
16 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
