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

Running CockroachDB with Docker Compose and Minio, Part 2

VirtualBox options to start VM in Normal, Detached and Headless Modes

Vista Vulnerability Report mentions Ubuntu 6.06 LTS