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

#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

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

Understanding SQL Server Instances

Being raised within SQL Server 6.5 & 7.0, SQL Server instances were not available in those versions. I never fully understood the advantage of having multiple instances on the same server so I never embraced it. I always had a single, default instance per physical server. Once I got involved with virtualization a few years ago, having multiple instances of an OS running on a single physical server finally got me thinking about multiple instances of SQL Server. ...

September 16, 2011 · 4 min · Doug Purnell