Maintenance Jobs any SQL DBA should have in production

I recently stumbled upon an article by Tara Kizer that lists her commonly used db tasks. I think this article is pure gold and would like to share it with you. I already implemented a few of these jobs on my production servers and I am beginning to see positive results. Tara is suggesting to put maintenance jobs into a database dedicated just for that, maintenance and then schedule these stored procedures as jobs. Read Link



Popular posts from this blog

Vista Vulnerability Report mentions Ubuntu 6.06 LTS

Running CockroachDB with Docker Compose and Minio, Part 2

Doing "print screen" on a Mac is a pain in the ass