MCSE-Data_Management_and_Analytics

SQL2016 MCSE

Many moons ago, when dial up was still the main way most people connected to the internet and my interest in computers became a profession, I told myself I would attain my MCSE. I told myself lots of things back then. Stuff like I wouldn’t ever be interested in programming. I would never want to be a DBA. I would never own an Apple anything. Seems like most of the stuff I naively said I wouldn’t ever do have come true and the things I said I would do haven’t. Life is full of irony or so I am told.

Seeing as I have taken the time to become a DBA, earned two degrees focused on programming/development, and now own an Apple laptop, desktop, and phone, I should probably work on the list of stuff I said I would do. In this case, earn my MCSE. Only caveat, I’m going to seek the MCSE focused on Data Management and Analytics instead of my MCSE in NT4.0. I shutter just thinking about that old OS.

Database Administration

Does this mean I’m switching specialities? Perhaps. I’d like to think of it more as a knowledge progression into SQL. I don’t think a person can go wrong learning more SQL in general. I’m sure there all kinds of things a person with development skills can add to a DBA position but honestly, how much longer are DBAs going to be employable as DBAs? Oh sure, there will always be DBAs but with the prevalence of cloud computing and automation how many ongoing positions are going to need a traditional DBA?

Honestly though, I have to admit, worrying about backups and uptime isn’t what gets me excited to go to work. I enjoy solving problems, I enjoy learning new stuff and applying what I’ve learned, and I have always enjoyed rooting around in the database. That sounds a hell of a lot more interesting than installing SQL again. PLEASE don’t get the idea I don’t like being a DBA, because I love it. I just seem to enjoy playing with code more and more. Plus, the concept of DevOps has always intrigued me.

Maybe what I’m really doing is focusing my energy more on becoming a Development DBA and less of an Production DBA. That would make sense given the heavy investment I’ve made in learning about software architecture. Certainly according to Brent Ozar’s career planning post, I’m more of a DevOps or Development DBA. At least, that’s where my interests lie, skill wise I have a long way to go in my opinion. This brings me to the MCSE.

IT certifications

Not sure I completely believe this

Certifications

Oh I know, most people in the IT world think they are a waste of time. From the standpoint of seasoned IT professional but I think there are uses. Certainly in my case, it would help to establish my knowledge in SQL development. Is that valuable to employers? I guess that depends on the employer. I do know that some organizations almost require them prior to employment so that they can say they are a Microsoft certified shop. Maybe that’s more for consulting type organizations.

At the moment, this is more of a personal goal. by completing this goal, I would be completing a 20 year old goal before I being distracted with degrees and career transitions. I also want to be able to give myself the choice in regard to future positions. It’s not like I won’t use this acquired knowledge in my current role.

 

Garland MacNeill, MSIT
Student of SQL – both as a DBA and a Developer
I am passionate about learning about databases.. After completing my graduate degree, my focus has been on gaining knowledge and skill as a SQL DBA, as well as a database developer.