Skip to main content

SQL Server 2005 – Planning and Architecture

Use these articles and white papers to better understand SQL Server 2005 and plan to use it to implement your data storage and business intelligence systems.

Analysis Services

SQL Server 2005 Analysis Services implements a highly scalable and available service for data storage, processing, and security to meet the requirements of the most demanding data systems.

Integration Services

Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high performance data integration solutions, including the extraction, transformation, and loading (ETL) of packages for data warehousing.


SQL Server 2005 replication is a set of solutions that allow you to copy, distribute, and potentially modify data across your enterprise.

Reporting Services

SQL Server 2005 Reporting Services is a new server-based reporting platform that you can use to create and manage tabular, matrix, graphical, and free-form reports that contain data from relational and multidimensional data sources. The reports that you create can be viewed and managed over a Web-based connection.

Notification Services

SQL Server 2005 Notification Services helps you develop and deploy scalable applications that can deliver personalized, timely information updates to a variety of connected and mobile devices.

Service Broker

Microsoft SQL Server 2005 Service Broker helps developers build scalable, secure database applications. This new technology, a part of the Database Engine, provides a message-based communication platform that enables independent application components to perform as a functioning whole. Service Broker includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance as well as for distributed applications.

Full-Text Search

Microsoft SQL Server 2005 contains the functionality you need to issue full-text queries against plain character-based data in SQL Server tables. Full-text queries can include words and phrases, or multiple forms of a word or phrase.

SQL Server Express Edition

Microsoft SQL Server 2005 Express Edition is a free, easy-to-use, and robust database engine that is ideal for building data-driven applications and Web sites.

SQL Server Compact Edition

Microsoft SQL Server 2005 Compact Edition is the compact database for rapidly developing line-of-business and personal information management applications that extend enterprise data management capabilities to smart devices.