Author Archives:

T-SQL Tuesday #42 – The Long and Winding Road

T-SQL Tuesday

This month’s T-SQL Tuesday blog meme is brought to us by Wendy Pastrick (blog|twitter) and the subject is “The Long and Winding Road.

When I saw this month’s subject, I lunged forward and began to write dropping everything else that I was working on.  Why?  Any chance to incorporate SQL Server with the Beatles is worth the time and effort.  After all, they are the greatest band of all time and if you disagree then you are just going to have to live with being wrong, right?

Many moons ago, well it was actually 1997, I had written some applications in Visual Basic: yes, the old and horribly slow one, you know the one.  But then I discovered Delphi (Object Pascal for the kiddies) and wrote amazing some amazing applications.  I even wrote a few games back then just to prove to myself that I could, they were not horribly great but I felt accomplished and I often wonder where those floppies are so that I could play them again.   Programming was my passion and it felt so amazing to create something from scratch, my own creation, my own Frankenstein: “It’s Alive!”

From there a company noticed some of my freeware applications and offered to move me to Virginia and teach me to write business applications in Progress 4GL for Unix and Windows.  Wait, you are going to train me, mentor me, and pay me double my current salary.  I’m in.  Progress was an amazing product with a very well written SQL-compliant RDBMS that rivaled Sybase, Informix and Oracle only without the marketing hype.  Their claim back then was that they were in over 60% of the Fortune 500.  The problem was that with their Value Added Reseller structure, many vendors would repackage their database as their own (as was allowed if they paid enough for the rights to distribute the product), so many of those companies had no idea that their database was “Powered by Progress.”

My years with the product were amazing learning to write code that would run in Unix, compile and run in Windows and then eventually would become used inside of tags of HTML to deliver data to the web was ground breaking at the time.  I was sure that this was the future, so much so that I became a consultant for the company traveling the globe for two years helping clients with installation, troubleshooting and training.  I drank the kool-aid.  I was pretty sure that with a little marketing they would sink the Oracle juggernaut.

At one company I even administered a SQL Server 6.5 and 7.0 boxes because they had vendor software that required it and I was the database guy for Progress.  I remember thinking how SQL Server was so miniscule compared to Progress.  I remember thinking that they will never make it in this sector.  Well I was wrong about the Xbox, too.

Enter early 2004, I had just successfully completed a fulfilling project and was looking for my next contract opportunity.  The well was dry, there were no opportunities for Progress.  I had a home and a small children and my family did not want to move.  The road had ended that day.  I had to take a job as a systems administrator to make ends meet.  The dream was over.  In the words of the Beatles….

The wild and windy night, that the rain washed away

Has left a pool of tears crying for the day

Why leave me standing here? Let me know the way

Then in 2008, I started a position that was part programmer and part SQL Server DBA.  Prior to this, I contemplated going back to school and leaving the IT field.  But as the Beatles would say…

And still they lead me back to the long winding road

You left me standing here a long, long time ago

Don’t leave me waiting here lead me to your door

The dream had come full circle, I found my new passion:  SQL Server.  It really was my old passion in disguise: DATA!  Hopefully this technology will be the one for many years to come, what do you think?

Auditing Revisited, Makes No Sense To Me

Back in January, I did a series on simple auditing which walked through setting up an audit and creating a simple SSRS report.  I actually used the report and the query that I demonstrated for a couple of servers in my stack that require auditing.  The basis of this revolves around the following line of code:

SELECT * FROM fn_get_audit_file (‘g:\auditing\*’, DEFAULT, DEFAULT)

This line of code runs great for my login and I never gave it much thought because I am running it from a sysadmin account.  When asked for users to be able to run this report that is when things are getting sticky.  I cannot fathom why a simple query for log data cannot be attributed to a read-only account.  In order for you to run this select statement you either need a sysadmin level account or the CONTROL SERVER permission which pretty much gives you the keys to the kingdom.  Why would they do that?

I am sure there is a great technical reason, but why not allow it to filter down to read-only access to simply view the data?  With those permissions whoever is in charge of running the audit can manipulate the data however they see fit.  That makes no sense to me but then again who am I in the grand scheme of things?  Shortly I will post a few different scenarios in how to solve this problem.  Enjoy!

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!

Looking for Humorous Backup/Recovery Stories

While preparing my newest presentation, I thought the best way to teach backup and recovery is through humorous stories revolving around horrific backup and/or recovery incidents.  I have a couple, but I thought I would open this up to the SQL community and see if there were some really outrageous ones out there.  I can cite you (or not if you choose to remain anonymous) in my presentation and tell your story to help teach the world about SQL Server Backup and Recovery.   You can simply e-mail me at Ed at SQLGator.com or comment on this post.

Thanks for your help.

Jacksonville SQL Saturday

In less than a month from today, I am honored to be presenting a new session called “Backup Strategies are for Losers!” at SQL Saturday #215 in Jacksonville, Florida.  This is a new session and the first session created after attending Buck Woody’s (B|T) workshop on how to be a better speaker.  If you came out and saw some of my earlier sessions over the last year, then please come back out and let me know what you think.

If you haven’t registered yet, what are you waiting for it is free training!  See you there!

sqlsat215_speaking

A Different Perspective

Every day at lunch I walk around the perimeter of the work compound in the fresh sunshine.  I have done this for over three months now.  Today, however, I went in the reverse direction and everything appeared different.  Obviously, it was the same compound with all of the same buildings and the same roads.  But when you approach it from a different prospective, your view is altered.  Today I saw things from a different light and it appeared as a new shining vista, fresh and renewed.

Work is the same dynamic, some times we need simply to walk in a different direction to get a new perspective.  Sit with your developers and see how they see the data.  Find out what problems they are having from their point of view.  Look at your environment from a different perspective and maybe you will find a new shining vista too.  Enjoy!

Follow

Get every new post delivered to your Inbox.

Join 974 other followers