Don will be Freezin for a Reason!

Polar Plunge

  Brrr...I am jumping into the icy waters of Lake Lanier Saturday, February 20th. No, I’m not crazy - I’m raising money for the Special Olympics of Georgia and I need your help!   Each year the Johns Creek Police Department (JCPD) participates with groups all over the US in the Polar Plunge which is the largest fundraising effort for the Special Olympics. It is presented by the Law Enforcement Torch Run of Georgia. Since I volunteer with JCPD in the Citizen Auxiliary Police Services (CAPS), I am participating in the 2016 Polar Plunge to raise money for the Special … [Read more...]

User Defined ReOrdering in a SQL Server Table

  Suppose you want to allow your users to re-order a set of rows in a SQL Server table. Once the user has defined the new order, you need to save that order in SQL Server so that you can re-display the rows in the new order. But how can you accomplish this? You probably added a new column to the target table appropriately named sort. But how do you update this sort column so that it can reflect the new order? Let's assume we have 3 rows as follows and we have ORDER BY sort in query so that they display as... IDNameSort 1Red1 2Blue2 3Red3 and then our user re-orders the … [Read more...]

SQL Server – Age Calculations – Day vs Hour

  If you need to calculate age in days using SQL Server Transact-SQL, you have lots of options. When your age should be displayed in elapsed "days" for example, you might think that using the DAY attribute in DATEDIFF() would be the way to go. But you may want to use HOUR rather than DAY if your calculations must be accurate. Why?  Because with DATEDIFF() using DAY, calculations are based on midnight boundaries. This means that your number of days will change if you are before or after the midnight boundary. For example, your actual time-span may have only been a couple of hours  … [Read more...]

Macbook Pro 2013 Crashes-Restarts Nightly

  My new Macbook Pro 2013 is great and most of the time it performs flawlessly. However, it recently began crashing nightly while in sleep mode. Each morning I see the report that it crashed overnight and restarted. I am working now isolate the cause. The only changes after this started occuring have been upgrading from a single Dell 24 inch monitor to dual Dell 27 inch monitors plus the addition of an Anker 9-port USB hub. I also have VMWare Fusion 6.0 running a Windows 7 VM (my development environment) but it has crashed with the VM suspended so its looking more like the hub or … [Read more...]

Awesome Memorial Day Hike on Vickery Creek Trail with Liz


  Liz and I decided we would spend memorial day hiking a trail for fun and exercise. Rather than our typical jaunt up to the north Georgia mountains, we decided to try a smaller but beautiful trail only a few miles away in Roswell, GA. This was a fitting hike for Memorial Day as the trail and Vickery (Big) Creek are home to a spillway dam that was a valuable asset to the South during the Civil War, having powered the mill wheel that was built downstream at the now abandoned mill ruins.These mills were leading manufacturers of materials used for the Confederacy. The warm day provided … [Read more...]

A Custom Laptop Cooler for Docked Laptop


If you use a laptop very often then you are fully aware of how hot they can become on the bottom. As a result, the stores are full of devices popularly referred to as  “Laptop Cooling Pads” or “Chill Mats”. They are USB powered fans in a portable mat that you place between you and your laptop or on a desktop. They protect your lap from the warm, bottom surface of a laptop and also keep the laptop cool which is important to prevent overheating. This becomes especially important when you are using one of the more high-end models with powerful CPUs and graphics capabilities. Just like their … [Read more...]

Tips on Downloading Perimeter Church Sermons as MP3


Perimeter Church is a large Presbyterian PCA church in north Atlanta. They make their sermons available from their web site and via pod-casting using iTunes. The sermons are some of the best, scriptural based teachings you will find. Most are from lead teacher Randy Pope who founded the church over 25 years ago. This article explains how to access the online sermons both in streaming format from the church's site and via downloading MP3s directly to your computer using your browser, Outlook 2007 or any RSS reader. Podcasting means the you can listen to the sermons online using a computer or … [Read more...]

Hike to Panther Creek Falls


  Liz chose to spend her birthday hiking and so after some research, we chose to hike to Panther Creek Falls. The falls are located in Habersham County, GA and the trail follows the creek in for over 5 miles. We parked at the Panther Creek Recreation area lot just off of Old Historic Hwy 441 and from there it was about 3.7 miles to the falls heading south east from the parking area. The trail takes you under the 441 overpass and follows the creek into a beautiful and quiet area of the forest. The scenery changes significantly along the entire hike so you are treated to new surprises. … [Read more...]

Bike Riding over the July Fourth Holiday for Fun and Exercise


Liz and I enjoyed this year’s July 4th holiday by riding our bicycles across a couple of Atlanta’s best outdoor trails. Even amid very hot and humid weather, the majority of our ride was under a canopy of thick trees providing a beautiful and very comfortable place to enjoy the outdoors. Our rides were only a couple of hours each but provided excellent aerobic exercise. We were among many others who were walking, jogging, skating and riding these beautiful trails. Alpharetta’s Big Creek Greenway On Friday,  we rode the entire length of the Alpharetta Big Creek Greenway starting at new … [Read more...]

Possible Clue to Getting Long Battery Life with HTC Thunderbolt Android Phone

Poor Battery Life defined: Could not go through a normal workday without having to plug into AC! I have had the new HTC Thunderbolt Phone from Verizon for several months now and have had to live with horrible battery life like everyone else until recently. I had read all the blogs and tried all of the tips including task killers (which can actually use more power than they save), cutting back on sync schedules and more. Nothing had really helped and I tried them all. Coming from the Palm and then Blackberry’s I was used to going several days on a single charge. At one point the battery started … [Read more...]