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

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 #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

Virtual Book Club: SQL Server Execution Plans, Chapter 5

Everyone loves reading a good book, especially about SQL Server. I’ve been on a training kick lately and the timing of this book club was perfect. Denis Gobo (b|t) has experience starting a book club where he works and decided to bring it to the SQL Server community. The goal of the club is to read a chapter each week and discuss things you learned, liked and disliked. You can ready Denis’s original post here. The first book chosen was written by Grant Fritchey (b|t) and is titled “SQL Server Execution Plans, Second Edition”. You can get a free electronic copy or purchase a print copy from simple-talk.com. ...

October 10, 2013 · 3 min · Doug Purnell

Virtual Book Club: SQL Server Execution Plans, Chapter 4

Everyone loves reading a good book, especially about SQL Server. I’ve been on a training kick lately and the timing of this book club was perfect. Denis Gobo (b|t) has experience starting a book club where he works and decided to bring it to the SQL Server community. The goal of the club is to read a chapter each week and discuss things you learned, liked and disliked. You can ready Denis’s original post here. The first book chosen was written by Grant Fritchey (b|t) and is titled “SQL Server Execution Plans, Second Edition”. You can get a free electronic copy or purchase a print copy from simple-talk.com. ...

October 1, 2013 · 3 min · Doug Purnell

Virtual Book Club: SQL Server Execution Plans, Chapter 3

Everyone loves reading a good book, especially about SQL Server. I’ve been on a training kick lately and the timing of this book club was perfect. Denis Gobo (b|t) has experience starting a book club where he works and decided to bring it to the SQL Server community. The goal of the club is to read a chapter each week and discuss things you learned, liked and disliked. You can ready Denis’s original post here. The first book chosen was written by Grant Fritchey (b|t) and is titled “SQL Server Execution Plans, Second Edition”. You can get a free electronic copy or purchase a print copy from simple-talk.com. ...

September 19, 2013 · 2 min · Doug Purnell