Expect the Unexpected with DiRT

Steve‘s article reminded me about the first time I gave my Disaster Documents presentation at a SQL Saturday.

At the end of my presentation, one attendee started an argument with me. He kept saying that paper was dead, everything was online, and there was no reason to keep hardcopy documents. I argued, what if you can’t get to your online documentation?

Not surprisingly, he gave me a poor evaluation.

The bottom line is this: even documentation needs a backup. Other than, say, getting lost in a fire, paper documents can’t break. At a minimum, have hardcopy documents that instruct how to get minimal services back up and running, and back up other recovery documentation so you can recover it later.

Voice of the DBA

Disaster recovery is one of the core tasks that many DBAs think about on a regular basis. Ensuring that we can get our data back online, available, accessible, and intact is important. More than a few DBAs that haven’t been able to recover systems, find themselves seeking new employment.

That’s not to say that most DBAs perform perfectly under pressure. Plenty make mistakes, and there may be times when they can’t recover all data. There does seem to be a correlation between how often DBAs practice recovery skills and how well they perform in an actual emergency. I know that at a few companies, we scheduled regular disaster tests, though often with simulated recovery of a systems that didn’t expect to actually take over a workload. Arguably not a good test, but better than nothing.

Google takes things a step further. They have annual, company wide, multi-day DiRT (Disaster Recovery…

View original post 359 more words

Ransomware and DevOps

Another post by Steve Jones that I think is really important…

Voice of the DBA

Ransomware.

A scary topic and one attack that is apparently more common than I suspected. Before you go further, if you haven’t restored a database backup in the last month, stop and go verify your DR plan works. That’s one of the overconfident issues facing lots of government and businesses. While this might not help your entire organization, at least you’ll have some confidence in your process and that you can recover a database.

This is a great article from Ars Technica and worth reading: A take of two cities: Why ransomware will just get worse. I’d recommend you read it and think about a few things. First, do you have insurance because things (or substitute your own word here) happen? Second, have you really tested a DR plan for some sort of software issue like this? You might think about a way to restore systems in an air-gapped…

View original post 356 more words

July 20 — SQL Saturday, Albany, NY

On Saturday, July 20 (one week from tomorrow), the Capital Area SQL Server User Group (CASSUG) will host SQL Saturday for the sixth time in Albany, NY!

For those of you who are not regular readers of my ‘blog, SQL Saturday is a daylong conference centered mostly (but not entirely) around data topics related to SQL Server. It’s also a great networking event, and an opportunity to hook up with a number of data professionals! Check out the schedule to see what sessions interest you!

And yes, I am presenting, too! I will do a brand-new presentation about ‘blogging, as well as a lightning talk about business cards! I always look forward to doing presentations in my own backyard!

Additionally, there are three pre-con sessions on Friday, July 19. Unlike SQL Saturday, these sessions are not free, but they provide quality daylong training for specific topics at a decent price. Information about these pre-cons can also be found on the web site!

For more information and to register for the event, visit our website! Upstate New York is a great place to visit during the summertime! Hope to see you there!

SQL Saturday Virginia Beach — the debrief

My wife and I arrived home in Troy, NY around 10 pm last night after driving all day from Norfolk, VA. Despite the lengthy drive home from Virginia, it was, nevertheless, a fun and fruitful trip!

First, Greg Moore, who also attended SQL Saturday #839, summed up his assessment of the event in his article here. Go ahead and read his article. I don’t think I could’ve summed it up much better than he did.

As is the case with most SQL Saturday events, I had a chance to network and connect with a number of people. Most notably, I had the opportunity to meet Andy Leonard, who has written a number of books, writes frequently for SQLServerCentral, and is considered a rock star among SQL circles. I told him about my writing exploits, and he hooked me up with the editor at Apress publishing. Once I’ve had a chance to get everything settled and back into the normal routine after nearly a week away, I’ll have a conversation with him. Could a book be in my future? I’ve always dreamed about having my name on a book. We’ll see!

My own presentation went well, although I still think it could be better. This was the first time I’d given this presentation since I revamped my slides. I’ll have to see what feedback I received and use it to make the presentation even better.

I met a fellow fraternity brother who recognized the letters on the hat I was wearing!

I also had another textbook example about how your clothing can initiate a networking opportunity! On Friday, my wife and I were enjoying the Norfolk Harborfest. While walking through the park, a guy recognized the letters on the baseball cap I was wearing, and came over to say hi! He was a fellow fraternity brother from the chapter at Norfolk State University. We took the photo you see above. Always a pleasure to meet another fraternity brother!

The rest of the trip was a great time! I knew that there was a plethora of activities around Norfolk/Virginia Beach, and suggested to my wife that we make a vacation out of it. We hit Colonial Williamsburg, the Chesapeake Bay Bridge-Tunnel, and the beach while we were there.

Although it was a lengthy trip, it was a good one! I look forward to doing it again at some point!

I’m speaking at SQL Saturday Virginia Beach — June 8

Saturday, June 8 is coming soon (a week from this Saturday). How will you be spending it?

For me, I will be speaking at SQL Saturday #839, Virginia Beach that day. I will be doing my presentation entitled: “Disaster Documents: The role of documentation in disaster recovery.” In my presentation, I tell the story of my company and my workgroup — which had an office in the World Trade Center on September 11, 2001. I had written several documents for our organization, and they ended up being critical to our recovery.

Come on out and check out my presentation. I can always use a good audience. Hope to see you there!

SQL Saturday Virginia Beach — I’m speaking June 8!

I just found out today that I will be speaking at SQL Saturday #839, Virginia Beach on June 8!

I will be doing my presentation about the role of documentation in disaster recovery!

I’ll post about this event again as we get closer to the date. See you there in early June!