
SQL Server
What is it?
SQL Server is a database engine used to store data. Unlike Microsoft Access (which can also store data), it does not come with tools to input or display data. That is done via web pages LINK that connect to the database or a program written using a program like Visual Studio by a developer that connects to the database.
What does it do?
The SQL Server program can run many databases. Perhaps one department of your company needs a database for their purposes only. A different department also needs one for a completely different purpose that has nothing to do with the other department.
Versions
It's possible you already have it without realising it! SQL Server comes with different versions of Windows Server.
There are different versions:
- The Enterprise version is aimed at large companies that need to run many databases. As you can imagine, its price is large too!
- Standard version is for small to medium sized companies. It has a medium sized price.
- Express version has some limitations. These may not affect you even in the largest of companies.
The best bit is that this is free!
What do we do with it for you?
- Install it and set it up.
- Create databases!
- Normally we also create the tools for you to interact with it too. Be they web sites LINK,
Access front ends or Windows applications LINK????.
See also SQL Server Reporting Services (SSRS) and
SQL Azure.