Sql Server Interview Questions on File Server and Client Server Database

Microsoft Office AccessImage via WikipediaOne of major things in two of this approach is of working with data but both of these works in different manner.

In File Server Database approach the data is stored in the file and user have to take data directly from the file. When any change is to be made it is directly on the file application that is open .The file and data writes to these files. If 10 users are online on data then 10 are working and writing on the file.

In a client server approach data is still stored in a file but controlled by a server all the access in the hand of server. When any of application wants to make use of existing data then application request is send to server. After that server reads the request and send feedback. When any of application wants to writes something on file the request is send to server the server writes on the file. One single person reads and writes from this data files.

Oracle, Informix, Microsoft Sql Server are the best suit example of client server databases. Single user desktop just like Microsoft access.

There are lots of advantages of client server databases.

1) Single program reading and writing data the less chance of accidental changes or crashes of data.

2) Only single program play good role of security so enforcement of security is easy.

3) Client server databases use network bandwidth more efficiently then file server databases.

4) All things are handling by single computes so performance is good and quite impressive.

5) Client-servers databases use some good features that protect our data just like logging transactions and recovery from disk and network errors.

Some of these features are also available in file server approach but these need more expensive client server market. You can also learn more on dot net interview questions.

Know more about sql server interview questions and sql server 2000 query

Article Source:

Zemanta Pixie


Advantages of a Dedicated Server

NEW YORK - NOVEMBER 30:  (NO SALES, NO ARCHIVE) In this handout photo provided by Microsoft, Microsoft Corp. Chief Executive Officer Steve Ballmer speaks about  the business availability of the Windows Vista operating system, the 2007 Microsoft¨ Office system and Exchange Server 2007 at a press conference at the Nasdaq Market November 30, 2006 in New York City.  This is the first simultaneous release of Microsoft's flagship products since the joint launch of Windows 95 and Office 95 more than a decade ago. The year 2006 also marks the 20th anniversary of Microsoft since its listing day on March 13, 1986.  (Photo by Keith Bedford/Microsoft via Getty Images) *** Local Caption *** Steve BallmerImage by Getty Images via DaylifeMany websites are hosted on a shared web hosting server. The main reason is the cost. A shared web hosting server costs a great deal less than a dedicated server. The number of sites on a shared web hosting server can be anywhere from 1500 to 2000 sites. The number of sites on the shared web hosting server will vary due to availability of disk space, allowed bandwidth per site and overall speed. Although shared web hosting is reliable and has minimal problems, there are advantages to host your site(s) on a dedicated server.

A dedicated server for your web hosting allows you to have a server solely dedicated to your site(s). In addition, a dedicated server will allow you complete authority to control and administer your server. When and if you decide on a dedicated server for your web hosting, you should have a fair understanding of dedicated servers. Although most dedicated server web hosting providers will provide technical support, you will find it a lot easier if you have the technical expertise to manage the server yourself. However, if you find that you will not be able to manage your server by yourself, opt for a managed dedicated server hosting. This option is especially for those who want to have dedicated web hosting but do not have the required expertise to manage it. This service allows you to have an entire server managed by a specialized hosting company. The cost of a managed dedicated server is quite expensive. Therefore, if you think that you can run and manage your website server by yourself, you should opt for an unmanaged dedicated server web hosting rather than a managed dedicated server.

You should consider a dedicated server web hosting when you find that the traffic to your site has increased substantially and your site is taking too much time to load. An analysis of the traffic to your site will tell you whether you should go to a dedicated server. The main thing to understand is that when you have many users working concurrently on your website, you should replace your shared web hosting with a dedicated server web hosting.

Since a dedicated server web hosting does not share its server with other websites (like shared web hosting), you will find that you have a lot more command over your server operation and its bandwidth. One of the advantageous features of dedicated server web hosting is that it can also be remotely configured and operated. The only obstacle is the cost. You are required to pay a lot more for your dedicated server web hosting as compared to your shared web hosting. Nevertheless, the facilities more than compensate for the cost.

When you choose a dedicated server web hosting provider, you should keep in mind that it should provide you good network stability, reliable operation, and the ease of operation of sophisticated applications. A dedicated server web hosting provider can be the perfect solution for anyone who is serious about his online presence.

For more information about a dedicated server and web hosting, visit Dedicated Server and Web Hosting

Article Source:

Zemanta Pixie


Server Firewalls

Exacq at ASIS 2007 2Image by exacq via Flickr Servers are probably the most vital part of each and every network; thus, the server itself needs to be protected very well from possible external or internal attacks. There are many server firewalls available on the market, and each one provides it’s very own features and security levels.

All server firewalls are deigned to protect the server; some of those firewalls do an excellent job while some of them simply aren’t good enough. What remains is the fact that servers are the first components that need to be secured inside a network.

In order to achieve high-security levels, servers should be equipped with sophisticated firewall systems that utilize both software and hardware technologies. A software-only firewall is simply not enough to fulfill the needs of a server. This is not something to be ignored. If the security of the server is compromised, then there are many severe consequences for the whole network.

In the best case, the server will be compromised but the intruders will not have enough time to do all they want to; if the administrators of the server are lucky, they will notice the intrusion early enough, and they will most likely take down the server until they resolve the problem. Of course, this means that the services that the server provides will not be available until the hole is fixed.

In the worst case scenario, important information will be stolen from the server; automatically, the clients of this server will also become vulnerable. Personal or financial information can be stolen from both the server and the client if the security is not tight enough.

Considering the above scenario, it’s not hard to understand how vital a firewall system is to a server. In order for a secure environment to be provided to the clients, the fundamental blocks of the service have to be secure.

Firewalls provides detailed information on Firewalls, Free Firewalls, Best Firewalls, Linux Firewalls and more. Firewalls is affiliated with Encryption Software.

Article Source:

Zemanta Pixie


Virtual Dedicated Server-When Dedicated is Still Too Much for Your Wallet

Control panel of the engines of the Clémenceau.Image via Wikipedia A virtual dedicated or private server is a pseudo server running on a dedicated server. Virtual servers typically have their own dedicated operating system that can sometimes vary from the operating system of the server they are on. To a virtual server the rest of the server does not exist. Ten virtual servers on one dedicated server cannot see each other or the server they're on.

Because of this encapsulation or insulation from other hosting accounts on the server, virtual accounts offer a great deal of flexibility where configuration is concerned. A typical VPS or VDS account might come with a certain control panel for example. If you wish to use a different control panel you can simply install one through root access. If PHP, MySQL or other modules are behind the times then you simply upgrade them.

Note also that you are the server admin. With a shared hosting account the server is upgraded by the company and security is maintained by them as well. The same can be said about the server that your virtual dedicated server runs on but not about your virtual dedicated server. Software and security are all your responsibilities making you a miniature server admin.

One way of looking at this is that there are things you just have to learn some times. A good virtual server account does usually come with software installed and a certain level of stock security. As long as you do not need to upgrade many times you will be just fine working from a control panel to create new web sites.

One can easily pay $120 to $300 a month USD for a dedicated server. If your site is just starting out many times you won't even come close to using those resources for a bit. If you have the budget for a dedicated server than it's the way to go but if you need a price break then consider virtual server hosting. You can find a decent virtual server account for just under $35 a month USD. If your coming from a typical shared hosting account you will appreciate the difference in performance and flexibility

Web Hosting Reviews and Information - StartLogic Company Profile and Hosting Plans

Article Source:

Zemanta Pixie