Powershell |
|
When I started my current job, the senior DBA started teaching me Powershell. I have to say that sometimes I find myself writing more powershell scripts or processes than TSQL. Powershell is meant to be short and sweet and to the point.
Here is an example of how powerful this tool is.
I needed to disable about 2000 jobs on a database instance. I am sure there is a way to do this with TSQL which would include writing a cursor. I could be wrong on that. In Powershell it was only one or two lines of code. I will post scripts I have used in my daily tasks at work.
Check out this website if you need more info on Powershell.
Powershell.org
Don Jone Youtube Channel
Midnight DBA YouTube Channel
DBATools Website
DBA Checks Website
Learn Powershell In a Month of Lunches
Here is an example of how powerful this tool is.
I needed to disable about 2000 jobs on a database instance. I am sure there is a way to do this with TSQL which would include writing a cursor. I could be wrong on that. In Powershell it was only one or two lines of code. I will post scripts I have used in my daily tasks at work.
Check out this website if you need more info on Powershell.
Powershell.org
Don Jone Youtube Channel
Midnight DBA YouTube Channel
DBATools Website
DBA Checks Website
Learn Powershell In a Month of Lunches