DBA + PowerShell = Why?
1. creating sql server database inventory
2. listing installed hotfixes , service packs
3. listing running/blocking processes
4. killing blocking process
5. checking disk space usage
6. setting wmi server event alerts
7. executing sql query multiple servers
8. reorganizing/rebuilding index
9. running dbcc commands
dont understand in each point why need it?
if havea real based example in worklife apply 1 or many of list better understand.
you need able via powershell, because there scenarios need perform these actions on large collection of servers, or many databases on same server.
one of servers manage has on 100 databases on single server. have had scenarios security configuration each server needs change, or index has created on each of databases on table.
powershell enables go through list of servers / databases foreach statement, , perform actions on each server.
you don't want doing these things hand.
i've made scripts gather list of installed programs domain computers, gather ip configuration of each computer via wmi in complex network, end processes on computers, etc.
as administrator, going have cases need on multiple computers / users @ same time, or on large number of computers / users.
scripting answer.
Windows Server > Windows PowerShell
Comments
Post a Comment