Voice of the DBA

Category: Editorial

  • Dealing with Supervision

    Micro-managers can be hard to deal with.
    Micro-managers can be hard to deal with. You need a few techniques handy if you want to enjoy your employment.

    I’ve been working at home for a decade, first for my own company and now for Red Gate Software. In that time, I’ve learned to manage myself, motivate myself, find work to do, and meet deadlines, all of which I’ve done without having anyone manage me. Over the last five years I’ve worked at Red Gate, I’d like to think that I was one of the easier people to manage since I work well on my own. I’m not sure if my various managers would agree, since I know that I can be particular about how I work and not necessarily work closely with others, but at least I haven’t required much of their time.

    A short while back I was talking with a friend that was under pressure to complete a deployment that was proceeding poorly and their manager stood next to their desk, watching, commenting, and asking how long each process would take. I’ve had to deal with that situation in the past, and it was  maddening to me. It’s hard enough to focus and work on a task when there are problems with the technology. Having someone that can’t contribute but is in a supervisory role nearby usually makes things worse.

    Ultimately I think micro-management says more about the manager than the employee. There are trust issues or control issues, or perhaps pressure from the manager’s boss. It can be hard to deal with micro-management, but if you plan to continue your employment, you need to find some way to deal with it.

    There is no shortage of ideas. You can search for “dealing with micro-management” and you will get a wide variety of advice. I’ve tried different techniques in the past and some have worked, some haven’t. The best way to handle micro-management seems to vary with the situation, but it’s good to have a few things to try.

    Steve Jones

    The Voice of the DBA Podcasts

    We publish three versions of the podcast each day for you to enjoy.

  • Baselines

    You come into work one day and as you sit down, your phone rings. It’s one of the business groups complaining that the database is running slow. You check the server and find CPU at 80%, 800 pages/sec, disk IOps of 230 and 124 transactions/sec. Is the database the problem?

    Baselines are important to understand how your system is performing.
    Baselines are important to understand how your system is performing.
    Good DBAs know that baselines are essential. If you don’t know what values to expect from your server, it’s often hard to determine if the system is running slower than normal. Normal is something you need to define for each system, preferably in an automated way that updates your baseline over time.

    When building a baseline, however, how do you average out the information?

    That’s the poll this Friday. Let’s assume that you are examining the CPU percentage for a SQL Server and you have data points from every 5 minutes across the last month. What’s the average? Do you take the straight average? Do you break this down to hourly segments and then create further analysis that looks at different business periods?

    It can become problematic very quickly. Many of us have slow and busy periods. Do we want an average that’s perhaps lowered by the slow periods in our workload? Do we want to break out the averages for maintenance periods separately from normal operations? If you are looking to compare today’s values, do you look at yesterday’s for the same time period? Last week? An average of all points across the last week?

    Let us know what methodology you use and if you’d like to describe it in more than a paragraph or two, we’d love to have some articles published here on the site.

    Steve Jones

    The Voice of the DBA Podcasts

    We publish three versions of the podcast each day for you to enjoy.

  • A New Type of Colocation Facility

    Having a data center like this would certainly make it easy to grow your computing capacity quickly.
    Having a data center like this would certainly make it easy to grow your computing capacity quickly.

    Many of us in the technology industry have worked with a data center of some sort. It might be a closet in our employer’s building, a dedicated room with separate power and cooling, or perhaps rented space at a data center facility. In my career, I’ve worked with a variety of data centers over the years, and it’s been interesting to watch them evolve as new knowledge and technology becomes available.

    I remember having a dedicated room so cold that I kept a coat in by cube, even during the 95F summers. These days I have space in a Denver center that has hot and cold aisles. The latter still requires me to carry a coat, but any significant amount of time in the former means I’m down to just a t-shirt.

    As cloud computing grows, capacity becomes important (along with bandwidth and reliability), but the ability to scale your computing capacity up or down may be more important as your customer base grows. Microsoft is taking on this challenge and looking to build”generation 4″ data centers, which may be empty buildings that have power. In some places, these data centers might just be parking lots with power feeds and a fence.

    The cost of construction can be extremely high for new facilities, but imagine a section of a parking garage, or even a secured lot next to your building. A container of servers is dropped off and you connect power, network, and maybe cooling lines (or maybe no cooling). We could potentially even have containers of computing machines and containers of storage. If we ever get cloud computing software inside of companies, this might be the way in which we handle our future data center needs.

    Steve Jones

    The Voice of the DBA Podcasts

    We publish three versions of the podcast each day for you to enjoy.

  • The Knowledge Graph

    Google aims to use a "database of everything" to satisfy search queries.
    Google aims to use a “database of everything” to satisfy search queries.

    Google does some amazing things. In many ways I like the company and their emphasis on data. I’m not sure I’d want to work there or fit into the culture, but the company tackles some problems that could really change many of our daily lives. They experiment with many projects, one of which is the driverless car project. I’m particularly interested in seeing seeing how that might influence the world.

    One of their other projects seems more ambitious. The Knowledge Graph project aims to use a database of everything in the world (according to this piece) and provide even more information to people using the Google search engine. In addition to search results, the idea is that you can get other facts and information about the topic you are searching for.

    Whether it works well or not, it’s certainly an interesting idea. Can we build engines that can divine the context of what we are looking for? If we can do this often enough, then the idea of interactive computers, like the ones on Star Trek, might be closer than we think. Perhaps there’s a way for us to actually mine the data we have about a customer, or a situation, and present results that are more relevant and useful. Perhaps we can build software that can do more than just automate tasks and can help us better analyze information with new ideas or concepts as it interacts with us.

    Steve Jones

    The Voice of the DBA Podcasts

    We publish three versions of the podcast each day for you to enjoy.