Home » People and Opinions »Random helpfulness »sqlserverpedia-syndication »SSC » Currently Reading:

A Short Treatise on Studying (#mcmstudy)

So I’m studying a lot these days, and I find myself evaluating and reconsidering the theories of “study” that I’ve been picking up all the way back since grade school. Here is what seems to work best for me, whether I’m learning something new, or reviewing something I “know”:

  1. Develop/revise a general game plan. I get this from the exam I’m going for, of course, or whatever it is I decided I need to know.
  2. Read about a topic from a good source (I’m back in love with the SQL Server 2008 Bible this month). I may also look up a tutorial or session from one of the myriad sources online*. While I do this, I take notes.
  3. Mess around with the topic – in other words, go do it, go break it, fix it, do it again. (Usually this is freestyle, sometimes it’s with the aid of a Books Online tutorial.) Make more notes.
  4. Take a practice exam that includes the topic.
  5. Take a hard look at what I got wrong, and why. Make more notes.
  6. Repeat from (1).

And, drill: As I go along, I gather scripts for tasks that I need repetition on. Say I’m practicing TDE implementation? Get the script together to make it happen (and to tear it down again), and run through a few repetitive drills every day.

Finally, I talk things through. If I’m not sure I fully grasp a topic, I’ll explain it to my monitor (or my dog, or as a last resort, Sean :)…because you don’t really understand a thing until you teach it. Or in this case, say it out loud. Saying it out loud points out the places where you’re really not sure how it works, or what you need, or if there are exceptions.

It’s entirely plausible that this process wouldn’t work as well for you, or that you’d need to do more of one than the other (say, more reading, or more doing). So tell me: What works for you, if you’re bent on learning something new in IT?

Happy days,
Jen McCown

*Myriad sources for tutorials online include:

Comment on this Article:

Release Date: Minion by MidnightDBA

Just 2 days 23 hours 38 minutes 9 seconds until we release Minion Redindex: index maintenance done right!

MidnightSQL Consulting

Need help? Got an emergency? Write us at Support@MidnightDBA.com!

We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.

For more information about MidnightSQL consulting, email us or check out www.MidnightSQL.com. Happy days!

Where are We?

November 3-7: PASS Summit, Seattle, WA

PASS Summit: Jen is presenting How to Interview a DBA: A Panel Debate on Thursday 11/6 1:30pm, room 401 (along with Adam Machanic, Sean McCown, Bob Pusateri, and Michelle Ufford).

PASS Summit: Sean is presenting Performance Tuning Your Backups on Wednesday 11/5 3:00pm, room 602-604.

December 11: Presenting "Powershell Cmdlets.." at Alaska SQL Server User Group

January 30: "Become an Enterprise DBA" precon at Austin SQL Saturday

Blog Posts by Category


How to Eat Pop-tarts
Watch DBAs@Midnight live on Fridays,m 11pm Central time

The best database career advice you’ve never heard!


The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!

Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)

Become a DBA. Become a BETTER DBA. Use the Roadmap.

Visit www.DBARoadmap.com for info, forums, and more!

Add to Cart View Cart

Cunningham’s Law

"The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."
Relevant: http://xkcd.com/386/