http://www.somacon.com/ Articles on web development, software, and hardware. en-us Copyright 2004-2010 Shailesh N. Humbad All Rights Reserved. 2013-04-12T05:26:32-07:00 noreply@spambucket.com Technology daily 1 2000-01-01T00:00+00:00 http://www.somacon.com/p586.php This article describes how to restore a SQL Server database backup file (.bak) to a SQL Server database hosted on Amazon's Relation Database Service (RDS). 2013-04-12T05:26:32-07:00 Web Development http://www.somacon.com/p585.php How to use robocopy to move the contents of an old system drive to a backup drive. 2013-03-29T06:57:26-07:00 General Interest http://www.somacon.com/p584.php This code below shows how to generate a unique identifier that is safe for URLs and file names. 2013-03-22T07:22:12-07:00 Web Development http://www.somacon.com/p583.php These instructions show how to get the message count by year and week number from Thunderbird. 2013-03-16T15:05:46-07:00 General Interest http://www.somacon.com/p581.php Notes on how to set up a new ASP.Net website in Windows 7 Pro on IIS 7.5. The trick is to create a new application pool for the new site and configure the site to impersonate the same user as the application pool, which is "IIS AppPool\application-pool-name". 2013-02-11T08:39:34-08:00 Web Development http://www.somacon.com/p580.php These are notes for how to set UTF-8 (UTF8) collation and character set in MySQL database server. There are also notes on how to set the dfeault collation and characters set to UTF-8 on Amazon RDS MySQL database instances. 2013-01-31T06:16:26-08:00 Web Development http://www.somacon.com/p579.php Sage 50 Complete Accounting is the new name for Peachtree Accounting. The SDK (software development kit) is currently not easily accessible via the Sage website. I found the important download links in the community forums and have listed them below. 2013-01-15T13:11:13-08:00 C and C# Programming http://www.somacon.com/p576.php This is a highly optimized function to get the file size abbreviation in bytes for an arbitrary, 64-bit file size. It returns the file size to three decimals followed by the abbreviation, like KB, MB, GB, etc. Use this function to display a human-readable, user-friendly file size to your users. 2012-06-25T08:42:32-07:00 C and C# Programming http://www.somacon.com/p572.php Notes for setting up a cheap, low-cost MySQL database server on an Amazon EC2 t1.micro spot instance. This can be useful for situations where your MySQL instance does not need 100% availability, e.g. for a cheap, test MySQL server. 2012-04-03T06:36:55-07:00 Linux and FreeBSD http://www.somacon.com/p571.php This article describes how to resolve the QuickTime BYTE_RANGE_ERROR_MESSAGE on the iPhone/iPad when playing back MP4 streaming videos. 2012-02-08T10:25:19-08:00 Troubleshooting http://www.somacon.com/p570.php 2011-12-04T05:42:09-08:00 Freeware http://www.somacon.com/p569.php These are some setup notes for setting up a test/development instance of Magento, using an existing database against a fresh installation of the source code on a staging server. 2011-04-26T08:06:03-07:00 Databases http://www.somacon.com/p568.php This online utility quickly aggregates the lines pasted in the text box and shows you count of occurrences of each value. Use this to quickly aggregate the values to find duplicate lines, or to count the number of repeats. 2011-03-11T06:40:24-08:00 Freeware http://www.somacon.com/p567.php 2011-02-21T14:17:52-08:00 Troubleshooting http://www.somacon.com/p566.php Instructions for using Excel to import CSV password files into KeePass 2.x. 2010-10-29T16:00:59-07:00 General Interest http://www.somacon.com/p565.php This article describes Paypal’s Automatic Withdrawal or Auto-Sweep option, to automatically withdraw your Paypal balance to your checking acount. 2010-09-27T05:42:07-07:00 General Interest http://www.somacon.com/p450.php 2010-02-02T08:26:10-08:00 Reviews http://www.somacon.com/p546.php Encode or Decode any URL, URI, or other text online using the form below. 2009-09-09T09:27:25-07:00 Freeware http://www.somacon.com/p543.php A simple way to display alternating background colors with the ASP.Net 3.5 ListView Control. 2009-03-18T11:08:00-07:00 Web Development http://www.somacon.com/p542.php Use the Javascript function below to quickly remove or delete all the items from a select box/dropdown list in your web page. 2009-03-06T10:56:33-08:00 Web Development http://www.somacon.com/p541.php 2008-11-20T12:46:32-08:00 Web Development http://www.somacon.com/p540.php How to alternate table or list row colors in the partialLoop call of Zend. 2008-06-26T16:34:12-07:00 Web Development