|
| Featured Contents |
| Question of the Day |
|
| The Voice of the DBA |
Daily Coping Tip Be thankful for your food and the people who made it possible I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours. |
Admin Challenges Across Scale and Time I've never been interested in working on large systems. I know some people relish the challenge, and certainly there is a lot to learn, but I've always valued my sleep and time with family. I like getting away from work, seeing my wife and kids, and I've found enough after hours work on (relatively) small systems to keep me occupied. To be fair, I've often dealt with large in terms of numbers of systems, rather than a large single system. For some reason, managing 200-300 instances that have 50GB databases is much less stressful than a 10TB single instance, at least for me. In 1999, I was offered a job managing a 13TB database on SQL Server v6.5. I declined that job, and was glad I did. I think a 40TB SQL Server 2017 instance is likely easier to manage, though maybe Taryn Pratt would have taken either challenge. I was interested to see her writeup on migrating a 40TB database recently. Even if you don't have a large multi-TB system, the challenges Taryn faced are similar to ones I've had on smaller systems, where I was still space constrained. In some places, a 50GB system might be limited in storage, and you might encounter some of the same issues. You also might have the same moving target problem, where the information you are moving keeps changing and your processes struggle to catch up. This is the type of documentation and evaluation that I'd like to see more people produce about their daily (or weekly or yearly) challenges. Having examples of what worked, maybe what didn't, and the thoughts behind solving problems helps others learn and grow their skills. Even if you only write this for internal co-workers, it's a good learning experience. It's also good practice for your communication skills, which are going to be very important in the new normal of pandemic work environments. I'd love to publish more stories like this, of how you solved the challenges you face as a developer or DBA. If you can write about things, send me a draft. If you need help anonymizing things for your employer, I'm happy to help. If you don't want to do this publicly, at least consider documenting this type of effort internally. Others might learn, and you'll have a nice item to present to your boss at review time. Steve Jones - SSC Editor Join the debate, and respond to today's editorial on the forums |
|
| Featured Contents |
