Welcome to www.msunderestimated.com

Web Hosting - Databases, What Are They and Do You Need One? 'Database' is one of the most commonly used terms that one encounters in web site design. Yet, what they really are and whether they're essential is often not clear to novices. A database is a collection of organized data, stored in files that have a specific structure. It's that organization and structure that allows for easy and rapid storage and retrieval. The need for a database generally only arises when you have a certain amount of information and that information needs to have some structure. If you have a half-dozen names and addresses to store, a database is usually overkill. If you have a blob of data with no relationships between any of the items in that blob, maintaining a database is usually more trouble than it's worth. Maintain a database? Yes, like other complex systems a database, to be effective, needs to be designed properly at the outset then kept 'tuned' for good performance. The alternative is to gradually allow the database to become more and more disorganized. That leads to difficulty in use, poor speed of retrieval and more frequent failures. With MySQL, Access or MS SQL Server, the three most common choices of database product for web sites today, setting up a database is relatively simple. Even those with limited technical skill can get one up and running just by following some simple instructions. But some thought should be given to how you want the information organized, and to maintaining the system during its lifetime. Suppose you have a set of names, addresses, email addresses, products purchased, date purchased and amount. If you have only a few dozen records it matters very little how these pieces are arranged and related. A database usually isn't even warranted in this scenario. Once you have several thousand or more records, it matters a lot. Speed, the ease of expanding the set of attributes (like adding, say, product category), and other issues come into play. Even those with little technical expertise, but a willingness to exert logical thought and invest some time, can build a very robust database. Think about how you would organize a set of data (called 'tables'). Should Name, Address, and Product be in the same table? Or should the personal information be stored in one table and any product information (product, price, ...) in another? Some experimentation may be needed to get it right, but the choices have an impact on how easy the tables are to maintain. It also affects the speed with which programs can fetch old data and store the new. Having a database also introduces new maintenance issues for the server administrator, since backups usually need to be done differently. Recovering a failed database is usually more complicated than simply re-copying files from yesterday. Ask your hosting company what tools and skills they have for dealing with any database system you consider. It's true that introducing a database creates more complexity and the need for additional thought and administrative effort. At a certain level, professional expertise will be needed. But clearly the advantages outweigh the costs in many cases. Companies large and small eventually use databases to store and organize data. At some point, you may be fortunate enough to be one of them.

Web Hosting - Changing Web Hosts, Pitfalls and Planning At some point, nearly everyone finds it necessary to change web hosts. It may be just a migration to another server, or it may be changing web hosting companies entirely. Either way, the process is fraught with potential dangers. But there are ways to minimize the odds of problems and maximize your changes of a smooth migration. Plan, plan, plan. Make a very detailed list of everything that is on your current system. Review what is static and what changes frequently. Note any tailoring done to software and files. Be prepared to remake them if the systems aren't transferred properly or can't be restored. Keep careful track of all old and new names, IP addresses and other information needed to make the migration. Backup and Test Backup everything on your system yourself, whenever possible. Web hosting companies typically offer that as a service, but the staff and/or software are often less than par. Often backups appear to go well, but they're rarely tested by restoring to a spare server. When the time comes that they're needed, they sometimes don't work. Do a dry run, if you can. Restore the system to its new location and make any needed changes. If you have the host name and or IP address buried in files, make sure it gets changed. This is often true of databases. SQL Server on Windows, for example, picks up the host name during installation. Moving a single database, or even multiple ones, to a new server is straightforward using in-built utilities or commercial backup/restore software. But moving certain system-related information may require changing the host name stored inside the master database. Similar considerations apply to web servers and other components. Accept Some Downtime Be prepared for some downtime. Very few systems can be picked up, moved to another place, then brought online with zero downtime. Doing so is possible, in fact it's common. But in such scenarios high-powered professionals use state-of-the-art tools to make the transition seamless. Most staff at web hosting companies don't have the skills or the resources to pull it off. Prepare for Name Changes One aspect of moving to a new host can bedevil the most skilled professionals: changing domain names and or domain name/IP address combinations. When you type a URL into your browser, or click on one, that name is used because it's easier for people to remember. www.yahoo.com is a lot easier to remember than 209.131.36.158. Yet the name and or name/IP address combination can (and does) change. Still, specialized servers called DNS (Domain Name System) servers have to keep track of them. And there are a lot of them. There may be only two (rarely) or there may be a dozen or more DNS servers between your visitors' browsers/computers and your web host. Every system along the chain has to keep track of who is who. When a name/IP address changes, that pair has to be communicated to everyone along the chain, and that takes time. In the meantime, it's possible for one visitor to find you at the new place, while another will be pointing to the old one. Some amount of downtime will usually occur while everything gets back in sync. The Little Gotchas But even apart from name and IP address changes, there are a hundred little things that can, and often do, go wrong. That's not a disaster. It's just the normal hurdles that arise when changing something as complicated as a web site and the associated systems that underlie it. Gather Tools and Support Having an FTP program that you're familiar with will help facilitate the change. That will allow you to quickly move files from one place to the next to do your part to get the system ready to go or make repairs. Making the effort to get to know, and become friendly with, support staff at the new site can be a huge benefit. They may be more willing to address your problem before the dozen others they have to deal with at any given moment. Ok. On your mark. Get ready. Go.

