Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2015-01-29 : 13:29:30
|
| I'm a Database Administrator.I hear some much talk about the need to learn PowerShell scripting. But because TSQL is so powerful I'm wondering if there are tasks you can perfrom with Powershell that cannot also be done with TSQL or SSIS.Are you as a DBA using Powershell and in what ways?Thanks for any feedback. Jacl |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2015-02-02 : 10:01:40
|
| I use PowerShell to automatically restart my sqlserver service if it goes down for some reason.Javeed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-02-03 : 01:32:19
|
| Hi, I use Powershell extensively. One of the big advantages of Powershell is the DBA can manage multiple SQL Server Instances. For example, you can iterate through instances and create a critical error report. Or you can perform all sorts of OS reviews.It is very useful tool, that has many built-in cmdlets . It's a matter of deciding in which circumstances to use Powershell. It's not a replacement for TSQL.Here's a list of some Powershell scripts I use regularly - http://www.sqlserver-dba.com/2012/07/powershell-scripts-for-dba.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
PowerShell for a DBA