Voice of the DBA

Tag: career2

  • Catch up with T-SQL Tuesday

    T-SQL Tuesday is a monthly blog party where we get an invitation the first week of the month to write on a specific topic for the second Tuesday of that month. Adam Machanic came up with the idea and he chooses the hosts.

    If you’re interested in hosting, contact him.

    While there’s a sense of community and participation here, and certainly the chance to showcase some of your knowledge for others, it’s also got another benefit.

    It’s the chance for you to learn something.

    Not by reading other’s posts, but by writing your own. This is your opportunity to bolster your own skills, and teach yourself something new.

    Don’t Worry About Timing

    I know many of you are worried about the pressure of producing something good. I know many of you will find that the first weekend of the month is really busy and you can’t write.

    That’s fine.

    I’ve got a list of all previous invitations and topics. Go back and pick one of them and write your own post today. Start working on it, teach yourself something, and put some thoughts down. Research what others have done by looking through the roundups. Get a friend to review the work and see if it’s readable and makes sense.

    Do that ten times. It might take you ten months, but I’m sure you can write something down about SQL Server once a month.

    When you get ten, start a blog and publish them. Use the T-SQL Tuesday tag, but I’d also encourage you to use the #SQLNewBlogger tag as well. Start showing your boss that you’re improving your skills. Be ready to impress you potential next new boss with a series of posts on SQL topics.

    Your career will be better off, and the world will start to see better software being written.

    Start improving your skills this weekend, or start documenting the learning you already do. Either way, start building a better brand for your career.

  • The Tally Table

    I saw a someone post a question recently about solving a T-SQL problem. One of the answers given used a tally table, which the original poster didn’t understand. A few follow up links pointed them in the right direction, but it got me wondering.

    How many of you know what a tally table is and how to create one? I bet a few of you don’t, which might mean you’ve never had the need. Or it might be a hole in your skill set and you didn’t realize that a tally table can be very useful in solving a number of problems. Anything from generating dates to splitting strings. There are plenty more ways to use one, and feel free to mention more in the comments that others might not have tried.

    I’m not sure the tally table is a core T-SQL skill, but I think it’s an important one you should learn as you grow your skills. After you’ve mastered the basics (Insert/update/delete, aggregates, outer joins) Adding in an understanding of window functions, the APPLY operator, and CTEs are also important to allow you to become better at solving the problems you run into with more efficient T-SQL.

    Steve Jones

    The Voice of the DBA Podcast

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

  • Teambuilding

    I worked in a large company at one point in a team of 20 people. My boss made it a point every month to take a long lunch with the team and engage in some teambuilding. Usually one of us would have to remain at the office, but we rotated the duty so that most of use could participate. We would go to movies, go bowling, have a team lunch, watch a baseball game, or something similar.

    At Redgate, the various groups schedule days out, and last month the company had a large “day out”, bringing many of the Americans over from the US to participate. It was a good time, and the chance to get to know some of people in the company I rarely interact with.

    Team building has been hit or miss, but I’m curious how many of you engage in the activity. I know I’ve worked in plenty of companies where there was no effort made to build a team. This week I wanted to ask you:

    Do you engage in team building at work and what events have you enjoyed?

    Maybe I should ask what worked well to help build a team, but sometimes the enjoyment and bonding go and in hand.

    I thought of this recently as my daughter wanted to ride zip lines for her birthday. We packed up the family to go, and while it wasn’t everyone’s first choice, we enjoyed it and had a few hours to laugh and joke with each other. It turned out to be a much better family bonding time than a few people expected. If you’ve never tried it, I might recommend it as a way to have fun with a small group of people.

    Steve Jones

    The Voice of the DBA Podcast

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

  • Be Professional

    I’m not a very comfortable flyer. I do it regularly, and I’ve gotten used to it, but I’m a bit scared when the plane appears to be anything other than a slow elevator to me. I’m not quite sure how I’d react if I were on a small plane and experienced what this author did above Washington State.

    The piece is really about being professional, and the way the pilot reacted in that story certainly wasn’t the professional image most of us want from their pilots. A few might like that, just as a few might accept most behaviors, but the majority expect something else.

    In the article, there are seventeen habits that can make you look more professional in the piece I linked, and for the most part I really think these are the types of traits and images that a professional wants to project. Whether you’re a CEO or a developer, having confidence and candor are as important as realism and caring. We all expect professionals to follow through on commitments and be diligent in their work.

    The only item I might disagree with is fitness. Perhaps that’s more important in some areas than others, but I have found many people that are highly professional, competent, dependable, and worth every penny that I pay them, but not very healthy. Some might be unhealthy to the point I’d be concerned for their long term prospects, but that wouldn’t mean they aren’t good professionals in the short term.

    Steve Jones

    The Voice of the DBA Podcast

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