TSQL TuesdayThis month’s TSQL Tuesday is hosted by Robert Davis (aka SQLSoldier) and his topic of choice is excellent. In any IT field it is incredibly important to keep up with the latest technology and to continually improve ourselves. For a DBA I believe it is even more important that we constantly strive to improve ourselves. Part of that continued education process is knowing what works best for you and the others involved.

How do I learn?

When attempting to learn a new skill I think the first question should be “How do I learn best?” For me it is absolutely a hands on approach. I can read something and takeaway good information but if I want to really learn it, remember it, and understand how it applies, I need some hands on time with it. For this reason I maintain a quad-core, 8GB server at home that runs Hyper-V.  I then have about 10 different guests running various combinations of OS, SQL, clustering, etc so I can play to my heart’s content. When I’m done with that topic I can hit “reset” on the guest if I need to and it is as if I had never made those changes.

The second thing I do is read everything I can get my hands on. I get a nice allowance for books at work and I put it to good use. I try to read at least one sql related book each month. I also absolutely love Google Reader and use it to follow a lot of blogs. I just looked and I am currently following 62 blogs. Are they all sql? No but most are. As I find new blogs that I find interesting I add them to Reader. Occassionally I will go back and look over the subscriptions. If there is something that is no longer being posted to or I no longer find interesting I remove it.

Finally I use the Microsoft Certification tests to learn. I know you ware probably saying “What?”, but I will tell you why. As I take the new tests that come out I pay careful attention to the topics covered. To me it is important to see what technologies Microsoft considers to be important or perhaps are pushing. For example when I took the latest MCITP: Database Developer test it pushed me to learn about XML. I only know of maybe a couple of customers using it, but it was interesting to learn and put away in my mental toolbox.

How do I teach?

For me the number one question I have to ask myself is what is the makeup of the audience? Am I speaking to fellow DBAs, developers, business stakeholders, etc. From there I can then determine what the appropriate content is and what needs to be covered. If it is a group of DBAs then I shouldn’t have to explain the basics of indexes, we can jump right into the meat and potatoes and I can let the acronyms fly. However if the audience is not as SQL savvy I need to carefully consider the underlying content and determine what needs to be covered first so that the people have a firm grasp of the basics before we jump into anything bigger.

, , ,

5 comments untill now

  1. Great read Jeremy. Your last point about your audience, so true. I found that you can only go as fast as your slowest student.

  2. Jeremy Carter @ 2010-07-13 20:08


    Thank you for the kind feedback. One trick I use to gauge the technical content of my slides/presentations is to run them by my wife. While she is very business savy, she is not geeky, so this helps me judge what level the content is and whether I need to go back and fill in any holes.


  3. Nice to hear someone say something nice about the certifications for a change!!

  4. Jeremy Carter @ 2010-07-17 09:10


    Certification always seems to be such a polarizing subject. I think it needs to be said that Microsoft is doing a much better job these days. While I don’t think they will ever be the end all beat all, I think there are good things that can be taken away from the experience. Honestly I had not really planned on doing them but work required the DBA cert. Then I started looking at the MCM and so I went ahead and knocked out the dev cert. I ended up being pleasantly surprised by the improvements in the exams. While we are on the subject, I really appreciate your and Brent’s accounts of the MCM program as it gave me much more ammo to use. It sounds like I have my manager convinced of the MCM, now it is just a matter of deciding where to pull the funds…

  5. [...] Carter: TSQL Tuesday – How I learn and how I teach            …talked about how he teaches and how he [...]