A preliminary study on SQL Server 2008 "Katmai"

Microsoft's next generation of business intelligence platform SQL Server 2008 database, code-named: "Katmai", and published a number of vision and goals.

SQL Server 2008 hopes to become a comprehensive enterprise data and data management platform with a more secure, scalable, and higher management capability. Its functional description is as follows:

1, the protection of database consulting

SQL Server 2008 itself provides the mechanism for encrypting the entire database, datasheet, and log, and the program accesses the encrypted database with no need to modify any programs at all.

2. Spend less time managing operations on the server

SQL Server 2008 will replace the existing script management with a policy based management framework that can take less time to perform routine management and operations. And through the unified policy of policy based, thousands of SQL Server can be managed at the same time to achieve consistency management, DBAs can not have a single SQL Server to set new configuration or management settings.

3. Increase application stability

SQL Server 2008 delivers more stability than SQL Server 2005 in the face of enterprise critical applications, simplifies database failure recovery, and even provides the ability to add additional CPUs or memory without impacting applications.

4. Optimization of system performance and prediction function

SQL Server 2008 will continue to invest in database execution performance and predictive capabilities, not only to further enhance execution performance, but also to add data that can be automatically collected and stored in a central data container, and the system provides a ready-made management report for the information in these containers. Allows DBA managers to compare the system's performance with previous historical performance comparisons, allowing managers to further manage and analyze decisions.