SSIS is the devil!

So, I have been studying for my 70-463 exam for almost 8 months now.  I’ve taken the damn test twice, and failed both times.  The score remained about the same.  I’ve tried several supplemental materials to read through along with the Microsoft Training Guide.  What is crazy is, I thought this test was going to be the easier of the 3 when pursuing my MCSA!!  I thought the querying was going to be the death of me, as I still have a hard time writing out queries and actually reading code.

So, this time I am taking a slower approach.  I received a half off voucher when I attended Summit, so I am using that.  Also, Microsoft has their second shot deal going on right now, so I am hopeful to pass within that time frame!!  The biggest issue I have is, I have no business application to use this on!  We do not use SSIS in any shape, or form at my business.  Our ETL processes for our Analytics platform is all done through stored procedures.  So, me getting this certification is just a way of saying “Hey, I can do something you other guys cannot!”.

After I pass this test(and trust me, I will!), I am going to take a month or so off, then pursue my MCSE for the Data Platform of SQL 2012.  I want to be an MVP someday.  I met so many at Summit, and every time that I did…I said to myself…I could do that..I can be an MVP!   So, here I am on my Sunday evening, blogging away after studying a bit.  My Wife is downstairs watching her TV show.  I will probably get about another hour or so in tonight, and then I read it while riding the trolley to and from work.

I made several big advancements in my project at work this week.  SQL Sentry was installed, and I have my alerts configured.  I also got my baselines done.  I am about 75% done with my review of the system(Backup plans, archive times, system resource utilization) and I get to present my findings next week!!  I am hoping my boss likes what he sees and begins having me push this out to the rest of our clients!  It is always enjoyable for me to set these things up and watch how each environment differs from the other.  Even though they are on the same application version of our software, the same build of SQL, the same amount of CPU’s. same amount of RAM, same vendor for both.  Identical servers all the way to the faceplate!  It’s one of the things that makes my job enjoyable…not one day is ever the same!! It is always a new set of challenges each day, and that is what I hope makes me an MVP someday!

Until next week yinz guys!

Jim

Advertisements

One comment

  1. Jeff · November 10, 2015

    Jim,

    Great post. I’m a big fan of Pluralsight to learn various SQL Server technologies but I’m not sure it will be helpful for the type of very specific subject matter you find on a certification test. I would at least give them a look.

    Jeff

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s