SQL Archives - Collab Logic

SQL

Get IP Address and Port Details of Database Servers and Instances

If you want to find out the IP Addresses and Port number information for all your SQL servers and the instances configured in the SQL cluster, the below script will be helpful. It will require an input file Get-IPDetail_Input.txt where you have to specify the servers and instances you want the details Read more…

1,979 total views

By , 8 years ago

SQL

SQL script to find overLapping SQL Jobs

On your SQL server, you will see a lot of jobs. For backups, for SQL maintenance or jobs specific to your application. If these jobs overlap and during the execution they are trying to read/modify the same database, they might go in a deadlock. To find out the jobs which Read more…

2,070 total views

By Shubham Bansal, 8 years7 years ago