Software Copyright Laws Software Copyright Laws Fail to Provide Adequate Protection Software copyright laws are among the most difficult to enforce among the masses. Many companies and corporations are also well known for overlooking these laws, which were designed to protect the makes of software from not earning their worth. Perhaps one of the biggest hitches leading so many software businesses to go out of business is the fact that they have a great deal of difficulty actually enforcing the software copyright laws that are in place and getting the money that is owed them according to the agreements that have been made with those on the using end of the software. Software developers, particularly in the corporate world design software that makes other companies run more efficiently. The software allows these companies to save millions of dollars each year. Software copyright laws protect the interests of the software developers that create these massive programs. These programs are often designed specifically for that one company and are very expensive. The agreement often consists of a certain number of users with the company purchasing more licenses or copies of the software during expansions or paying some sort of royalties for the use of the software. The purchasing companies agree to this and then more often than not fail to honor that agreement. The agreement is what allows this company to use that software, this agreement is what allows that permission. When companies aren't living up to their end of this agreement they are not only guilty of breaching that agreement but also of breaking software copyright laws. The trouble always lies in proving that they are not honoring the contract and the extent and duration of the breach. Some of the ways that companies will argue in defense of them not paying the royalties, additional fees, purchasing additional software, etc. is that they upgraded computers and reused the old software (they did actually purchase the rights to use the original software and by doing so feel that they have broken no software copyright laws) the problem lies in the fact that adding ten new computers and placing the software on those should mean that you remove it from or get rid of 10 old computers. This is rarely how it works. So now they've basically stolen ten copies of software that can be well worth hundreds of thousands of dollars. Multiply this by 10, 20, or 100 companies trying this or worse each year and the offending companies are costing software developers millions of dollars in profits. This is when software copyright laws are not as far reaching in their scope as they really need to be. Software copyright laws exist to protect the software companies from this type of abuse and misuse, however, the hands of the companies are almost unilaterally tied when it comes to proving that software copyright laws have been broken in court. There are always exceptions to every rule. In this case big business software developers that abuse the software copyright laws to the point of breaking make the exceptions rather than miserly consumers that do not wish to pay for the products they are consuming. The big boys are able to do this by offering licenses for their software and claiming that these laws do not apply to their situation because they are not actually selling the software only 'renting' out permission for people or companies to 'use' that software. The true irony is that these practices began as a response to the corporate irresponsibility mentioned above. It's amazing that the very software copyright laws that were created to protect these companies can't protect their consumers from the greed of the developing companies.