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...]

A Custom Laptop Cooler for Docked Laptop

image_thumb.png

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

clip_image004_2

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...]

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...]

Verizon 4G LTE Mobile Broadband is Fast…very Fast!

image.png

I was an early adopter of wireless broadband for laptops starting several years back with an offering from T-Mobile that was only as fast a dial-up connection.  Later I upgraded to Verizon EVDO 1x (3G) and achieved on average about 1.5 MB down and 0.5 up. This was much better than dial-up but still slower than most cable or DSL connections to homes or businesses in the U.S. In the beginning this 3G was limited to major metropolitan areas but now is available just about everywhere. Just a few weeks back, Verizon released its new 4G LTE wireless broadband capability, initially limited to … [Read more...]

Easily Save and Retrieve Application and User Settings in VB.NET or C# Apps

SNAGHTML1529810a.png

  We used to save our application or user settings in an INI file (dark ages) or more recently in XML files using our own code or classes borrowed from other developers. But applications built with the .NET framework using Visual Studio can take advantage of built-in tools to simplify or speed up access and saving of runtime values. Once common example is saving database connection string information in a configuration file so that it may be changed without need to recompile the application. Here are some simple examples in VB.NET. C# code uses a slightly different syntax the concepts … [Read more...]

500 – Internal server error from IIS 7.5 on Windows 2008 R2

SNAGHTML839201.png

You are running an ASP or ASP.NET web application on IIS on Windows 2008 R2 from a remote web browser and you constantly see following error message. While this is the proper results for a production server (you never want to show remote users the details of an error), it is not helpful while testing a new installation…as a developer you need to see the error messages on the remote browser. There is an obscure setting that controls this for both ASP and ASP.NET. I hope the following will help anyone needing to see error details on a remote connected browser. For Classic ASP Errors In … [Read more...]

Has the Demise of RIM’s Blackberry Already Begun?

UPDATE: 12/23/2010 – Cannot update the applications on my Blackberry Tour even after using the latest available version 6.0.1.18. The updates just hangs and never completes. It did this with the previous version of the Desktop Manager but hung at a different place.  My wife has the same phone and syncs with a different laptop. Both of us cannot update or inline or using the Desktop Manager. RIM – With all of your resources… you should be able to make this work. The more frustrated I get the the Blackberry the more attractive the new Android phones look! UPDATE: Leaked copies of Blackberry … [Read more...]