Michael Otey & Denielle Otey
SQL Server 2005 is a feature-rich release that provides a host of new tools and technologies for the database developer. This book is written to help database developers and DBAs become productive immediately with the new features and capabilities found in SQL Server 2005. This book covers the entire range of SQL Server 2005 development technologies from server side development using T-SQL to client side development using ADO, ADO.Net, and ADOMD.NET. In addition, it shows how to develop applications using the new SQL Server 2005 Notification Services, SQL Server Service Broker, Reporting Services, and SQL Server Integration Services subsystems.
The development management landscape for SQL Server 2005 has changed tremendously in SQL Server 2005, so Chapter 1 starts off by providing a guided tour of the new development and management tools in SQL Server 2005. Although SQL Server 2005 certainly embodies a huge number of significant changes, some things have stayed the same and one of those things is the fact that T-SQL is still the native development language for SQL Server 2005 and is the core for all SQL Server 2005 database development. Chapter 2 shows you how to use the new T-SQL development tools found in both SQL Server 2005 and Visual Studio 2005 as well as how to create both T-SQL DDL and DML solutions. Chapter 3 dives into the new SQL CLR integration capabilities of SQL Server 2005. The integration of the .NET CLR runtime with SQL Server 2005 is one of the biggest new changes in SQL Server 2005. This chapter shows you how to create and use all of the new SQL CLR database objects, including stored procedures, functions, triggers, user-defined types, and user-defined aggregates. Chapter 4 introduces the new SQL Server Service Broker subsystem that provides the basis for building asynchronous applications. Both the SQL Service Broker chapter and the Notification Services chapter (Chapter 5) provide an overview of the new subsystem and then go on to show how they are used in a sample application. ADO.NET is Microsoft’s core data access technology, and Chapter 6 illustrates how to use all the primary ADO.NET objects to create robust data applications. The integration of XML with the relational database engine is another one of the big enhancements in SQL Server 2005. Chapter 7 shows how to use the new XML data type for both typed and untyped data as well as how to create Web Services that expose SQL Server stored procedures for heterogeneous platform integration. While most of this book concentrates on the newest .NET and XML-based technologies, the majority of SQL Server client applications are written in ADO and VB6. Chapter 8 illustrates all of the primary ADO techniques for building SQL Server database applications. Two of the hottest technologies in SQL Server 2005 are Reporting Services and the end-user oriented Report Builder report designer application.
Chapter 9 dives into both of these new features, showing you how to build reports using Reporting Services as well as how to set up data models for use with Report Builder.
Chapter 10 introduces the new SQL Server Integration Services subsystem. SQL Server Integration Services completely replaces the older DTS subsystem, and this chapter shows you how to build and deploy SSIS packages using the designer and the SSIS API.
Chapter 11 illustrates building client Business Intelligence applications for Analysis Services using the new ADOMD.NET data access programming framework. SQL Server 2005 also introduces another completely new management framework called System Management Objects (SMO), which replaces the older Distributed Management Objects (DMO) object framework that was used in earlier versions of SQL Server. In Chapter 12 you can see how SMO can be used to build your own customized SQL Server management applications. SQL Server 2005 also provides an entirely new command line interface called sqlcmd that replaces the older isql and osql utilities. In Chapter 13 you can see how to develop management and data access scripts using the sqlcmd tool. Finally, this book concludes with an introduction to using SQL Profiler. SQL Profiler is key tool for both troubleshooting application performance as well as fine-tuning your data access queries.
All of the code presented in this book is available for download from McGraw-Hill/ Osborne’s web site at www.osborne.com, and from our web site at www.teca.com.
For Download:
Click Here
