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 5 months 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 7 months 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 7 months 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 7 months 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 7 months 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 7 months 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 7 months 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 10 months 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
about 10 months ago - No comments
Would you like to get paid to work directly with the SQL community?
Of course you would! Well… Ok maybe not all of you would but Im hoping some of you would!! If this sounds like a dream job for you, Ive got some very exciting news! PASS is growing support for local communities again and we’re looking to hire
about 1 year ago - 2 comments
I was asked by someone to write a mission statement for chapters. I don’t know if this qualifies in the truest definition of a mission statement or not but, I partially stole this from a friend and I hope he doesn’t mind: 2012 is going to be the year of the chapter.
Its been a