If you have a requirement to carefully have the output file against each sql agent job step, you can use this script. If incase, there are many sql agent jobs and by any reason if any of the step does not have proper o/p file, this script can automatically create the o/p file.
2019-05-03 (first published: 2016-05-20)
1,535 reads
If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script
2019-05-03 (first published: 2015-07-08)
2,128 reads
The script will be helpful to kill all the user sessions before performing the refresh of the database.
2019-05-03 (first published: 2011-03-29)
2,648 reads
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2019-05-03 (first published: 2015-07-07)
836 reads
2019-05-03 (first published: 2015-09-13)
1,915 reads
Remove backup folders from multiple servers.
2019-05-03 (first published: 2014-12-09)
615 reads
The query will help to find whether my database backup to a specific instance of SQL Server is running fine. If HH> 1, this would signify that the backup is running, else this is a failure.
2019-05-03 (first published: 2012-08-25)
1,231 reads
A script to help you cleanup Files/Folders & Sub-folders.
2019-05-03 (first published: 2015-07-30)
62 reads
2019-05-03 (first published: 2015-05-08)
1,127 reads
Query to find the Job Output file location at each job step.
This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.
2019-05-03 (first published: 2015-04-24)
3,304 reads
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Several times now, I've seen a post asking for a solution. I've replied, and...
Comments posted to this topic are about the item Data > Hype
Comments posted to this topic are about the item Create and Read the Analysis...
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers