1 DBA's Professional Blog
Small tokens of gratitude and small actions help to build this wonderful SQL Community that gives and gives and gives. Humility leads us to seek out ways to give more and become better as individuals. Give and you will receive!
How you use a synonym can be a huge asset or it can be a significant dampener to performance. There are benefits and uses for these nifty little things. Check them out and let us know how you have been able to put synonyms to use to benefit you.
Have you ever taken over a server that had several maintenance plans on it? Have you ever really checked who the owner of those plans is? Or, maybe you had a failing job relating to one of these maintenance plans and you changed the job owner, but did you really fix the root cause? That could be one of those things that you inherited that could be annoying but you just don’t know it yet.
Getting feedback from others is that little check that is needed to help progress and move in the right direction. When allowing time and opportunity for feedback from others, you are doing yourself a service as well as them.
Managing database backups is a critical role of the successful DBA. Understanding what the backup plan is and ensuring backups occur on schedule is not always transparent to the DBA as exposed in this tale.