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.
The SQL Server 2005 database engine implements a highly scalable and available service for data storage, processing, and security to meet the requirements of the most demanding data systems.
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.
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.
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.
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.
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 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.
SQL Server 2005 replication is a set of solutions that allow you to copy, distribute, and potentially modify data across your enterprise.
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.