Welcome to makedonikajournal.org

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 - Is a Dedicated Server Worth What You Pay? In reviewing web hosting plans, many web site owners are faced at some point with the decision of whether or not to pay for a dedicated server. A dedicated server is one which holds your site(s) exclusively. It's not shared with other sites. You then have the option to put one site or many on that piece of hardware. But the decision is never easy. There are multiple considerations to take into account, far beyond just the higher dollar outlay that inevitably accompanies a dedicated server option. Performance is (or should be) a prime consideration for the majority of site owners. Studies show that when a page doesn't load within about 10 seconds or less, almost everyone will give up and go elsewhere. The delay may be caused at any of a hundred different points in the chain between the server and the user. But often, it's the server itself. In any case, it's important to eliminate the server as a possible bottleneck, since it's one of the few points over which the site owner can exercise some control. That need for control extends further than just performance, however. Other aspects of the user experience can benefit or suffer from server behavior. Security is a prime example. With the continuing prevalence of spam and viruses, a server can easily get infected. Having only your site(s) on a single server makes that issue much easier to deal with. With fewer sites on a server, there is less likelihood of getting infected in the first place. Also, since you will place a higher value on security than many others, it's easier to keep a dedicated server clean and your site well protected. You can use best practices in security to fortify your site. Having other sites on the server that you don't control raises the odds that your efforts are for nothing. One way your efforts can get watered down is through IP address sharing. Less sophisticated hosting services will often assign a single IP address to a single server and multipe sites. That means your site is sharing the same IP address with other domains. That leaves you vulnerable in several ways. Virus or spam attacks may target a particular IP address. If you have the same one as another site, one that is more likely to attract hostile intentions, you suffer for and with someone else. In other cases an IP address range is assigned to the server, with each site receiving its own address from within that range. Though better than the one IP:server scenario, this still presents a vulnerability. Many attacks try a range of IP addresses, not just a single one. But even legitimate sources can give you trouble when you share an IP address or a range. If another site engages in behavior that gets it banned, you can suffer the same fate if they ban the address or range. If the miscreant that shares your server/IP address or range is himself a spammer for example, and gets blacklisted, you can inadvertently be banned along with him. Using a dedicated server can overcome that problem. There's a certain comfort level in knowing what is installed on the server you use, and knowing that you alone put it there. But a dedicated server option may require increased administration on your part. If you're not prepared to deal with that, you may have to pay still more to have your dedicated server managed by someone else. All these factors have to be weighed carefully when considering a dedicated server plan.

Preparing Questions to Ask in your Upcoming Job Interview When you get ready for a job interview, chances are you have spent a lot of time trying to guess the questions you will be asked and prepare your answers to them. How will you explain that gap in your work history? What will you say when they ask you why you left your last job? In the rush to make sure that you have all of your answers perfectly prepared and ready, don’t forget to prepare a few questions of your own to ask the person who is interviewing you. Asking questions is an important part of your interview. When you get asked the old “do you have any questions for us” one, it pays to actually be able to come back with a few questions instead of a, “no, I don’t think so.” Asking questions will show that you are engaged in the interview and have done some thinking about the position, plus, the questions you ask will help you elicit valuable information you need when you have to decide whether or not to actually take the job, should it be offered to you. The first thing you should want to find out is why the job is open in the first place. Is the job you are applying for a new position? That means you can expect to have a lot of transitional bumps along the way as you are integrated into the company. If the job is not new, and the person before you was fired, then you can expect things to be in a state of disarray when you take over and that you will have to spend a lot of time up front cleaning up spilled milk. If the job is open because the person who had it before you moved up in the company, then you will know that this is a job with a lot of future potential. Next, find out a little bit about the person who will actually be your boss if you get the job. Sometimes, this person will be involved in the interview, but often they will not. Finding out how high up in the company chain you will be reporting will help you gauge how important the position for which you are applying is to the company. Also, it helps to know a little bit about the personality type of the boss to be. If you like to keep your head down and do your work, and your potential new boss is one of those “wacky” types, then you may want to look elsewhere. From there, ask about the kinds of responsibilities you will need to take on board right out of the gate. When companies are hiring for a new position, they usually have a few ideas about what that person will need to start working on right away. Getting a clue about your first project will help you decide if this job is right for you. This is also a good time to ask the interviewer about their job and why they like working the company. You may find out that this really could be your dream job, or you may end up sensing from your interviewer that you should run away, fast. Last but not least, ask your interview when you should follow-up on your interview. Don’t open the door for a “don’t call us, we’ll call you” kind of interview closing. Let the interviewer know to their face that will be making the effort to contact them again. You may get the vibe from your interviewer that the job probably will be going to someone else, so you can move on quickly, or you may end up being offered the job on the spot. Either way, you will have opened the lines of communication to take the next step.