Microsoft SQL Server

SQL Server is the foundation of Microsoft’s data platform, delivering mission-critical performance with in-memory technologies and faster insights on any data, whether on-premises or in the cloud.

Streamlined Installation

Microsoft SQL Server 2008 can be installed using “setup wizards”; the installer also detects, downloads and installs any required prerequisite updates. These features reduce the complexity of installing the software. Individual components such as Database Services, Analysis Services and Integration Services can be installed separately.SQL Server 2008 automatically updates security patches to reduce maintenance costs.

Better Performance Features

Microsoft SQL Server 2008 has transparent data compression and encryption built in. There is no need to modify or change programs to encrypt data. SQL Server 2008 has more efficient access control and permission management tools and offers better performance in data collection. SQL Server 2008 also integrates with Microsoft Office.Even though SQL Server 2008 supports databases up to 524 terabytes (TB), its data compression features can reduce the database size. Backup databases can also be compressed.

Better Security Features

SQL Server 2008 has strong authentication and access protection and has better password management features to enforce stronger passwords and frequent changing of passwords.SQL Server 2008 uses Policy-Based Management to detect non-compliance security policies, which allows only authorized personnel access to the database.Security audits and events can be written automatically to log files.