2016-11-30 (first published: 2016-11-22)
You can eliminate CURSOR many a places using WHILE Loop.
2016-11-29 (first published: 2015-03-30)
If you have Always On and need to stop running database backups to the stand by server, use the script.
2016-11-21 (first published: 2016-11-01)
Refresh all views in a database
2016-10-28 (first published: 2016-10-05)
If you want to extract only deadlock details, use the script.
2016-10-24 (first published: 2014-12-03)
Complete Details About Backups Taken a Day Ago.
2016-10-20 (first published: 2015-05-15)
If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.
2016-10-18 (first published: 2015-06-01)
DBA many a times need to shrink the log files if that grows very large. Though I am not recommending to do it daily or often but if space is an issue and you want to release space to OS, you may use the script.
2016-10-11 (first published: 2016-09-22)
If you have any requirement to extract next 100 sequential date from a present date, you can use the below script. You can change the @datetimeformat value and the output will appear in the same format.
2016-10-10 (first published: 2016-09-26)
If you have a requirement to enable email notification to all the SQL Jobs, then you may use my script.
2016-10-06 (first published: 2016-09-20)