I have personally participated in quite a large number of these TSQL Tuesday events – despite not being every single one. This is a roundup of my personal participation across the years.
T-SQL Tuesday Participation Over the Years
Month: December 2018
T-SQL Tuesday 109: Influence Somebody Recap
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!
Synonyms in SQL Server – Good and Bad
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.
Maintenance Plan Owner – Back to Basics
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.
To Influence or Be Influenced?
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.
The Mystery of Missing Backup Files
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.
Capture the Flag – The Trace Flag
Despite the controls in place there always seems to be some change that is unknown or even some cowboy that makes changes as s/he sees fit and forgets to notify people or follow process.
T-SQL Tuesday 109: Influence Somebody Invite
Building on the work of these three fine individuals, here comes the difficult task. You have been the benefactor of some awesome help from somebody else. You even wrote about it and in a way, told that person how they impacted you, your career, or both. You have set goals for yourself to become a better you after some personal reflection, meditation, introspection. Then you have given back to the community in some way.
I am not asking you to be braggy, just aware and cognizant. What have you done to impact somebody else in the last 13 months?
SHUTDOWN SQL Server
I explore the question of if it is possible to reboot the server from within SQL Server or even simply shut down the entire server. Well, you can certainly bounce the server from within a TSQL script – if you have adequate permissions (or know how to elevate your permissions).