Author: way0utwest

  • IT Security

    IT security is a concern for many businesses. At least that’s what a survey at the recent Black Hat conference concluded. Most of the respondents couldn’t be sure that a foreign state-sponsored attack had not occurred in their networks. About half of the people were not confident that their staff could even detect an attacker. That’s a little scary as many of the people felt their systems might come under attack within the next year.

    Digital technology has changed the world in many ways, but one of the most amazing to me is how it has leveled the environment in which all of us can interact. No longer does communication, publication, research, even war require the resources of a country or even a large organization. In the cyber world an individual can make as much impact as a large entity. As with most things, this is a double edged sword, and I’m sure many of us will find that vandalism, as well as malicious attacks on our systems will increase in the future.

    However the threats, or perhaps the consequences, aren’t severe enough yet. Most companies allow shoddy code, vulnerable to SQL Injection, to pervade their internal (and sometimes external) applications. Security training is limited, and review of third party applications is extremely lax. The respondents at Black Hat are making efforts, but those are a self-selective group. Most organizations would never send an employee to Black Hat events or even monitor the trends and information published by groups like SANS.

    I do believe that security will become more and more of an issue. I suspect, however, that until businesses are liable, and decide to purchase insurance, we won’t see much change. Once insurance premiums start to depend on the level of security you implement, I suspect we’ll see the quality of application code increase.

  • The SQL in the City Tour is Almost Here

    Five days. That’s how long I’m in Denver after my last trip before I head back to the airport for the 2013 US SQL in the City tour! Once again the crew from Red Gate is traveling around the country, putting on our one day, free, educational SQL in the City events. We are traveling to three cities in the next two weeks, and I’m looking forward to helping teach you about a variety of SQL Server topics.

    Did I mention the events are free? Completely free to you. We want you to register, but if you’re in one of these cities, and can come, click one of the register links below and I’ll see you there.

    Wed, Fri, Mon, a week long trip for me before I can return to Denver, and hopefully, some time off. I’ll need it, with a variety of talks on Version Control, Backups, and Encryption. I’m also helping with the keynotes, which makes for a busy day, repeated three times, for me. However it’s a lot of fun, and I am looking forward to meeting lots of new SQL Server professionals as I’ve never been to two of these cities.

    You should register today if you can come, it’s free, did I mention that?, and you can tell your boss we’ll teach you how to better work with SQL Server. We’ve divided the content into a mix of administrative and development based topics, so there’s something for everyone.

     

  • The Ratio

    It seems we never have enough staff in many of our technology departments. I have worked in companies where I thought we had too many IT employees, but somehow it seemed my department was always short of resources.

    However one thing that I’ve seen almost universally is a larger number of developers than DBAs in most companies. That makes sense as I think there usually is more code to write than instances to administer, and I’ve usually found companies have to hire a few developers before they see the need for a DBA of any sort, whether production or development focused.  I’ve also found the relative levels of staffing have widely varied.

    This week I’m curious what ratios you’ve seen between these two jobs. I’d like an answer to this question, based on your experience:

    How many developers does a DBA support?

    I’m looking for the real ratios that you’ve experienced. In the places where I’ve developed code, or worked with developers I’ve typically seen about 1:10 DBAs to developers, but that number has varied. I’ve seen 1:5 and 1:20+, but in most cases it’s been near 1:10.

    Let us know this week and get a little market research that might help you convince your boss that you need a helper or two.

    Steve Jones

    Video and Audio versions

    Today’s podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

    Follow Steve Jones on Twitter to find links and database related items and announcements.
    Steve Jones Windows Media Video ( 12.5MB) feed

    MP4 iPod Video ( 15.0MB) feed

    MP3 Audio ( 3.4MB) feed

    Feeds are available at iTunes and Mevio

    To submit an article, rant or editorial,
    log in to the Contribution Center

  • DevConnections Slides and Code

    I had a great time at DevConnections this week, It was a fairly quick trip for me, with lots of other events, but a good time. I presented two sessions and both went well. I had some good questions from the audience and people seemed to enjoy the talks. In order to make it easy to find the slides and code, I’m including them here:

    Encryption in SQL Server

    Searching Office Documents in SQL Server 2012

    If you have any questions, please feel free to contact me.