SQL Server is a Platform vision that helps your organization to manage any data, any place, and any time. By using SQL server you may store data from structured, semi-structured, and unstructured documents, such as music and images, directly in the database. SQL Server delivers a rich set of integrated services that allows you to do more with your data such as query, synchronize, search, report, and analyze. Your information can be stored and accessed in your largest servers within the center all the way down to desktops and mobile devices; manipulation is done from anywhere, no matter where the data is to be stored.
Features of SQL server:
Recourse Governor: It is the most important new feature in SQL Server 2008, which lets you manage the amount of system resources that SQL Server will assign to a given work set. Such as, the Resource Governor will improve the overall performance by limiting the system resources consumed by poorly designed end-user queries.
Data compression: It can reduce the size of database data stored on disk and can also radically decrease backup and restore times by reducing the required I/O.
Client/ server applications are also scalable and cost effective. As we know data is a most valuable resource in organization. SQL server also offers security and improving performance by using retrieve technology.
SQL server holds clustering and mirroring of databases. Basically, SQL server cluster is no. of servers that are configured identically. Workload is distributed among all these clustered servers. There is an identical virtual server name given to all of the servers so that it is made into the IP address. Data partitioning is also supported by this kind of server.
Author : Lucian Paun