The Ozar Effect

Back in February one of my blog posts was highlighted on Brent Ozar Unlimited’s Weekly Links. Wow, what a bump in traffic! I usually receive a hand full of views a week, but on February 26th it reached 1,212. The cool part was it was actually the #2 link on Brent Ozar Unlimited’s newsletter for the day. If you don’t currently subscribe, here is a link to start. ...

April 9, 2018 · 2 min · Doug Purnell

SQL Life 2026

This month’s #tsql2sday is being hosted by Adam Machanic (t|b): Your mission for month #100 is to put on your speculative shades and forecast the bright future ahead. Tell us what the world will be like when T-SQL Tuesday #200 comes to pass. If you’d like to describe your vision and back it up with points, trends, data, or whatever, that’s fine. If you’d like to have a bit more fun and maybe go slightly more science fiction than science, come up with a potential topic for the month and create a technical post that describes an exciting new feature or technology to your audience of June 2026. (Did I do the math properly there?) ...

March 13, 2018 · 3 min · Doug Purnell

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

Daily Routines

I’m a big fan of Getting Things Done (GTD) by David Allen (t|b). I follow the GTD principals both at work and personal life. The key part of making GTD successful are routines. In this post, I’m going to review my daily routine that keeps my GTD system running like a well-oiled machine. For the daily routine, the morning fits my personality the best. I love getting up early and setting a goal for the day. You have to find the best time that works for you. Others like the evening to reflect on the day and set goals for the next, it is entirely up to you. Regardless of the time of day, the daily routine needs to hit on a few key areas: inbox zero, your calendar, and tasks for the day. ...

February 20, 2018 · 3 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

MySQL RPC with Linked Server

Regular blogging is one of my goals this year. One of the areas I struggle with is what content to blog about. While I was listening to SQL Server Radio (Episode 84) with Guy Glantser (t) and Matan Yungman (t), they mentioned a new blog post series they are starting titled “Something Cool Learned Today”. These are meant for sort 1-2 paragraph blog posts about things you learned. This is the spark I needed to build some additional content for my blog. ...

January 19, 2018 · 4 min · Doug Purnell

Spectre/Meltdown Baselining

This month’s #tsql2sday is being hosted by Arun Sirpal (b|t). The topic this month is how we conquered a technical challenge. The area I’ve been spending the most time in recently is baselining for the Spectre/Meltdown patches that are coming. We have a monitoring tool from Idera, SQL Diagnostic Manager, on our key production boxes but I wanted something consistent across all boxes that we could use for tracking and baselining wait types. ...

January 10, 2018 · 3 min · Doug Purnell

T-SQL Tuesday #97 – I am an Obliger

Goal Setting This month’s T-SQL Tuesday (#tsql2sday) host is Malathi Mahadevan (b|t). Goal setting has always been a difficult process for me. I always do a great job of researching/organizing my goals for the upcoming year but fall short in the execution phase. I tend to help others with their projects & tasks before mine; I have a hard time holding my self-accountable. For this reason, I decided to take advantage of a professional development program at work that allows us to talk with a career/life coach for a few sessions. ...

December 12, 2017 · 2 min · Doug Purnell

T-SQL Tuesday #51 - Don't bet against CHECKSUM when performing backups

This month’s T-SQL Tuesday is being hosted by Jason Brimhall (blog | Twitter). Jason’s theme is about gambling with SQL Server. What areas have you gambled with? Are there tasks that you should be doing that you are betting won’t be needed? One came to mind for me, CHECKSUM. I’ve always been a fan of Maintenance Plans. They are an easy way to get basic maintenance tasks established on an instance of SQL Server. The major down side of the built-in maintenance plans is no support for the CHECKSUM media option for BACKUP DATABASE. If you are performing backups without this option enabled, you run the risk of the pages in the backup media not matching the pages stored in the database. This is because without the CHECKSUM option, SQL Server doesn’t know if the page written to the backup media was written out correctly. The CHECKSUM option ensures that every page written out to your backup media has a checksum that matches the checksum of the page in the database. The CHECKSUM option also goes as far as doing a checksum on the entire backup that the RESTORE statement can take advantage of. There is a performance impact for using the CHECKSUM option but as everyone says, your backup is only as good as your restore. If you bet against your restore, your odds of a resume updating event just increased. ...

February 11, 2014 · 2 min · Doug Purnell

T-SQL Tuesday #50 - Automating Tasks

This month’s T-SQL Tuesday topic is the reason I love being a DBA, automating repetitive tasks. Hemanth Damecharla (b|t) picked a timely topic, as you start the new year, are there certain tasks that you need to automate that tend to sit on the corner of your desk yelling at you? This topic also reminds me of a chart I came across in the past describing the time savings associated with automating repetitive tasks. As at most places, we are all asked to do more with fewer resources. This often leads to additional workloads without the time in the day to complete them. How many of these can you automate? ...

January 14, 2014 · 2 min · Doug Purnell