|
Microsoft SQL Server TechCenterSQL Server is an end-to-end data management and analysis solution that helps you build, deploy, and manage enterprise applications. Featured Resources
Last updated: August 17, 2006
 | Find out about using a SQL Server failover cluster versus a standby server, get information on log shipping, hardware recommendations, and more in the August edition of TechNet Magazine's SQL Server Q&A column.
|
 | The July 2006 update to SQL Server 2005 Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released.
|
 | The SQL Server community connects you with technical resources and people to you help build your skills, resolve an issue, or exchange ideas. |
 | If you plan to build an application and redistribute a database with MSDE, you should use SQL Server 2005 Express Edition. |
SQL Server 2005 Technical LibraryBrowse by Technology | • | Database Engine
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. | | • | 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. SSIS is the new name assigned to the component formerly branded as Data Transformation Services (DTS). | | • | 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 Mobile Edition
Microsoft SQL Server 2005 Mobile 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. |
| Browse by Task | • | Evaluate SQL Server
Determine whether SQL Server 2005 is right for your organization with these helpful product and features overviews. | | • | Getting Started
New to SQL Server 2005? Find sources of SQL Server information, overviews, system requirements, installation instructions, and more. | | • | 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. | | • | Development
Find information developers require to build SQL Server databases and business intelligence solutions, and then enable their applications and Web sites to work with those databases and systems. | | • | Deployment
Plan for the deployment of your SQL Server 2005 databases, applications, and business intelligence solutions. | | • | Security and Protection
Help protect your SQL Server 2005 systems from malicious attacks and improve the security of your data. | | • | 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. | | • | Technical Reference
Find the documentation that covers the behavior of the SQL Server 2005 technologies. | | • | Virtual Labs
Enhance your knowledge and hands-on experience with SQL Server 2005 Technet Virtual Labs.
|
|
Community ResourcesExchange ideas or get tips and tricks from other users of SQL Server. | |
|
