SQL SERVER

Most of times, techies know about tech terms but layman does not understand head or tails out of tech terms. I would attempt to explain the tech concepts in layman terms!

Any database server which uses the structured query language is known as SQL Server. Microsoft SQL Server is a Relational Database Management System (RDBMS). SQL Server is mainly used as the backend system for websites development and corporate CRMs development and can support thousands of concurrent users. MS SQL Server is more scalable than MS Access. SQL Server 2005 well integrate with .Net framework.

As it allows multiple users to access the same data simultaneously so Server based database systems are designed to run on a central server. The users normally access the database through an application. Basically the application provides the functionality to the users and it’s the database which stores all the data and makes it accessible.

Now I will be discussing about the latest version of SQL Server i.e. SQL Server 2008. SQL Server 2008 allows organization or user to maintain data in structured, semi structure, and unstructured documents such as any image or media file in the database. By SQL Server the user can create, store and update data which implies that SQL Server 2008 is very easy to use. SQL Server 2008 is very scalable, reliable and secured for business application. It is so flexible that it can access data from largest server to mobile devices. There are different editions of SQL Server such as Enterprise Edition, Standard Edition, Workgroup Edition, Developer Edition, Web Edition, Express Edition, Compact Edition, and Evaluation Edition. SQL Server supports the ADO.Net entity framwork too.

I hope this information is useful for you. But you have to read lot about it.

References

http://en.wikipedia.org/wiki/Microsoft_SQL_Server

http://www.microsoft.com/sqlserver/2008/en/us/overview.aspx

http://www.quackit.com/sql_server/sql_server_2008/tutorial/sql_server_editions.cfm