The following logic checks for a particular user names that are possible SQL Job owners. Then returns a list to you of the found Jobs with said owners. Then it changes those […]
Here’s some quick SQL logic to return all the Job Owners.
Here’s a script which will help you extract information from the default trace. This should serve as a quick audit query, and not a long term audit solution. You can modify the […]
Here’s some SQL logic to help you query the RoboCopy output log file. Remember; you can query most things using an XML output so for this to work with the log file […]
Here’s some SQL logic that will track Robocopy Durations. I created this for an ETL process that basically takes a local database backup and copies it to another database server. I then […]
The following SQL logic will create the base tables, and first Job for the ZTRACK system.
Here’s the update statement for adding notes to the ABOUT_ZTRACK table
The ZTRACK database is my simple little tracking solution without having to incorporate any other database services, or associated SQL Features. Basically this is a custom Database that’s managed with just a […]
Here’s some quick SQL Logic that will shrink all SQL Data Files but ignore Filestream Data Files, and FullText Data Files. This will also ONLY affect databases that are currently ONLINE and […]
You can put this into a Maintenance Job by it’s self. It creates two temporary tables. One is a master list of all databases, types of objects, indexes, type of indexes etc. […]
I was thinking perhaps someone would want to rename their Job Alert notifications; if they followed the instructions I put on this blog. Don’t forget you have to modify the Trigger on […]
Here’s some quick sql logic to show you a list of all the triggers in a particular table. I’m using the msdb..sysjobhistory table as an example.
Here’s some SQL Logic to help you find where your backups are located.
JOB: DATABASE MIRRORS – FAILOVER ALL MIRRORED DATABASES STEP 10: FINISH MIRROR FAILOVER PROCESS Step logic: Here’s the .sql file for the Job and all it’s steps. create_database_mirror_failover_job.sql.pdf As a reminder; You’ll […]