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

iPhone 4 IOS 5 Upgrade Error 3004 & 3014

I was excited to see the iOS 5 update was available yesterday (10/12/11) so I did what any normal person would do and quickly connected my iPhone 4 via iTunes and clicked the Check for Update button. The download was about 740MB and didn’t take too long to pull down from Apple’s site. The install appeared to be going well until it started the restore process and bombed out with an error code 3004/3014. Did some research via Google and didn’t find an exact fix but found plenty of other people experiencing the same problem. I was able to get past the verification stage with Apple, but the restore was failing every time I tried update the phone. I was stuck in an infinite loop. The phone would have the factory default “Connect to iTunes” message, but every time it went to restore the iOS 5 image it failed. I finally ran across a few articles taking about pulling the iOS 5 image down directory from Apple and applying that image instead of the one that was pulled down from iTunes. You can find the iOS 5 image links to all the Apple devices compatible with iOS 5 here. ...

October 13, 2011 · 2 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

F11 and VMware ESXi 5 on my Mac

As I was installing ESXi v5 in my lab I came across a prompt to press F11 to accept the license agreement, that I fully read :). On my Mac I was using iDRAC v6 Enterprise via the browser to install the ISO image. When I went to press F11, my Mac’s desktop was shown. I have the full Apple USB keyboard so I tried using the fn key with F11 and without, each time with no success. I thought I’d start in the System Preferences section under Keyboard. Under the Mission Control section there was a short-cut for F11 and F12 that was grabbing the keystroke before it was sent through the browser. ...

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

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

The Wonderful World of Blogging!

Welcome to my blog. My name is Doug Purnell and I live in Greensboro, NC. I’ve been in the technology world for the last 20 years ever since graduating from Appalachian State University with a Computer Science degree. I started in the Visual Basic 4.0 & SQL Server 6.5 world back in the early 90’s and have loved IT ever since. My goal is to try to convey my experiences in the IT world from SQL Server, VMware, and the data center. I’ll even try to throw in a few thoughts on Apple products, Nikon Photography and my weekend cookouts on the smoker.

June 6, 2011 · 1 min · Doug Purnell