SQL Server 2005 – Planning and Architecture

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.

• Usage Scenarios for Notification Services
  
• Notification Services Architecture
  
• International Considerations for Notification Services
  

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.

• MSDN Magazine: Building the MSDN Aggregation System with SQL Server Service Brokerp
  
• MSDN Architecture Webcast: Using Service Broker in SQL Server 2005 Express Edition for Reliable Service-Oriented Architecture (SOA) Implementations (Level 300)
  
• Architecting Service Broker Applications
  
• Planning, Implementing, and Administering Scaleout Solutions with SQL Server 2005
  
• Service Broker Architecture
  
• Service Broker Routing and Networking
  
• International Considerations for Service Broker
  
• Service Broker Scalability
  

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.

• Full-Text Search Architecture
  
• Full-Text Search Concepts
  
• International Considerations for Full-Text Search
  

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.

• Networking in SQL Server Express
  
• Upgrading from SQL Server 2005 Express Edition to Workgroup or Standard Editions
  

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.

• SQL Server Compact Edition Architecture
  
• Working With Databases (SQL Server Compact Edition)
  
• Data Storage Architecture with SQL Server 2005 Compact Edition