2.What Is New‎ > ‎MSSQL‎ > ‎

MSSQL 2005

1.1       New Features

1.1.1        New Service Broker

Service Broker is a new technology for building database-intensive applications that are secure, reliable, and scalable. Service Broker provides message queues the applications use to communicate requests and responses.

1.2       Enhancement

1.2.1        Notification Services Enhancements

Notification Services is a new platform for building highly-scaled applications that send and receive notifications. Notification Services can send timely, personalized messages to thousands or millions of subscribers using a wide variety of devices.

1.2.2        Reporting Services Enhancements

Reporting Services is a new server-based reporting platform that supports report authoring, distribution, management, and end-user access.

1.2.3        Database Engine Enhancements

The Database Engine introduces new programmability enhancements such as integration with the Microsoft .NET Framework and Transact-SQL enhancements, new XML functionality, and new data types. It also includes improvements to the scalability and availability of databases.

1.2.4        Data Access Interfaces Enhancements 

SQL Server 2005 introduces improvements in the programming interfaces used to access data in SQL Server databases. For example, the SQL Native Client data access technology is new, and the .NET Framework Data Provider for SQL Server, also referred to as SqlClient, is enhanced.

1.2.5        Analysis Services Enhancements (SSAS)

Analysis Services introduces new management tools, an integrated development environment and integration with the .NET Framework. Many new features extend the data mining and analysis capabilities of Analysis Services.

1.2.6        Integration Services Enhancements

Integration Services introduces a new extensible architecture and a new designer that separates job flow from data flow and provides a rich set of control flow semantics. Integration Services also provides improvements to package management and deployment, along with many new packaged tasks and transformations.

1.2.7        Full-Text Search Enhancements

This section describes the programmability enhancements that have been made to Full-Text Search. These enhancements include the data definition language for Full-Text Search and the ability to specify languages in queries other than the default language, and the manageability enhancements, such as side-by-side installs, backup and restore full-text catalogs, and attach and detach full-text catalogs.

1.2.8        Replication Enhancements

Replication offers improvements in manageability, availability, programmability, mobility, scalability, and performance.

1.2.9        Tools and Utilities Enhancements

SQL Server 2005 introduces an integrated suite of management and development tools that improve the ease-of-use, manageability, and operations support for large scale SQL Server systems.

1.3       Major Bug Fixes


1.4       Additional Notes