Pro SQL Server 2005

1. Front Matter

   Pages i-xxvii

   PDF

2. SQL Server Overview and Installation

   Pages 1-23

3. SQL Server Management Technologies

   Pages 25-52

4. T-SQL Enhancements for Developers

   Pages 53-101

5. T-SQL Enhancements for DBAs

   Pages 103-133

6. .NET Integration

   Pages 135-159

7. Programming Assemblies

   Pages 161-206

8. SQL Server and XML

   Pages 207-245

9. SQL Server 2005 XML and XQuery Support

   Pages 247-286

10. SQL Server 2005 Reporting Services

    Pages 287-346

11. Analysis Services

    Pages 347-385

12. Security

    Pages 387-417

13. Service Broker

    Pages 419-457

14. Automation and Monitoring

    Pages 459-505

15. Integration Services

    Pages 507-565

16. Database Mirroring

    Pages 567-607

17. Notification Services

    Pages 609-643

18. Back Matter

    Pages 645-674

    PDF

SQL Server 2005 is a dramatically expanded and enhanced version of SQL Server 2000 that not only makes SQL Server a true enterprise-level RDBMS, but also changes how SQL Server professionals design databases and develop database applications.

Pro SQL Server 2005 provides in-depth coverage of new SQL Server features and enhancements. It focuses on what experienced SQL Server database administrators, developers, and business intelligence practitioners need to know to get up to speed with SQL Server 2005 as quickly as possible. It carefully presents each new feature and precisely illustrates the feature with examples that show you how to use it effectively.

The authors provide practical, in-depth coverage of the core topics that they specialize inall supported by realistic examples, so you'll be able to design and implement your own SQL Server 2005 solutions quickly and painlessly. This book is a roadmap for exploring and exploiting SQL Server 2005. So fasten your seatbelts, start your computers, and race to mastery of SQL Server 2005!

• .NET
• Extensible Markup Language (XML)
• RDBMS
• SQL
• SQL Server 2000
• SQL Server 2005
• T-SQL
• XML
• XPath
• XQuery
• reporting

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Policies and ethics