SQL Saturday 442

Today’s SQL Saturday was where it all began years ago: Orlando.

Orlando is always blessed with a plethora of great speakers and a friendly community. I most especially enjoyed Buck Woody’s session on Cortana Analytics this afternoon.

The following is a link to my presentation on Intro To R for those who would like access to the demos and slides:


Microsoft’s Second Shot

Today I completed the certification exam for 70-457 which is the upgrade of MCTS 2008 to MCSA Part 1.

Essentially this exam is 70-461 and 70-462 combined into one. I did exceptionally well on the exam. Admittedly I did not spend too much time studying on it because I was counting on Second Shot to bail me out if things went wrong. The method I used to study was relatively simple and I followed this pattern when I upgraded my MCITP certifications from 2005 to 2008.

Basically what I do is find a list of new features that are going to be covered on the exam. This is published on the Microsoft Learning site. They give you some general direction of what is covered but not the specifics. Reviewing Books Online helps a lot. I would scan through the different pages and read over anything that I was not familiar with. This is surprisingly very effective and you can learn a lot about SQL in general.

Exams often cover the newest popular features of SQL Server and it’s almost guaranteed there are going to be questions on them. I specifically did not have any real world experience with AlwaysOn, so to compensate I went to TechNet Labs and tried a hands-on lab. Microsoft has VMs that you can use for free along with lab notes. This is a great way to get some experience with technology. For something like AlwaysOn, it could take a very long time to set up multiple VMs and a domain controller, installing multiple copies of SQL, etc. In less than 10 minutes, 4 VMs were waiting for me preconfigured with what I needed to work with AlwaysOn. It was really great!

70-458 is next for me but this one will require a lot more preparation time. This covers a lot of the weird SSIS features that none of us use in the real world. Basically 70-458 is a weird mix of 70-463 and some 70-462. Looking at the list of content covered, it looks like there’s a lot of overlap between the two transition exams. I wouldn’t be surprised in the least to see some repeated questions.

Time to Upgrade Certifications and 463 Musings

I’ve been a bit behind with my certifications. The last time I completed one was in 2012. There was a time of my life where I was getting a new certification every year. Strangely enough, this is before I became active in speaking with PASS. I found that it’s difficult to balance our usual daily life along with acquiring certifications, speaking at events, and writing for technical sites.

I have no regrets, but this is merely just a reflection of things.

After a long break, I feel it’s time to get up to date. I attempted a practice exam for 70-463 at the PASS Summit in 2014 and I thought it was absolutely horrible. The exam name is such a huge misnomer. There’s very little of anything about that particular exam that has to do with data warehousing. Most of it seems to be in regards to package and project configuration and deployment. Of course, I do feel these things are valuable for a DBA to understand. I have had a lot of deployments in the past for complex applications that required SSIS packages to do one-time data imports. Understanding the configuration and deployment process is an administrative task more than it is a BI task.

The path for my certification upgrade will consist of the following exams:

  • 70-457 – Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
  • 70-458 – Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
  • 70-459 – Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform

Upon review, I noticed most of the 463 content is in the 70-458 exam. I’ve decided that I do want to upgrade, and I plan to post my learning process.