I'm Speaking at SQL Saturday Raleigh

I’m honored to have been selected to speak at SQL Saturday Raleigh #721 on April 14th. I’m speaking about choosing the right high availability (HA) and/or disaster recovery (DR) solution for SQL Server. I’m given this talk just once before at the Companero Conference back in the fall of 2017. With the release of SQL Server 2017, there are few more HA/DR options that we have available to us. There are plenty of other great sessions being offered that day so it is not too late to sign up! ...

March 2, 2018 · 2 min · Doug Purnell

Taking a photo walk to a BBQ

This month’s #tsql2sday is being hosted by Aaron Bertrand (t|b). Aaron gives us a choice this month to talk about our passions outside of the SQL Server community or our T-SQL bad habits. I don’t have enough time to bore you with all my T-SQL bad habits so I’ll try to inspire you with my #SQLBBQ & #SQLPhoto passions. When I not architecting SQL Server solutions at Elon University, I’m usually behind a camera or BBQ cooker. Both of these passions allow me to exercise the creative part of my brain when I’m away from the office. ...

February 13, 2018 · 3 min · Doug Purnell

Working smarter, not harder, as a DBA

The butterflies were flying! This was my first presentation for Triad SQL PASS user group, and any group for that matter. I started attended our local SQL PASS chapter back in the fall of 2011 while I was between jobs. Kevin Goode was the one who got me thinking about doing a presentation, and after I had a few months under my current position as DBA, I came up with a topic: how to work smarter as a DBA. I found that starting a new DBA position requires working on understanding your environment quickly without disrupting the day-to-day business. This presentation gives you insight into tools that keep our servers running smooth and the training that keeps me up to date of the latest trends. ...

June 11, 2012 · 2 min · Doug Purnell

2012 To Do's for #SQLFamily

As I sat down and wrote out my goals for 2012 for my job, they didn’t take into account my blogging, user groups and #SQLFamily. This is why this is a perfect #mememonday project. You can read more about #mememonday here from Thomas Larock (Blog, Twitter). I’m fairly new to the #SQLFamily. I didn’t start getting involved till June 2011 and up to now, didn’t participate in monthly blogging like #mememonday or #tsql2sday. For the past 8 months have just been digesting information like I was eating at Golden Corral. Twitter, webcasts and RSS feeds can take hours a day to stay updated. I still find it hard to get through all the Twitter feeds a day and finally had to limit the number of RSS subscriptions under Google Reader so those didn’t get behind as well. As I write this, I can see TweetDeck notifications going off every few minutes. ...

January 9, 2012 · 4 min · Doug Purnell

2011 was the year of #SQLFamily

As the name suggests, SQL Family feels like family. There is no other professional organization in the world that supports a product line as well as #SQLFamily. My introduction to #SQLFamily was in the summer of 2011 when I decided to get back into SQL Server full-time after going to the dark side, management, for the two previous years. I had a strong background in SQL Server 2000 & 2005 but not the full-time experience under 2008 & 2008 R2. ...

December 31, 2011 · 3 min · Doug Purnell

September's Inaugural Triad SQL BI PASS User Group

I attended the inaugural Triad SQL BI PASS User Group last week hosted by Inmar in Winston-Salem NC. DataMasters provided the pizza before the meeting and Wayne Snyder [twitter] from Mariner USA was the guest speaker that talked about the top 10 reasons to upgrade to SQL Server Denali. Melissa Wittner [triadsqlbi@gmail.com] is the Chapter Leader for the new group and did a wonderful job getting the group start and the meeting organized. You can visit the chapter’s website here. ...

October 4, 2011 · 1 min · Doug Purnell

September's Triad SQL PASS User Group

I attended a great session September 15th 2011 at the Triad SQL PASS User Group with Jason Hall from SQL Sentry demonstrating the advantages of SQL Sentry’s Plan Explorer over the built-in SSMS plan explorer. You can find Jason under @SQLSaurus on Twitter. The meeting was hosted by Dynamic Quest, and everyone’s favorite pizza and soda was served before the meeting started at 6:30pm. Jason went through 7 example queries to show how the SQL Sentry Plan Explorer reporting results compared to SSMS. Sentry’s product is free and integrates directly into SSMS. Here are some other advantages with Sentry’s Plan Explorer: ...

September 30, 2011 · 1 min · Doug Purnell