- SQL Server 2008 offers administrators new and improved features that allow more control to manage over large and complex database environments as well as servers.
- SQL Server 2008 has built-in compression that permits compression of the database files and the transaction log files associated with the compressed database.
- SQL Server 2008 addresses the negative issue of locks that occur during the performance of a large number of transactions. SQL Server 2008 teams up with the table partitioning mechanism to permit the SQL Server engine to escalate locks to the partition level before the table level, which can dramatically decreases the effect of lock escalation on systems responsible for thousands of transactions per second.
- In SQL Server 2005, database mirroring is an offered solution to administrators to achieve high availability. With SQL Server 2008, improvements are incorporated to the database mirroring process which greatly enhances this process.
- Although SQL Server 2005 introduced data security in the form of data encryption, SQL Server 2008 greatly enhanced the capability with Extensible Key Management and Transparent Data Encryption. The Extensible Key Management allows for an enhanced structure to safely store the keys used in the encryption infrastructure. The encryption infrastructure includes inside the database as well as outside the database in third party software modules or with a Hardware Security Module. Transparent Data Encryption provides a vast improvement in the flexibility for encrypting data by permitting encryption to be a property of the database and not just the result of function in a line of code.
- Advertisement -
- Advertisement -