T-SQL Tuesday #19 Wrapup
Huge Thanks go out to everyone who participated in this months T-SQL Tuesday.
I apologize for the tardiness of this post, its been a busy week with PASS finalizing the Summit Sessions.
As always, there were some awesome posts this month! If youve ever wondered why you need to prepare to recover your databases, or your life for that matter I suggest reading through the huge amount of content below.
The good stuff
Rob Farley (B | T) Writes us a two part post with half being technical about migrations, downtime and high availability and the other half being personal with regards to dealing with and controlling life’s disasters. Hats off to Rob for pouring it all out there. (sometimes it just feels better to write it all down and put it in perspective)
Noel McKinney (B | T) recounts a bad situation where he played the part of message queue during a human disaster where a developers spouse unplugged the telephone in the middle of the night (surprising this didnt cost someone a job)
John Pertell (B | T) tells us about times where he learned lessons the hard way about backups and restores. His stories hit home for me and im sure they will for most other seasoned DBAs. Ive lost more SAN arrays over the years to firmware flashes than I care to think about, so much so that I cringe when the SAN admin calls and even utters the word firmware.
Robert Davis (B | T) writes about backing up system configurations in the case of a complete server failure. Good info in one place here about what you would loose if you lost one of the system databases.
Ricardo Leka (B | T) turns in his post letting us know that its important to have a backup plan but even more important to have a recovery plan! (his post was in portugese so if I’m way off I blame google translate! Thanks for the post Ricardo)
Gail Shaw (B | T) does her best to remind us that disasters arent just huge events in the world but rather most of them involve smaller more isolated events. Id agree with her analysis and I live in the bullseye of hurricane country!
Thomas Rushton (B | T) Shared not one but two posts for this months edition of TSQLTuesda. He reminds us to test our DR plans and recounts a story of what was likely someone updating every record in a database with the same value. Which is a common disaster indeed.
Nick Haslam (B | T) wrote about an experience at a retail organization where a loss of power took out all of the systems. Seems its often the small things that get overlooked (not that power is small but, often taken for granted)
Nancy Hidy Wilson (B | T) who lives just up the road from me in Houston recounts her own personal story from Hurricane Ike. I learned I need a chainsaw and a tractor to recover from a hurricane. Also I was reminded just how far our modern jobs have come in that we can personally experience disaster and move a few hundred miles away and continue to work our day jobs since their systems *should* be designed for uptime!
Thanks again to everyone who participated this month!
Be on the watch for next months host and consider participating if you havent before!
|Print article||This entry was posted by Allen Kinsel on June 20, 2011 at 12:20 pm, and is filed under Ramblings, SQL Server, Syndicated, TSQLTuesday. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site.|
No comments yet.
about 6 months ago - 5 comments
This months TSQL Tuesday #61 is hosted by Wayne Sheffield on Giving Back to the SQL Server Community. An interesting topic given the season and something that is near and dear. Here’s his original post http://blog.waynesheffield.com/wayne/archive/2014/12/t-sql-tuesday-61-giving-back/
It seems like I have a knack for doing things backwards differently and my time giving to the SQL Community
about 1 year ago - No comments
A few weeks ago I wrote that I applied to be on the slate for the PASS Board election. Today the list of candidates has been officially announced and I am happy to say that a group of hardworking SQLFamily members on the NomCom thought highly enough of my application, interview and references that I
about 2 years ago - 2 comments
Welcome New Chapters
This past quarter several new Chapters have joined the PASS community:
Astrakhan .NET & SQL User Group, Russia, led by Yana Kuranova
SQL Professionals of Northwest Nevada, US, led by Christopher Sherrill
Taiwan SQL Server User Group, China, led by Byron Hu and Pohan Chen
Codificando .NET, Sao Paulo, Brazil, led by Erickson Ricci
PASS Beijing, China, led
about 2 years ago - 8 comments
The voters have spoken and I will not be returning to the PASS board as an elected director in 2013. A week ago I wrote a post about campaigning being hard and in it I wrote something that I believe and keep coming back to.
I’ve spent many thousands of hours of my life serving the PASS organization and
about 2 years ago - No comments
Its nearing the end of the road for this years PASS elections cycle and according to the elections timeline, in just a few short hours this years election will be over. Voting will officially end at 12PST tomorrow. To help the inner procrastinator in all of us, heres a link that should tell you when the very last
about 2 years ago - 2 comments
Previously I’ve written about many things I’ve done while on the PASS Board. It’s often easy to take credit as a member of the board for doing things with PASS. The reality though is that there’s always more to it than just deciding to do something, digging in and personally accomplishing some goal. PASS is
about 2 years ago - 4 comments
tl;dr — Disclaimer
I almost didn’t publish this post once I saw what it became as it was too verbose. I couldn’t find a way to shorten it substantially and I didn’t want to break it up. However, I wanted it out there for no other reason than to serve as a crutch to my aging memory.
about 2 years ago - 2 comments
In order to get elected to the PASS Board, Ive twice now been asked to do something that is easily one of the more challenging things I’ve needed to do professionally.
Im a typical DBA type who has never been a fan of self-promotion, Ill happily sit in a corner and give 100% to an effort without looking for any acknowledgement in
about 2 years ago - 3 comments
I’m running for the PASS board of directors again this year
While everyone running for the open Board positions is certainly qualified, I believe I am the best candidate for two primary reasons. First, I have a plan for how I want to evolve the organization. Second, I have a long, well documented history of executing on
about 2 years ago - 1 comment
Welcome New Chapters & Regional Mentors
In June & July we had 2 new chapters join the PASS Community
Appleton, Wisconsin Led By Jes Borland
Northern Colorado Led by Erik Disparti
We also have had a lot of new Chapter Leaders join us in existing Chapters and we look forward to helping them keep their chapters thriving.
I’d also like to