Tag Archives: SQL

Virtualisation – Doing More with more and paying less
– a beginners guide

The trend now is to do away with several servers and combine them in to one. It seems easy but many of the so called IT people don’t understand it so what chance do you? Well here is a simple guide. Ask your proposed installer and if they can’t make it this simple, don’t use them, use us instead!

A file server isn’t just a box that stores data for sharing, its much more than that and it can be even more than that too.

Let me explain all the tasks and Jobs that a server has to do:

Domain controller, it looks after all the computers and users, who does what, who can do what, who does what where and with what. It contains all the permissions, security rules and without it your network domain wont work. It holds all this in a thing called the Active Directory, like a phone book.

DHCP Controller When a computer, phone, tablet or anything joins the network it needs some information so it can connect with everything else. The DHCP controller does this and also limits the connection time.

File Server This is sharing the data files according to the rules of the Domain Controller and Active directory

That’s the simple stuff now comes the specialised heavyweight stuff:

SQL Server This is a special role for holding and handling data. Big fat files need special handling to keep them working quickly.

Exchange Server. This is the e-mail, diary and contacts server. Its what makes Outlook work in a network.

Remote Desktop Server aka Terminal Services. This takes some imagining. Imagine several desktop computers, now cram them into one box so that several people can connect remotely as if they were using a computer in the office.

In the past you needed three or four servers one for the simple stuff and one each for the heavier role. You could not put them all on one machine as they would fight with each other and the system would become unreliable.

Computers have come on a long way and are now much more powerful, a server still spends a lot of time doing nothing and a way has been developed to use this spare time without needing all the extra drives, power supplies, video cards etc. This is called virtaulization.

Imagine we take a big powerful computer which has 24Gb of memory and two network cards. Its going to be cheaper than four separate servers. Now divide it up so that there is the basic server which has 8Gb of memory reserved for it. Now take the rest of the memory plus a lump of hard disk, split it into two and treat these parts as servers, separate memory but sharing the same power supply, processor etc.

If a single computer costs for example £3,000 then you would need three or four at a cost of £12,000. By using Virtualization we can use a £6,000 computer to do all the tasks.

Virtualization saves money, energy, and space. After you’ve decided to go virtual, take steps to make implementation easier: Get to know some important terms about virtualization, types of virtualization, and leading companies and products in virtualization.

Then we have backup and Anti Virus control.

So the reasons for using Virtualization?

  • It saves money: Virtualization reduces the number of servers you have to run, which means savings on hardware costs and also on the total amount of energy needed to run hardware and provide cooling
  • It’s good for the environment: Virtualization is a green technology through and through. Energy savings brought on by widespread adoption of virtualization technologies would negate the need to build so many power plants and would thus conserve our earth’s energy resources. 
  • It reduces system administration work: With virtualization in place, system administrators would not have to support so many machines and could then move from fire fighting to more strategic administration tasks. 
  • It gets better use from hardware: Virtualization enables higher utilisation rates of hardware because each server supports enough virtual machines to increase its utilisation from the typical 15% to as much as 80%. 
  • Backing up is easier and each system doesn’t take from the other. They all have their separate resources rather than sharing them.

  • Licensing
    You need a base licence of Server with Hyper-V (The virtualiser)

    You need a Server Licence for each virtual machine. In our example two

    You need a licence for Exchange and SQL servers

    You need user licences (Cal’s for each concurrent user of each system)

    Using Microsoft Small Business Server 2003? You’ve got about a fortnight to save £5,000 off the replacement.


    As we have said in a previous post Microsoft are ending the Small Business Server package.

    This package was ideal, it was introduced so that small businesses with 5 to 25 users could have all the facilities that larger companies enjoyed the at a fraction of the price. This included exchange, SQL, remote desktop and various other packages and most businesses need.

    It would appear that the entire reason for discontinuing an incredibly popular package is purely to increase revenue.

    We recently provided a quotation for the installation of small business server in to a business. The owner decided that the time was not right due to lack of funds and he would put off the purchase into the new year.

    We decided to look at exactly how much this delay would cost him. The difference was staggering, the delay would cost him over £5,000 more than if you bought now. If he decided to buy the entry level Microsoft server and use a system for his e-mail which was not exchange and to forgo SQL and it would still cost an extra £700.

    Of course you can buy the entry level server from Microsoft and use the cloud to supply your e-mail system but over five years it will cost you an extra £700 if you ignore the fact that you will need to rent your software and hope that your Broadband is fast enough to cope.

    To put this in some kind of context Microsoft small business server comes with everything you need, five user licences and SQL is a low cost add on. Microsoft standard server needs to have exchange, SQL and virtually everything else added to make it any more than just a simple file server. The real catch is in the licenses, each user will need a License to access files, to use exchange and to use SQL. This will cost over £300 per user and nothing is included with the original purchase, if you consider that the same user on small business server would only cost you around £60 and you can see that this soon adds up to a massive revenue increase from Microsoft by emptying your pocket for the same products.

    So why is this news? And what’s the rush? That’s simple, when the current stocks run out, it’s a game over. There are only a few distributors of Microsoft Products and the one we use sold 10% of their remaining stock yesterday. If this carries on then your choices become extremely expensive in about a fortnight’s time.