Voice of the DBA

Tag: career

  • Starting to Program

    Hopefully you have more recent resources for programming.

    As DBAs, I think we need to learn to program better for the future. It doesn’t matter whether you are looking to manage clusters with Powershell or add your own SQL CLR routines to your instance, it pays to learn a bit about programming. At some point. I think every DBA will be exposed to some type of code that isn’t written in T-SQL. Whether they’ll be able to do anything with the code, or understand it, is entirely up to the individual.

    As the SQL Server platform has expanded, there have been enhancements and additions to the product. In addition to the core T-SQL, there is now VB.NET and C# in Integration Services, Reporting Services uses RDL and various programming expressions. Analysis Services has XMLA, MDX, maybe more. Powerpivot introduces DAX, and the .NET language runs through all of these subsystems. PowerShell is being pushed as the future administrative language for all Microsoft technologies.

    With so much of the data professional’s job starting to require programming skills, how does one get started? We are working on some stairways to help in some areas, but this Friday I wanted to ask you this question:

    For the DBA or system administrator that wants to learn programming, what do you recommend?

    I’m looking for some links or tutorials, similar to this list for a Python programmer. Do you have a list of programming resources that might help someone learn basic concepts, get started with a particular language, or improve their skills? I’m looking for links that you’ve used, or a friend has used. I’ll look to compile these into a few lists that people can reference to get started on learning more about programming.

    Steve Jones

    The Voice of the DBA Podcasts

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

  • The Next Generation

    Star Trek: The Next Generation
    Will the next generation of IT be as successful as this next generation?

    There have been more and more Women in Technology panels and discussions at SQL Saturdays and other events in the past few years. I think these are a great way to talk about interesting more women in technological careers and helping women deal with the issues if they already work in Information Technology. There are definitely issues here, and it’s good to discuss them, not to the exclusion of other groups, but just to focus on this one area. I think we potentially have issues with other groups in technology as well, and would welcome them to form their own group for discussing the challenges they face.

    However I also think we need more people working in technology of all sizes, shapes, colors, genders, and ages. We hear about a shortage of qualified people in many areas, including databases, and we need to attract more people to this field if they have an interest. But how do we know if they have an interest? Perhaps a more important question comes from this MS Education Blogger: “How do they know they’re not interested?”

    It seems that a lot of the focus from the WIT panels I’ve listened to is ensuring that more women get the chance to experience technology and decide for themselves if it’s an interesting career. It’s about creating an atmosphere where everyone has the chance to experience technology, mathematics, engineering, and other hard sciences without feeling that these careers are not appropriate for them.

    Whether you like your career in technology or not, I’d hope that you’d encourage others to give it a try and experiment. They might find that it’s something they enjoy, and would like to follow as a career. Save the complaints, the downsides to this field for another day, after they’ve had a chance to determine if they even like working with computers.

    Steve Jones

    The Voice of the DBA Podcasts

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

  • Almost an MCSA

    I took four beta tests earlier this year for SQL Server 2012. I had debated writing another book, and I’ve worked on a few of the cert books in the past, so I thought this would be a good chance to look at the tests. Since I had free invites to the beta program, I also thought, what the heck. The worst that can happen is I fail.

    It’s been about two months, and I was waiting for results when someone mentioned that the Prometric site had the results, though they weren’t yet up on the MCP site. I checked, and sure enough I had results for some of my exams. I checked a few days later, and found results for all four of my tests. They were:

    All passed, which was cool. I think certification is what you make of it, and I’ve been looking over lots of SQL Server 2012 stuff for almost a year, so to me it says I have some good knowledge of SQL Server 2012. The tests were a good mix of old and new stuff, and not as focused on the new features, which was good.

    The MCSA track for SQL Server 2012 needs 461, 462 and 463. I skipped 463 in the beta cycle because I’m not much of a DW person, and I was busy. Fitting in 4 exams across two weeks was hard, and took time away from work that I had to make up at night.

    I’m not overly concerned about being certified, but it’s a nice feather to have in your cap. The MCSE for SQL Server 2012 requires the MCSA and 464 and 465, which I have. So one more test and I’d have the MCSE as well.

    My goal now is to start studying for 463, after I get a few more presentations built that I need for work. I hope to get to this test in the fall, or perhaps at the end of the year, depending on my schedule. I haven’t done a lot with the DW side of things, so I’ll be working, and likely writing, about a few more DW topics later this year.

  • The Certification Debate

    MCITPro Logo
    Is certification worth it? I think it can be.

    Today’s editorial was originally published on Aug 7, 2007. It is being re-run as Steve is on holiday.

    Is it worth getting certified? What do you get out of it? I’ve noticed a few debates on the site, and many threads asking about the exams, preparation, and even requirements for certification. Since we’re primarily a learning site, publishing new information for you on a daily basis, the whole certified v real world experience question is interesting to me.

    I read this interview with the CEO of New Horizons and it kind of annoyed me since the guy has an inherent bias towards certifications. Most of the New Horizon’s classes are “official” classes from Microsoft designed and built to move you along the path to certification, not really to do your job.

    And make both Microsoft and the training company money.

    I have to admit that I have a bias here since I used to own part of a training company that delivers custom training in Orlando. However our intention in starting the training company was to help those with a need for SQL Server training that would teach them things needed in the real world, not just things needed to pass some test. There’s a difference and I might not feel quite the same way if Microsoft offered an SSIS certification, an HA certification, a replication certification and more. Heck, I write the QODs, granted sometimes badly , but I know there’s enough stuff to test people on in each of those areas.

    I think the idea of certification is a good one and it has the potential to really help differentiate those with the ability to perform well in a job and those that won’t do as well. However the testing has to be geared towards that and we need ways to differentiate the skills and abilities. Without some type of internships, residencies, and focus on some specialty, attaining some certification doesn’t really help. And I’m not sure that many of us know what we want to do and are willing to invest 5 years in training in one area.

    Most employers now realize that a certification, or at least most certifications, in the IT industry is one small measure of an employee’s skills. It shows a commitment for someone with experience and shows a desire to work, but not necessarily skill, for those new to an area. It’s usually a filter these days, and a low one at that, with no guarantee of employment.

    I still argue that certification exams are a good thing IF you have experience. You can use them to bolster your claim of skills and show that you care something about your profession.

    That’s if you pass.

    Steve Jones