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

Virtual Book Club: SQL Server Execution Plans, Chapter 2

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 17, 2013 · 4 min · Doug Purnell

Virtual Book Club: SQL Server Execution Plans, Chapter 1

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 5, 2013 · 3 min · Doug Purnell

Work Stoppage Events (Meetings)

As the calendar reminder comes up with the dreaded 15 minute warning for another work stoppage event, it occurred to me how import it is to prepare for meetings to make them as productive as possible. I like to use Evernote to document all meetings and projects. Each morning I take a look at the scheduled meetings and start a new note for each of them by creating three sections: Items to Discuss Notes To Do Based on the meeting, I go through my master to do list and create bullets under ‘Items to Discuss’ to update the status of each item. I also comb through my inbox and add any issues that might be relevant to the meeting. It is important to spend time updating this section of meeting preparation, this can ultimately serve as a personal agenda so you can get all you points across to the rest of the attendees. ...

June 19, 2012 · 4 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

Database Mail Configuration Error 264

As most of you know, the Database Mail feature in SQL Server 2008 is the life blood of any notification system for your instances. If Database Mail fails to send notifications, you may not be warned if a job fails, or worst, a backup job. We had a server last week that was exhibiting a weird behavior within Database Mail. I was receiving mail from all parts of the Database Mail environment except for Agent Job Notifications. I was able to send test emails from Database Mail, able to receive maintenance plan summary reports and even receive emails from within maintenance plans using the notification task. Why was Agent Job Notifications the only area that was mis-behaving? As I started diagnosing the issue I checked the main areas that usually stumped me in the past: ...

January 22, 2012 · 2 min · Doug Purnell

#meme15 for Twitter

Jason Strate (blog|Twitter) has started a new meme project about social networking for SQL Server professionals. This month’s theme is all about Twitter. We have been asked to answer the following two questions: Why should the average Jane or Joe professional consider using Twitter? What benefit have you seen in your career because of Twitter? I consider myself an average Joe SQL Server professional. I’m a DBA for a private University and enjoy solving business problems with data. Up until June of 2010, I did not have a Twitter account and was not involved in the #SQLFamily. When I was getting back into the DBA field after going to the dark side (management) for a few years, I found Twitter as the catalysts for learning. I was able to follow a few big hitters in the #SQLFamily and with in the first day, started reading tweets for webcasts and blog posts. ...

January 16, 2012 · 3 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