If you have any requirement where you want to find out all the SPIDs running on a database along with the program/application name of the SPID and the login details. You can run the procedure to get the details very easily.
2019-05-03 (first published: 2014-06-30)
4,056 reads
If you have a requirement to setup with a default global dbmail profile and account you can use my script.
2019-05-03 (first published: 2015-05-28)
1,068 reads
Wrote the script to take compressed backup with combining many other features.
2019-05-03 (first published: 2015-04-29)
1,042 reads
If you have Always On and need to stop running database backups to the stand by server, use the script.
2019-05-03 (first published: 2016-11-01)
277 reads
You can eliminate CURSOR many a places using WHILE Loop.
2019-05-03 (first published: 2015-03-30)
3,900 reads
This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.
2019-05-03 (first published: 2014-12-24)
1,636 reads
This script will generate 5 lottery numbers plus one mega and you can set how many tickets and the range for the numbers for the different types of lotteries.
2019-04-27 (first published: 2016-07-13)
2,044 reads