Voice of the DBA

Author: way0utwest

  • The Intelligence Cloud

    The Air Force Academy Chapel

    I was thinking to call this the “Military Intelligence Cloud” but no one would believe it was true. Apparently the US Air Force has awarded a contract to build an intelligence platform that will allow different branches of the military and agencies to share data. And, by the way, they will be building a cloud based system.

    I’m not sure why the “cloud” is such a buzzword and why everyone thinks it results in cost savings. Supposedly a “private cloud” based system is being used for cost reasons, and because the public cloud services like Windows Azure and Amazon’s EC2 might not be secure enough.

    However what is a private cloud here? Isn’t it just an outsourced set of systems hosted elsewhere? It seems as though many companies and journalists are selling the cloud as some sort of new technology? Isn’t it just a set of hosted servers that are just virtual machines? Or is it just a set of servers that are standardized somehow in their configuration and capabilities?

    It seems that all the press, and all the commercials from Microsoft might be working, and the collective managerial sheep herd is flocking to the cloud as some amazing new change in the way their systems will work. If that’s the case, I’m not sure this new cloud service will be any more intelligent a move than and other outsourcing decision.

    I think there is promise in a more abstract, more ephemeral type of platform in the cloud, but it seems as thought we might be a long way from actually implementing something like that.

    Steve Jones

    The Voice of the DBA Podcasts

  • Temporary Indexes

    Temporary placeholders can be valuable

    Recently I was studying for the MCM exam and one of the things that came up in my research was the idea of temporary indexes. I had never used them before and was intrigued by the idea. I have dropped indexes before a large load and then recreated them, but these are indexes I planned to keep on the table indefinitely.

    There are always processes that you run periodically on some schedule. These might be end of month, or end of year processes where you run a series of reports or queries that aren’t necessarily run at other times in your business cycle.

    Since this was a new concept for me, I wanted to ask and see how many others might actually be using this. Maybe you’ll get an idea for how to speed up some of the periodic, but very important, processes you run. For this Friday:

    Do you use temporary indexes?

    By temporary, I mean indexes that you create for a process and then discard at the end of a process. These could be indexes that you use to supplement some type of data load, perhaps indexes used in staging tables. Or they could be indexes that are added to some OLTP tables for the processing of certain reports in a short period of time.

    However you might implement them, let us know how you use them, and how they have improved performance for you.

    Steve Jones

    The Voice of the DBA Podcasts

  • When To Hire a DBA

    How busy should someone be before you hire a DBA?

    One of the things that I often see on SQLServerCentral’s forumsis a developer struggling with an administration issue or a complex query. It’s natural and even expected since many developers are not as familiar with SQL Server as they are with their development platform. It’s great to see them trying to get help and work through issues and there are many generous volunteers that give their time and knowledge to help.

    Recently I found a post where a developer was struggling with a variety of problems: design, backups, and more. It was obvious this person was overwhelmed and when someone suggested hiring a consultant, this person noted their boss didn’t want a DBA consultant, and wasn’t willing to hire a DBA. Management didn’t feel like there was enough work to justify a full-time employee.

    That’s an issue that I think many companies face. When do they hire a DBA and when is it beneficial for them? I’ve had this conversation before with employers, and while I’ve seen small companies benefit from having me as a DBA, I also know that I’ve contributed in ways other than just with helping with the database platform. I have helped administer systems, develop applications and more.

    I think part of this is the fault of the database professional, who has a stereotype of being difficult, stubborn, and resistant to change. It’s also hard for many database professionals to quantify exactly what they do and show explicit value for their services. They don’t build new features into applications, often don’t interact with customers, and regularly answer question with “it depends.”

    The ROI for a DBA is something that can be hard to explain to management, but it’s something that I think needs attention from all SQL Server professionals. If we can better explain our jobs, develop standard tasks and benefits that DBAs show, we can help ensure that more companies see the benefits and value from employing a DBA. If you have any ideas, please add them to the discussion for this editorial.

    There’s also a nice opportunity here for hybrid DBAs, the kind that come to conferences like SQL Server Connections. Doing a little developer alongside your DBA work might get you some jobs in smaller, more flexible, and more fun companies.

    Steve Jones

    The Voice of the DBA Podcasts

  • What’s Mentoring?

    We have just kicked off The Mentoring Experiment after talking about it for months. There has been a lot of interest and quite a few applications submitted. We’ve even had a lot of people ask if we needed help mentoring people, which is great. If you’re interested, you still have a couple days to submit an application.

    The past week or two, after getting started, I’ve been surprised just how often I’ve seen or heard the word “mentoring” used in many ways. I’ve seen it talked about on TV, on the radio, and in various Internet spots. It’s almost like our experiment kicked off a slew of other projects from other people. That’s not the case, and my guess is I’m a little more aware of how often mentoring is used by various people.

    Definition

    Webster’s dictionary says that a mentor servers as a guide or advisor. Wikipedia sees a mentor as a counselor, friend, or teacher that helps to advise a protégé or serve as an example.

    Those tend to fit my definition which is someone that is providing some counsel, advice, and perspective to another in a way that has the best interests of the mentee or protégé at heart. It’s private, at least to the extent that the mentee wants it private, and there isn’t any exchange of money or quid pro quo for the time. It’s a volunteer effort on the part of the mentor.

    Mentoring is part setting that example in your own career, which allows the mentor to help the mentee learn from experience. This experience and wisdom should establish the respect that is needed for the mentee to take a mentor’s advice under advisement. Mentoring is also acting as a sounding board, almost as a psychiatrist does, in listening to the mentee, asking questions, and helping to give an outside perspective on a situation or decision. 

    A mentor should act as a guide, helping and leading, but not setting the direction or goals, but helping the mentee to find their own way to a better career.