|
Microsoft SQL Server TechCenterThe SQL Server TechCenter is designed to connect you with SQL Server–related resources from Microsoft and the broader SQL Server community. Top Stories | Service Pack 1 for SQL Server 2005 is now available. Update to SP1 to take advantage of the new features and fixes. |
 | Be more productive with SQL Server Express, now available with Reporting Services, Full Text Search, and a free management tool. |
 | Learn about Microsoft IT experiences with security strategies and with SQL Server 2005 encryption capabilities. |
SQL Server 2005 Technical LibraryLocate technical documentation that has been reviewed and approved by the SQL Server team. You can browse all documentation in the SQL Sever 2005 Books Online in the MSDN Library. Browse 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 ResourcesFind answers in Microsoft newsgroups, locate non-Microsoft communities for SQL Server, join in chats, share best practices and tips with your peers, and get RSS feeds. | |
|
