Welcome to www.minisinbox.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 - Why Backups Are Essential One thing most web site owners have little time for is... anything! Anything other than focusing on their site content and the business or service it supports and the information it provides, that is. That means that administration often suffers, as it frequently must. There's only so much time in the day. But the one thing that you should never let slide are backups. They are like insurance. You rarely need it (you hope), but when you do you need it very badly. Performing regular backups - and testing them - doesn't have to be a nightmare. A little bit of forethought and effort and they can be automated to a high degree. And, they should be tested from time to time. Even when a backup appears to have gone without a hitch, the only way to know whether it's of any value is to attempt to restore the information. If it can't be restored, the backup is worthless. Even when the web hosting company provides the service, there is still some planning involved for the site owner. Hosting companies often rely on one or both of two methods. They backup everything (called a full backup), then backup anything which has changed since the last full backup (called an incremental backup). Of special interest are any configuration files that have been tailored. If you've modified the default installation of a software package, you want to be able to recapture or reproduce those changes without starting from scratch. Network configuration files, modifications to basic HTML files, CSS style sheets and others fall into the same category. If you have XML files, databases, spreadsheets or other files that carry product or subscriber information - about items purchased, for example, or people who signed up for a newsletter - those should get special attention, too. That's the lifeblood of your business or service. Lose them and you must start over. That can break your site permanently. It should go without saying that all HTML and related web site files that comprise visible pages should be backed up regularly. It isn't necessary to record every trivial change, but you can tailor backup software to exclude files or folders. Usually they're so small it isn't worth the trouble. But in some cases those small changes can add up in scenarios where there are many thousands of them. Here again, the backups are worthless if they can't be used. Even if the hosting company charges for doing so, it's worthwhile to test once or twice a year at least to ensure the data can be restored. That's especially true of database backups, which often involve special software and routines. Database files have a special structure and the information is related in certain ways that require backups be done differently. Developing a backup strategy can be straightforward. Start simply and review your plan from time to time, modifying it as your site changes and grows. But don't neglect the subject entirely. The day will come when a hard drive fails, or you get hacked or attacked by a virus, or you accidentally delete something important. When that day comes, the few minutes or hours you spent developing and executing a backup plan will have saved you days or weeks of effort.

A Writer’s Best Friend: The Job of an Editor (editing) Are you irritated by typos and spelling errors in professional documents? Are you able to help your friends make their writing error free? You may be a good candidate for editing. The world is incredibly dependent on writers and the craft of writing. It is how people communicate with each other most often. As the internet writing forms do not require people to hold to correct grammar, spelling or professional style, most writers are losing their capabilities to complete a professional document or book without help. Writers have always needed the help of editors. Even when there was strict attention to correct writing, editors could come and catch missed errors as well as mistakes in content. Editors are still needed today. Read on to find out more about what can be involved in a life of editing. Who are the Editors? Editors are those people with the ability to read a document and guide a writer to make it the best piece of writing that it can be. Editors work in newspapers, and magazines. They also work for publishing companies and in student resource centers. Editors generally have some education that leads them to the ability to help writers. They probably have a degree in language as well as training with style manuals. What is the Job? An editing job involves taking a piece of writing and conforming it to some particular set of standards. Style manuals are often the standard used. Different publications will choose a style and then ask the editors to make all of the writing that comes out to be consistent to that style. Editing is not only concerned with objective corrections like spelling and grammar though. An editor must also read for clarity, consistency and voice. If a writer claims one thing in one point of their piece and seems to contradict that point in another part, it is the editor’s job to catch the mistake and work with the writer to fix the inconsistency. If the writer is speaking authoritatively in the beginning of a piece and then becomes apologetic later, it is the editor’s job to make the tone match. Editors help with sentence construction, word choice and content order. How to Find Editing Jobs If any of the above job description sounds interesting and even exciting to you, you just may have found your ideal job calling. Before you start looking for editing jobs, you should test your skills. There are editing tests online. Feel free to use a style manual as well as your intuition as you correct the sentences and word choice in the different test questions. If you do not pass the test, you should probably spend a little more time reading a style manual and a basic grammar guide. Once you can ace an editing test, it’s time to look for a job. Be sure to include any experience you may have had. Include any editing of any kind you have ever done. Peer editing in school is appropriate experience to mention. Also be sure to list any style you are able to edit to. Examples are AP, Chicago, MLA, and so on. If you get an interview, be prepared to take another editing test, with the help of your manual. The test will likely be timed. Editing is a rewarding career. It involves helping writers to do their very best writing geared to their particular audience. While it can be stressful because of deadlines and workload, at the end of the day you will know that you have made the world of the written word a little cleaner and much more effective. Editors are an essential part of making the written word what it is today.