Category Archives: Day to day

Recovery Models and Backups Re-Found

This is a short version of what got me to understand recovery models and the what happens during a backup. Wow Kimberly Tripp is a great asset. Back in the day I downloaded it as an individual chapter. I’ve forwarded … Continue reading

Posted in Day to day, DBA | Leave a comment

The Biggest Variable

Which is more important, the chariot or the horse? Of course the question assumes it is possible to separate two things which may be¬†inseparable. Is the question reasonable? Better is to strive to be the best and acknowledge the value … Continue reading

Posted in Day to day, DBA, Employment | Leave a comment

Having a number two for log backups

The server which holds the production log backups was not reponding yesterday. It was a pain to go into the tran log backup jobs and manually change them to a new share until the problem was resolved, so I decided … Continue reading

Posted in Day to day | Leave a comment

using sp_msforeachdb

I really like sp_msforeachdb. For example, here is the sql to my regular maintenance jobs: exec sp_MSforeachdb ‘DBCC CHECKDB(?) with NO_INFOMSGS, ALL_ERRORMSGS’ exec sp_msforeachdb ‘if db_id(”?”) <> db_id(”master”) and db_id(”?”) <> db_id(”tempdb”) begin use [?];exec sp_dbreindex_or_indexdefrag;end’ exec sp_msforeachdb ‘if db_id(”?”) … Continue reading

Posted in Day to day, DBA | Leave a comment

Cleaning up sql job ownership

We have a lot of jobs owned by many different accounts due to the currently lax security. Before cleaning up the local admins group and removing all sysadmin role members it is important to make sure the jobs that are … Continue reading

Posted in Day to day, DBA | Tagged | Leave a comment

SQL Blogs I like

http://www.sqlskills.com/BLOGS/PAUL/ http://www.sqlskills.com/BLOGS/KIMBERLY/ http://sqlfool.com/ http://sqlinthewild.co.za/

Posted in Day to day, DBA | Leave a comment