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
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
We decided to build a quick worker thread alert so we know when we are near the limits.
2019-05-02
1,571 reads
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-05-01
961 reads
2019-04-30
1,844 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
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Hi everyone I have a 1000 line SQL query that is too long to...
hi, now and then i want one connection in my ssis pkgs to use...
Comments posted to this topic are about the item AlwaysON health check alerts