Voice of the DBA

Tag: career

  • The Holiday Challenge

    It seems as though I’ve seen many protests and complaints this past holiday season about the extra hours the some retailers were requiring of employees. It started in the US just before Thanksgiving with protests about some stores opening on Thanksgiving day, and it continued through the Christmas season as a few brick and mortar companies decided to stay open 24 hours a day until the holiday.
    For most of us that work in technology, the holidays can be a mixed blessing. We could have a slow time, as other people in the office work less and make less demands of us. We could also be more busy as the slow times mean opportunities for maintenance or enhancements. I’ve even had extremely busy times as we worked the New Year’s holiday to get applications ready for use on Jan 1.
    There was a survey recently and a report that said many IT people don’t get a break during the holidays. They find themselves on call, or responding over the holidays when things break. I’ve certainly experienced this, especially when managers have viewed holidays as a perfect time to take systems down that are otherwise being used heavily by our business. I suspect that much of the impact to IT depends on your particular business and how your systems are used during holidays. If you work at Amazon, I wouldn’t expect to have holidays off.
    The one thing that the survey mentioned people wanted to see changed most was a reduction in the amount of fire-fighting that they perform. It’s no fun when things are permanently broken, and even less fun when you respond to the same issue over and over without actually fixing something once. I certainly have found myself looking for other employment when the amount of fire-fighting time exceeds the amount of enhancement time.
    I hope that the holidays were not too stressful or busy for you, and you have a bit of a break. If not, perhaps it’s time to think about how you might want to change things for next year.
    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 2.5MB) podcast or subscribe to the feed at iTunes and Mevio . feed

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

  • Powershell in a Month – Day 7 Adding Commands

    This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

    Post holidays, day 7 looks at the shell itself and adding in snap-ins and modules. I have to say that the first time I looked at Powershell was in SQL Server 2008 when there was a “mini-shell”, but I didn’t understand what the difference was. I’m sure I’ve read other explanations, but they didn’t make as much sense. Perhaps because I’m more focused this time on learning PoSh it made sense? Not sure.

    In any case. This chapter starts to explain, and emphasize, there is really only one shell for PoSh. This is in contrast to the earlier SQL implementation, but moving forward, everything will be in one shell. The various shortcuts you find for different Microsoft tools and features are the same shell with an “Import-Module” parameter passed in. This is the same way in which the MMC works, and it’s the same way that we often configure other tools, like SSMS and VS, which have add-ins.

    That’s interesting, and good to know. This means I can not only customize my PoSh environment, but I can set up custom environments that can be shared on all computers in an organization or group. That is one of the main concerns I’ve had with PoSh. If I change my environment on my laptop to do things, I need to be sure all the places I’ll deploy the scripts to have the same environment.

    The chapter also look at snap-ins and modules, which are different. In my earlier work with PoSh, the idea of snap-ins seemed to be a pain, almost like installing Perl on every machine. Snap-ins need to be pre-installed and registered on the computer to be added in. The examples in the chapter load the SQL Server snap-ins, though the chapter mentions that snap-ins are not the way forward. Modules are.

    Modules are more like self-contained items that do not need to be installed. They just need to be in the PoSh path (environmental variable) or loaded with the full disk path. If the modules exist in the PoSh environmental variable, then they are auto loaded.

    The rest of the chapter is really devoted to some practice with modules and loading them. There are brief sections that look at how you can pre-configure your own environment automatically with a configuration file that allows you to pre-load modules or specify settings. That can be handy, especially as you add a series of modules to your setup. That also seems like something that you might want to deploy to all servers, or all members of a team, in order to ensure that any scripts you have written will run.

  • DBAs Need to Learn to Develop

    My first exposure to computers was as a child, learning to program in BASIC, Assembler, and Pascal. From there I moved into other areas, such as networking and system administration. I learned about a variety of technologies before focusing on databases, but I found that my knowledge from other areas of computing helped me be a more successful DBA at quite a few jobs.

    Last year we put on a number of SQL in the City Seminars where Grant Fritchey and I talked about development practices. We give a variety of advice and practices that you can use, but one of the best things that we say in our half day event comes from Grant. He says that DBAs need to “Follow the local development paradigm as much as possible.”

    I completely agree with this. I think that many of the practices of building software, as flawed as they might be, are good ideas that many developers use on a regular basis. They know how to work in a flexible manner, tracking their code and keeping it under control, and fixing problems in a rapid manner. As immature as the software development process can be, there are things that we, as DBAs, can learn.

    As SQL Server continues to grow as a platform, there are more and more enhancements, many of which involve programmatic capabilities expanding. I highly recommend that DBAs think about learning more about programming, and specifically a .NET language, if you’ve never used one. If you have, consider brushing up those skills.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( MB) podcast or subscribe to the feed at iTunes and Mevio . feed

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

  • Budget for Training

    I hope everyone had a great holiday season and is refreshed, ready to tackle the new year. Many of you might have made resolutions with the calendar change, and I’d urge you to consider making one more: a resolution to learn something new in 2014 related to your career.

    I’ve been tackling the Powershell Challenge for a little over a month now, and one of the things I’ve found to be problematic is scheduling. With vacation and the holidays, I haven’t had a set schedule in my life. More importantly, I hadn’t scheduled myself specific times to work on Powershell and fell behind in my challenge.

    Andy Warren, co-founder of SQLServerCentral, has a talk about building a professional development plan in which he notes that we need to budget both time and money for our plan. It’s important that you not only commit some time, but that you schedule it. You may also need some money, and you ought not to be afraid of investing in yourself, especially if you are looking to move into a new area, or find a new job.

    I haven’t done a great job of making time for my career over the last month, but I have realized that I need to do so. I am looking to schedule specific times on specific days to work on my skills over the next few months. My plan is to take 2 lunches a week and dedicate that time to working on PoSh. I’m hoping that putting myself on a schedule will help me focus and get through my challenge.

    I would encourage you, on this, the first full week of the new year, to take an hour or two and plan out your learning for the year. My recommendation is you pick at least two six week time periods across the year. During each of those periods, schedule 2-4 sessions a week to learn. They can be half hour to hour slots where you work on a specific skill and improve your knowledge. You could start with one of our Stairway series if you’re looking for ideas. Give yourself at least a week or two, and probably a month, between sessions to recharge. Be sure you are also looking out for opportunities to put your new skills to work throughout the year.

    You are responsible for your career, and today is the first day of the rest of your career.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( MB) podcast or subscribe to the feed at iTunes and Mevio . feed

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.