A Hiccup When Upgrading SQL Server 2008 R2 to SQL Server 2012

I was tasked with doing some upgrades for a client in their Configuration Manager 2012 environment recently.  They wanted the SQL database on the back end upgraded to something more recent so SQL Server 2012 it is.  So we confirmed we met all of the software prerequisites and began the upgrade.  Setup Support Rules were happy.

Setup Support Rules

Look at all those green check marks!

All of the features were auto-populated showing that they were already installed and supported.  We confirmed we had adequate disk space, more little green check marks.

Upgrade Rules

Many more little green check marks.

The Upgrade Rules were checked and many more little green check marks were displayed and now we’re ready to upgrade.

Ready to Upgrade

Ready, Set, Go!

The process begins, everything looks happy, the upgrade appears to be proceeding as planned and then this happened.

Complete with Failures

Ouch, so much red it makes my eyes hurt.

So we reviewed the logs, double-checked the prerequisites yet again, searched and researched to see if we could find out what was missing.  No luck looking at entries in the log files so I did a quick search using “an error occurred for a dependency of the feature” and came across this which pointed to an already installed SQL Server 2012 component, the Microsoft SQL Server 2012 Native Client.  It may have been installed as part of the SQL Server 2012 Upgrade Advisor which seems odd but I was a bit surprised that the rule checks didn’t flag the item when all the little green checks came up.  All’s well that ends well.  We removed the native client, reran the installation process and SQL Server 2008 R2 was successfully upgraded to SQL Server 2012.

IPViking Live

Take a look at this gem.  They’ve distributed some 8 million sensors out and about in the world that mimic typical devices like ATM’s and POS devices that are regularly under attack by the bad people.  They then take the feedback and present a visual representation.  Very cool!

Exam Time! Crack the Books

It’s that time again when we gather with loved ones and prepare to sit Microsoft exams to gain and update our certifications.  For me it’s upgrade time, I have 70-417 on the menu for this year while others on my team are looking at the whole slate of Windows Server 2012 R2 exams.

We’re using an assortment of resources to get this done.  I prefer Microsoft Press study guides, I always have, and recommend them.  Another excellent source for study materials is the voluminous Microsoft Virtual Academy which provides tonnes of material to learn and review all of the stuff you need to bust a move on those exams.  Do a search with your favourite internet search engine using the exam code of your choice to see who out there has written the exam and get some input on how they found the exam.

There are all sorts of lists of suggestions on how to approach actually writing the exams.  This is how I like to approach them.  I’ve written more than a few and the method to my madness has changed over the years but in a nutshell I like to follow a couple of rules:

  • Book your exam.  That seems like the obvious thing to do but I have known a lot of people who want to write an exam, express interest in writing an exam, but never get around to it.  So, decide which one you want to do, give yourself what you think you’ll need to for prep time and book it.  If you’re not ready when the date approaches you can always reschedule or just go ahead and confront the beast.  Microsoft is going to do you a solid this spring by offering you a Second Shot so if you miss it on the first go you can come around and give it another try.
  • Prepare.  Take advantage of the many free resources out there to allow you to set up a lab and test and play.  Most computers these days run nothing less than 8GB of RAM and I’ll hazard a guess that most of us have a gaming machine that has more.  Load up your favourite hypervisor and practice installing and configuring and learning.  I like to pair this with reading then rereading the study guides for the exam I’ve chosen to write.  I find I almost always come across something new, there’s a lot to learn.
  • Adding to the “book it” note above I prefer to write first thing in the morning.  I find that at some point in the study process your brain is full and you know you’re ready to go.  I’ll put the books down the night before the exam and relax.  The morning of the exam I like to get up early, have my usual breakfast and make my way to the exam center with time to spare.  Being first allows one to get in and get it done without the distractions or delays of a later appointment and doing it first thing in the morning means you’re focused on the exam.

What do you think?  What would you add or remove from the tidbits above?  I’ve always found the Microsoft exams challenging which makes that feeling of successfully completely the exam just that much more satisfying.  Good luck exam takers!

It’s a Wrap, 2014!

Christmas is upon us and the year is almost a wrap so its time for the recap.  I would say 2014 was quite good with a couple of bumps along the way.  Elke and I are in stable jobs and enjoying them for the most part. Colin has ramped up his school work and is doing an exceptional job.  His artistic skills are better than they’ve ever been.  My odometer clicked over 50 in February.  Ugh, I feel so old….not really.  : )


In May Elke and I jetted off to Iceland for a week.  What Canadian goes to a cold place having just survived the winter in Canada?!  It was fantastic!  Beautiful country, loads of great food, lots of photographs to bring home, along with a few lopapaysa to keep us warm this winter.  The people are super friendly so if you get the chance to see Iceland I say to you GO!


The summer was reasonably good, for Ottawa, not too much cold rainy, a fair amount of hot humid.  I topped last years distance getting just over 1300km on the cycle.  I should have done more but what can one do?  Next year, more!


Colin was off to Germany in July for a visit with family, it was short but he enjoys his travels.

In August Elke and I took a short trip to Quebec City on the train.  Can you beat train travel?  I don’t think so.  It was my first visit and I can certainly say it is a beautiful city.  Such friendly people!  We walked a lot, so many hills!


At the end of October Elke and I flew off to Barcelona so I could attend TechEd Europe 2014.  If you’ve never attended a Microsoft conference you really must.  New motivation to learn PowerShell.  Next year it’s MS Ignite in Chicago.  Worth the trip.  I do work for a great company don’t I?! : )


So for all of you out there Merry Christmas, enjoy time with your families and friends, eat some turkey, see you in 2015!

Time to Stretch the Brain – PowerShell!

One of the consistent messages heard over the past few years, maybe more, regarding system administration and how things are done in the Microsoft world is that one must learn PowerShell.  It’s how things are done and will be done into the future.  I’ve never felt it to be that important or that urgent until recently.  I find myself in a rut, without purpose.  These are not good things.  To want to go to work every day one must have purpose or one develops as dislike for the job and that’s just not good.  How will I deal with this?  PowerShell.

I bought a copy of Learn Windows PowerShell in a Month of Lunches written by a guy named Don Jones.  I carried that book around with me for more than a month of lunches and only opened it a couple of times.  Then the second edition came out.  Ugh.  Have I had that book for that long? Apparently so.  Time to learn some PowerShell.  As an extra motivator I work with a Microsoft PowerShell MVP so maybe I can put a dent in this book.

TechNet is Done, So Long and Thanks for All the Fish

Today is the last day of my 90 day extension of my TechNet subscription with Microsoft.  It was a great service and offered a lot of value for anyone with their own lab setup at home.  Now that it’s done we still have access to a whole load of excellent resources.  Virtual instructor-led courses can be had at the Microsoft Virtual Academy.  You can get your hands on downloads to install and configure and test through the TechNet Evaluation Center.  Give a product a test drive by using TechNet Virtual Labs.  All good resources.  Not quite the same as the TechNet subs but then if you have the money and really need the resources you can always check out a MSDN subscription.