Skip to main content

SQL Server 2005 - Operations

Learn about SQL Server 2005 administration and operations tasks such as troubleshooting, backup/restore, configuring failover clusters, and monitoring for performance and system heath.

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.

Replication

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.