Author: way0utwest

  • Guest Appearance in DBA in Space

    Win a trip into space!

    The DBA in Space competition continues today with the third question. This time I get to ask it, a sci-fi film question. No hints, but do a little research and don’t make a mistake. You only get one chance at each question to get through them. New questions are coming every Monday, Wednesday, and Friday, so keep an eye out for the new ones.

    I had fun filming it, and I’ve got a few outtakes below from my efforts. It was surprisingly hard for me to remember two or three lines in between all the other things I normally do and the podcasts I record.

    Enjoy and good luck with the competition

  • Password Help

    Ensure you keep shared passwords safe when people leave.

    Today we have an editorial that was originally published on Oct 9, 2006. 

    Yesterday I wrote about compliance tips and one of the things I mentioned was using encryption and passwords for your backups. It’s a good idea that you should use even with disk backups. You never know when someone might get socially-engineered and hand over one of your .bak files to the wrong folks.

    But using encryption isn’t enough; you need strong key management that changes the passwords on a regular basis to prevent data losses from the passwords getting released over time. I’ve worked in a dozen companies and there are many cases where a password has been used for some shared function, some application, some particular feature, whatever. If this password has remained the same for over a year, it’s been almost common knowledge throughout the company what the password is. I’ve seen business people, executives, even secretaries that knew the password to the point where it was useless.

    Shared passwords will be a fact of life in many cases. Administrative teams grow, help desk people may need access, consultants help out and learn them, and others overhear them. It’s going to happen, so you need to mitigate this risk.

    I used to manage a nightclub and we had similar risks with the alcohol. Since turnover was a fact of life, we had a simple policy. When a manager left, for any reason, all alarm codes were changed. On the third occurrence of a manager leaving, we had all locks re-keyed. It was a simple policy to reduce risk.

    The same thing needs to happen with your backups. Use one or even a few passwords to protect the various database backups. But then change those passwords every month or two and escrow or archive the old ones. You may not be able to prevent losses of the backup files, but by ensuring they are protected and the passwords changed regularly, you may just protect the data.

    And your job.

  • Does It Help

    This editorial was originally published on Oct 12, 2006, published today as Steve is out today at the PASS Summit. 

    Years ago I used to work for an import company and we dealt with all types of distributors and wholesalers for the products we brought in from overseas. One of our divisions dealt with metal products, mostly door hinges, from China and we had workers whose job it was to arrange for inventory from various warehouses to be shipped to fulfill orders.

    At the time, circa 1996, we were pretty high tech. We mostly dealt with faxes and phone orders at the time, phone orders being the easiest because the workers would just enter an order and match it up with inventory from the closest warehouse. Faxes were more challenging, but we had a high tech fax server that caught every fax coming into our company and saved it to an imaging system.

    When I got there, Windows had just been deployed, so workers would pull up an image on the screen, look at it, and then alt-tab to the order entry system and enter some information, alt-tab back to read, alt-tab back, etc. They could also make notations on the image, and would do so with an order number, ship date, etc. and save the image back to our high tech, SQL Server 4.2-based, image server.

    We were looking to rewrite the order entry system when I got there and as we did so, we spent a lot of time with the workers trying to figure out how to speed the process up for them and make their job easier, and get them to process more orders per day.

    Recently a study said that one 30inch monitor would increase productivity, though some people disagreed. The alternative presented was two 19″ inch monitors instead. The type of work you do probably has some impact on which is more productive, but I know that either of these is better than a single 17″ monitor.

    This brings me back to my little tale because I actually tested this a decade ago. At the time most people had 14″ or 15″ monitors on their desks, each of which could cost $300 or so. I proposed moving to two monitors for the workers that needed to see two applications at the same time and got permission to buy an extra 15″ monitor and a fancy $500 video card with two VGA outputs. I also got permission to spend $800 on a single 20″ monitor and we spent a few months swapping the setups among all the workers and even a few others to see what they thought. The result?

    Two monitors hands down.

    As much as I’d like to have a monitor the size of my desk, like on The Island or Minority Report, I know it’s not as productive as multiple monitors. You just spend too much time moving things around, resizing, etc. to make them fit your current task. You might work with Outlook and Query Analyzer now, but then need Excel and Outlook, or Word and Query Analyzer, or Outlook and Word, and all the sizes and locations you set don’t always work.

    You’ll still resize and move applications with multiple monitors, but there’s another key. You can full screen an app on multiple monitors and it will stick to just that screen. So even if you have to drag something from one to the other quickly, you can maximize it and cover everything else up. I use that a lot and it’s helpful.

    If you’ve never tried it, get a $30 video card and borrow another monitor. You won’t go back. I have a 19″ LCD and a 20″ CRT on my desk and love it. Unless I was some type of artist, I’m not sure I’d go to one monitor, even a 42″ wide one.

    So what do you think for the Friday poll? Do information workers, or more importantly, DBAs do better with a large monitor?

  • The Contest That’s Out of the World

    Who wants to win a trip into space?

    If you were in the Exhibition Hall yesterday at the PASS Summit, you were witness to an amazing announcement about a new contest. Red Gate Software is sending a DBA into space, giving you the chance to actually take a trip into space. Someone will get to experience weightlessness and see the planet as only astronauts have before. It’s a view that they always say has changed their lives. How absolutely, freaking, amazing is that?

    As a kid I loved science fiction, dreaming of the chance to have a flying car, or serve on some spaceship like the Enterprise or the Millennium Falcon. As I grew up, it seemed that most people were enamored with the idea of technology advancing to the point where we would fly in space, or more easily travel around the world. It still seems that we’re missing the Jetson’s cars that I expected would be around by 2011. Not only haven’t we duplicated the feats of 2001: A Space Odyssey by sending a ship to Jupiter, we haven’t even sent a manned mission to Mars. Forty years after landing a man on the moon, it seems that space travel has barely advanced.

    However it has advanced, at least to the point where an ordinary human, albeit one with a deep wallet, can book a trip on a ship to travel into space. Red Gate has eliminated the wallet restriction, and all of you have a chance over the next five weeks to enter this contest and have a chance to experience weightlessness.

    I hope you have fun with it and enjoy the quiz that goes along with the DBA in Space short webisodes that we’ve put together. The questions aren’t too hard, but they might require a little research on yur part.  Take your time, however, as you only get one shot to answer them.

    They shows are a little corny, but it was done to bring a smile to your face, and I’m looking forward to hearing what you think.

    Steve Jones


    The Voice of the DBA Podcasts