Voice of the DBA

Category: Editorial

  • MY Data

    Data is merely a set of numbers. However when data is given context, it allows conclusions to be drawn and many of us make a living managing some part of that process every day. Most of us deal with data that is viewed as somewhat public, related to our interactions with businesses and organizations. However we see some of this changing as employers start to gather more data on us through social media and other sources, beginning to use that data to make hiring decisions.

    It can get worse. As Shane Battier says in this article says, “big data is scary.”

    Most of us don’t aren’t hired for our physical performance. While our health can make a difference in how well we write code over time, the regular, subtle decisions of drinking juice or soda don’t affect our performance much on a daily basis. We could argue about that, but from the employer’s perspective, I’m not sure those things matter.

    Or do they? If the cost of employees rises over time, especially with regard to health care or sick time, should employers start to make decisions based on the data? Are we confident in the conclusions from data, which are really probabilities, not actualities? Would you want aspects of your life, perhaps outside of your health (think driving, finance, etc) to be part of the evaluation (or negotiation) process for your employment?

    Perhaps a lighter question, would you be comfortable managing and writing applications that work with employee data and try to analyze, perhaps even strongly recommend, changes in peoples’ live? I’m not sure I would, and I certainly hope we don’t get to the point where the data about our personal lives directly impacts the way we are managed.

    Steve Jones

     

    The Voice of the DBA Podcast

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

  • Prepping for Winter

    Living on a ranch in Colorado means that we have to prepare for winter in a way that we don’t worry about other seasons. Taking care of livestock when the weather gets cold (and snowy) presents challenges, and since it can be a matter of survival, we have to think about potential issues in advance and work to mitigate them before they occur. My return from the PASS Summit last weekend had me outside working on shed with my daughter to prep for this week’s winter storms.
    When working with computers, we don’t usually need to make special preparations for seasons, but we do need to be ready for difficult times. I was reminded of this with a post this week about 12 Things to Check to Prepare for Winter. These aren’t necessarily things you need to check as the temperatures drop, but they are things you might want to examine periodically in your environment.
    In many businesses, we are aware of the time periods when our systems get stressed, and great DBAs plan for those times. In one large organization I worked for, we knew that the end of quarter and end of year periods were very stressful and busy for many people in the company. As a result, any maintenance or preparation needed to occur at least a month early to ensure systems were at peak performance. In another job, at a power plant, the refueling process that occurred on a semi regular basis was the busiest time of year and we needed to ensure we were aware of when it was coming and double check everything before it was too late to do so.
    Good preparation is one of the keys to avoiding any of a DBA’s worst days. After all, if things go wrong for you at work, it’s unlikely The DBA Team will be available to save the day.
    Steve Jones

  • Continuous Learning

    It was a simultaneously busy, and also relaxing Tuesday for me recently. I attended Allan Hirt’s A to Z of Availability Groups at the PASS Summit. I’ve set up an Availability Groups before, but I was never sure that I completely understood everything happening in my lab, so this was a good chance to add some depth and color to my skills in this area. I met a few people surprised that I was spending time in a pre-con learning. They seemed to expect that I’d know most of what Allan was talking about.

    I know quite a bit about AlwaysOn and the related technologies, but I wouldn’t consider myself anywhere near an expert like Allan. I’ve fumbled through settings, but it’s a complex topic, and more importantly, it’s easy to misunderstand or confuse the subtleties of the technology. I went because a good, solid grounding in the technology, being led about in an organized fashion by an expert, is a good way to expand and solidify your knowledge. I saw other “experts”, MCMs and talented speakers in different pre-cons, each trying to continue to learn more about SQL Server.

    SQL Server is a big platform, one that’s wide in the number of features, and deep in complexity. No one knows everything about SQL Server, and most of the people I know that are extremely talented in areas of the platform, continue to grow their knowledge on a regular basis in a variety of areas.

    It’s the mission of SQLServerCentral to help you do the same thing, with our daily newsletter that brings you educational information about SQL Server. Hopefully you look forward to regularly growing your knowledge, just as I do.

    Steve Jones

    The Voice of the DBA Podcast

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

  • Bucket List Data

    I made a bucket list over a decade ago after hearing an interview with Ted Leonsis, former President of AOL. He had an interesting list, and while mine was more pedestrian, I have managed to knock off quite a few items, though there are more I’d like to get to. Actually, I need to redo my list and re-think my life as it’s changed since I first wrote things down.

    Over the years, I’ve also tracked other sorts of data about my life, things that just intrigued me. I had my running streak (1500+ days), 14ers climbed (4), states visited (38), books read each year (75-100), and more. I’m not quite sure why numbers have a fascination for me, but they do and perhaps that’s why I like working with technology and data.

    I’m sure that many of you share a similar passion for numbers, so I wanted to ask you this week:

    What interesting data points do you track, or have you tracked, about your life?

    It could be something with your family, hobbies, sports, weather, or something else. If there’s something you track and would like to share, let us know. If you have some interesting way of tracking data, or even an application you’ve worked on, I’m sure there are others that would find the data interesting.

    Steve Jones

    The Voice of the DBA Podcast

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