Kunal RanpuraOct 23, 201910 minPowerShell Function to Automate Monitoringclear #Install-Module ImportExcel #output file location: c:\powershell\Report_PROD_.xlsx #Input File C:\powershell\sqlservers.txt...
Kunal RanpuraAug 13, 20194 min5 - Scripts I use every single day1). Script to see what is running in your SQL Server. select * from sys.sysprocesses where status = 'suspended' and spid >10 and hostname...