SQL Server 2005:13 Things you should know

New features of SQL Server 2005

1. New Product Version

In addition to the SQL Server 2005 Standard Edition and Enterprise Edition, the product line is also joined by a simplified version of SQL Server 2005 (SQL Server Exdivss) and the Workgroup Edition (SQL Server Workgroup) two new versions.

SQL Server exdivss--is a replacement for the Microsoft SQL Server Desktop Engine (Microsoft SQL Server Desktop engine,msde). SQL Server Exdivss can be used for free publishing and uses the same relational database core engine as SQL Server. The difference is that it does not use the query manager like MSDE. The only limit is a cpu,1g memory and 4G of storage space per database.

The SQL Server 2005--Workgroup Edition is not freely released. It is designed to focus on Server Message Block Protocol (SMB) and divisional solutions. In quantitative performance, it is better than SQL Server Exdivss and provides support for relational databases, but lacks analysis services. Workgroup Edition limited to two cpu,3g memory, database size unlimited.

2. The new subsystem

With the help of some new subsystems, application support in SQL Server 2005 is very powerful, including consolidation services, reminder services, service agents, and Reporting Services.

Consolidation services-600% faster than DTS, which was previously responsible for this functionality. SQL Server Consolidation Services is an enterprise-class ETL platform with powerful workflow control capabilities.

Reminder Service-Provides an application framework to build custom reminders.

Service Broker-provides asynchronous process processing for establishing a highly quantifiable program.

Reporting Services-This is a feature that is most worth upgrading. Reporting Service is an enterprise-level report generation platform that allows detailed reporting of design, distribution, and sales. The powerful Reportbuilder component enables end users to also enjoy Reporting Services.

3. Consolidate the new. NET Framework

The biggest hardening of SQL Server 2005 is the consolidation of the. NET Framework. Enable the new. NET consolidation features, you can easily create stored procedures, functions, triggers, custom types, and custom data sets. You can be in any. NET language, use the exec sp_configure ' clr enabled ', ' 1 ' command to enable CLR support. If you are still using a previously managed extended stored procedure, you should immediately replace it with a SQLCLR stored procedure.