The feature-rich SQL Server 2005 release changes the database paradigm by introducing .NET CLR integration, deep XML support, asynchronous messaging, HTTP SOAP access, a new toolset, enhanced business intelligence capabilities, and more. At the same time, a lot of work has been done to enhance the availability, scalability, security, and reliability of the server. This paradigm shift opens up unlimited opportunities for application developers, enabling them to architect and build applications in a way never done before. On the other side, it brings challenges and a new learning curve for DBAs.
This chapter discusses how SQL Server 2005 continues on SQL Server's basic philosophy to be a database management system that can handle the most demanding enterprise applications, be developer friendly, reduce the total cost of ownership, be feature-rich and complete, and be able to run as a lightweight database engine and run on handheld devices.
This chapter also details the upgrades and new features introduced in SQL Server 2005, the challenges it brings, and how to deal with them. Chapter 2, "SQL Server 2005 Architecture and Components," looks at the SQL Server 2005 architecture in more detail.