لطفا منتظر باشید ...
Introduction
Part I of this book covers the database administration features. Here you’ll learn about the features that are most important to the database administrator. In this section you’ll get an introduction to the new SQL Workbench, which gives the SQL Server database administrator a whole new management experience. In addition in Part I you’ll also learn about the new important security, architectural, high availability, and disaster recovery features the Microsoft has provided in SQL Server 2005. Part II covers the new features found in the database development area. As you would expect if you’ve read anything about Yukon (the codename for the SQL Server 2005 release), in the press, then you’ve certainly heard that the biggest change found in SQL Server 2005 is the integration of the Microsoft .NET Common Language Runtime (CLR) with the SQL Server 2005 database engine. SQL Server’s CLR integration allows any of the .NET languages like C#, Visual Basic.NET or managed VC++ to be used to write stored procedures, triggers, and user-defined functions. Part II of this book provides thorough coverage of these new features showing both how you write CLR-based database objects as well as how you incorporate them into the database and where they are best utilized. Additionally, the chapters in Part II will go on to cover the new SQL Notification Services, the SQL Broker Service and the improved XML integration features. Part III hits the last big area of enhancements found in Microsoft SQL Server 2005. In Part III you can learn about the new Business Intelligence (BI) features. The BI area for SQL Server 2005 has some of the richest new features found in the new release. For instance, with SQL Server 2005, the new SQL Service Reporting Services feature is included as an integral part of the base SQL Server package and one of the chapters in this section will guide you through the use of its graphical report designer as well as exploring SQL Server Reporting Service’s rich report formatting and deployment features. Integration Services, the replacement for Data Transformation Services (DTS) has also been totally revamped in SQL Server 2005. First introduced with SQL Server 7, DTS has become a cornerstone of both the data warehousing extraction-transformation-load (ETL) function as well as the primary vehicle for moving data between SQL Server and other platforms. With the SQL Server 2005 release Integration Services has been rewritten from the ground up all in managed code and one of the chapters in Part III goes into to detail about the new changes that you’ll find in the new Integration Services. If that weren’t enough, Part III will also introduce you the new feature found in SQL Server’s Analysis Services and data mining features.As you can see there’s a lot to cover and the SQL Server 2005 has more new features that any previous release of SQL Server.
