Monthly Archives: April 2013

Online Restores

I was doing some mentoring today with online restores, so I thought I would share it with my blog readers.  The most important thing about online restores is that it is only supported in SQL Server 2005 and later versions.  In addition, for the bulk-logged recovery model the following conditions must be met in order to complete an online restore:

  1. All of the log backups must have been taken and completed before you start the online restore.
  2. If you have bulk changes in the database, the files must be online.
  3. All of your bulk changes must be backed up before starting the online restore process.

In addition, I have seen it recommended that you switch your bulk-logged recovery model to the full model before starting the online process and then switching it back afterward for smoother recovery.  Enjoy!

T-SQL Tuesday #41 – Why I Love Presenting

T-SQL Tuesday

This month’s T-SQL Tuesday blog meme is brought to us by Bob Pusateri (blog|twitter) and the subject is “how did you come to love presenting?

For me I am not sure that I am at that point.  I love being a presenter, I love going to the speaker dinners for SQL Saturday events, I love meeting other speakers and talking about presenting, but in all honesty I am not sure that I am in love with presenting.  But I am getting there.  Presenting still terrifies the hell out of me, but it is a fear that I set out to conquer last year as a goal in my personal development plan.

For a long time, if  an activity involved a public speaking component I avoided it like the plague.  Seriously.  I am not kidding here.  I coached Dixie Youth baseball and Pop Warner football and every year I had to give a first practice speech.  I would spend a couple of sleepless nights and I would vomit several times before muttering something from my note cards and then quickly move on to begin the practice.  The last few years I stopped doing it all together and went around to the parents individually and this worked much better for me.  Crisis averted.  Problem put back on the shelf for a later date.

After several SQL Saturdays, I started to think that I could do this again.  Some time ago, I was a consultant that also provided week-long training courses in addition to programming and DBA work in Progress 4GL RDBMS, but all of the material that I presented was created by a team (similar to a Microsoft training course) of professionals.  Whenever I got nervous in those courses, I could always go back into the material as it had notes on the slides.  It was fool-proof, and after doing them over and over I was a pro at it.  But after not doing this for twelve years, the fear took over again.

After presenting a lightning talk in Pensacola, a couple of user group meetings and a few SQL Saturdays, the fight or flight reflex has lessened and the vomiting is non-existent.  I can do this, I am doing this, and I will conquer this.  I can proudly say that I brushed the fear back and now think that I am getting better at this.  I am starting to love presenting, it has a foothold in the depth of my being.  What about you?

Day Three: the Arch and Saint Louis Zoo

On day two of our adventure, we spent the day reconnecting with my wife’s uncles and cousins and their respective families which was the original purpose of the trip. I had a great time meeting all of these people, what a great family.

However, on day three we set out for the tourist destinations of my youth: the Gateway Arch and the Saint Louis Zoo.  The Gateway Arch is now a national park and it is a beautiful and spacious park at the base of the Mississippi River with the historic courthouse in the background as shown in the gallery below.  Also at the base of the Arch is the Museum of Westward Expansion which seemed much grander when I was a kid but did have some animatronic characters for me to enjoy.

Later in the day we also visited the Saint Louis Zoo which was free (with a $15 parking fee, still not sure how that’s free).  The zoo seemed bigger than when I was a kid which is always a plus.  What a great day of adventuring.  Enjoy!

Day One: Atlanta and Ruby Falls

20130407-103717.jpg

Whitehaven

Day one of our anniversary vacation and we arrived in our favorite stay-over hot spot, HOTlanta! From Atlanta, we went onto Lookout Mountain Ruby Falls in Chattanooga, Tennessee. I haven’t been there since I was a kid, and the falls are breathtaking in the belly of the mountain. The hike down is gorgeous and our tour guide was hilarious. It was a great experience for the entire group.  We would recommend this stop to everyone.

From there we moved on to Saint Louis, our original destination, but not before we stopped at this excellent rest area / welcome center on the border of Kentucky and Illinois. This building, called Whitehaven, was built in the 1860s in Paducah.  Stay with us for the rest of the week as we explore the Gateway to the West.

20130407-103904.jpg

Crossing the Mighty Mississip at night is beautiful!

The Falls

The Falls

The Falls

Ruby Falls

Weird Problem with SSAS Not Starting

After building a new cluster to replace a 2005 cluster here in the office, I discovered Analysis Services would not start.  Usually I do not put Analysis Services on the same box however one of our vendors requires SSRS, SSAS, and the Database Engine to be on the same instance.  Frustrating, I know.

When I installed the cluster, everything was operational.  However after I applied service pack two to the 2008 R2 Enterprise nodes, Analysis Services would not start.  I didn’t notice the first time that it was after the service pack was applied until I removed everything and started over fresh.

The logs were not much help and I could not find much on the internet until I eventually found a friend who suggested that the service running SSAS needed to be in the local administrators group.  Problem solved.  Now my lesson learned is here for you as well.  Enjoy!