Category Archives: 70-463

Good Practice

So if you’re like me and you don’t get to dabble in BI every day, how do  you get anywhere?  I’m trying to move into development again, but there are only so many hours in the day and it’s not all work and study.

In the past, I would begin to dabble in new tech as it came along, dig into it enough to get totally sucked in, and then realize that  yes, I do have a family and I like them.  By the time I made my way back to it, something else would come along.

So how do you focus on your goal of world domination getting to the place that you want to be?  I’m honestly asking people to see what works for them and see who wants to share.

I’ve been just scheduling better.  I think that was the key for me, and something so obvious I don’t understand why I focus on that before.  I bought a little calendar that I carry around that has the week spread across two pages and I focus on when I will do what.  I included time to work on prototypes for BI projects, watching Netflix with my kids, having alone time with the Wifey, and realized that I have a lot of stuff that I do on a regular basis that gets in the way.

So Tuesday night and Thursday AM are when I teach TKD.  So I try to study for my certification exams Tues AM and Thursday night.  I also want to build a prototype uploader for our system at work solely using SSIS and existing stored procs so there is little difference in how something gets into the system.  (Yes, I know there are faster ways of staging it, but I’m just getting things started.)

I think the key is to look at everything you want to accomplish, prioritize it all, and then find the time.  The important part of this whole equation is sticking to the assigned times when you do lay them out and feeling good when you look at all you have accomplished.

Certifiable….?

So why get certified?   Get a new job, enhance my skillset, make me feel productive?

All of that.  I’ve been inspired by SQLFamily, ‘listening’ to what they do and experience on Twitter with all of the events and new technologies that they are into, and it’s made me want more.   Made me think that in order to be marketable, I have to have the skills, especially ones that are up to date.  I’ve had a few interviews, but the issue is that my skillset, specifically BI, is a bit stale.

So, I’m setting the date for my exam at March 1, 2016.  I know that seems like a long time, but with everything I have going on at work and the amount of overtime I’ll be doing, I’d like to stay sane…and married 🙂

First steps:

  • Talk to smart people.  CHECK!  I pinged the SQLFamily and got advice on getting started.  Most of which was websites I am going to put on another page as I go along.
  • Get the training kit, specifically in this case, the one that goes along with the exam I’m taking 70-463.
  • Look at how others approached it.  I was tweeting with Cathrine yesterday and she sent me the link to her page – http://www.cathrinewilhelmsen.net/2015/04/30/preparing-for-and-taking-exam-70-463-implementing-a-data-warehouse-with-microsoft-sql-server-2012/ which was helpful.
  • Start reading, and start practicing.
  • Stop watching NCIS 24-7.  (What a great show)
  • Remember why you’re doing it.

Okay, so I’m going to go do some reading while I save a few pennies to buy the training kit.