Chapter 7 - Your First Script Component
ISBN: 1932577211    Authors: Donald Farmer   (Wednesday, July 06, 2005)
The Integration Services feature of Microsoft® SQL Server 2005 brings together data from diverse sources in a high-performance data integration platform, to enable users to work across multiple applications that may not have been designed to cooperate. In The Rational Guide To Scripting SQL Server 2005 Integration Services Beta Preview, Donald Farmer, Microsoft's Group Program Manager for SQL Server Integration Services, clearly explains how to build practical and useful scripts for this exciting new SQL Server 2005 feature.

Mastering the Script Component can be your key to a vast range of data integration functionality. Script components are versatile. They are easy to add to your Data Flow, quite simple to program, and give excellent performance. Add to that the power of visual debugging and you can see why they are such an exciting feature of SSIS.
www.YukonXML.com/chapters/mann/SSIS/

Chapter 2 - Conversations
ISBN: 1932577203    Authors: Roger Wolter   (Wednesday, July 06, 2005)
Conversations are one of the fundamental concepts of Service Broker. There are two types of conversations (monologs and dialogs), but only dialogs are included in SQL Server 2005. A dialog is a reliable, two-way, ordered, persistent exchange of messages between two endpoints. The fundamental communications primitive for most messaging systems is a message. For Service Broker, the messaging primitive is the dialog.
www.YukonXML.com/chapters/mann/ServiceBroker/

Chapter 3 - SQL Server 2005 Express Tools
ISBN: 1932577165    Authors: Anthony Mann   (Wednesday, July 06, 2005)
SQL Server 2005 Express includes useful tools for managing services, networking protocols, configurations, and more.

The SQL Server Configuration Manager tool contains a SQL Server 2005 Services node (which lists services for your server), a SQL Server 2005 Network Configuration node (which lists networking configurations), and a SQL Native Client Configuration node (which lists configurations for SQL Native Client connections).

Another tool is Express Manager, or XM, which lets you graphically manage the objects in a SQL Server Express 2005 instance, such as databases, tables, views, stored procedures, and more.

The SQLCMD tool allows you to use the command line to issue commands against a SQL Server 2005 instance. It also allows a dedicated administrative connection, so that your commands are not affected by slow server performance.


www.YukonXML.com/chapters/mann/Express/

Chapter 2: SQL Server Management Studio from the book SQL Server 2005 Revealed
ISBN: 1590593855    Authors: Tony Bain, Robin Dewson   (Thursday, July 29, 2004)
With SQL Server 2005, it is a brave new world for DBAs when it comes to server management. One of the design goals for SQL Server 2005 was to change the way that DBAs interact with and manage the database server. Read this chapter to learn about SQL Server Management Studio, SQLCMD, SMO, SQLiMail, and other enhancements introduced in SQL Server 2005.
www.YukonXML.com/chapters/apress/ss2005revealed/mgmtstudio/

Chapter 7 - T-SQL Enhancements from the book A First Look at SQL Server 2005 for Developers
ISBN: 0321180593    Authors: Bob Beauchemin   (Wednesday, July 21, 2004)
SQL SERVER 2005 includes new Transact-SQL (T-SQL) functionality. The enhancements span the range from an alternative mechanism for transaction isolation to declarative support for hierarchical queries. And statement-level recompilation even improves existing T-SQL applications that were written before 2005.

Microsoft has continually improved the Transact SQL language and the infrastructure of SQL Server itself. In brief, the improvements include SNAPSHOT isolation, Statement-level recompile, Event notifications, Large data types, DDL triggers, Common Table Expressions, Hierarchical queries, PIVOT, Transaction abort TRY/CATCH functionality, and more.
www.YukonXML.com/chapters/aw/sql2005dev/

Chapter 5: Using Custom .Net Code with Reports from book "Pro SQL Server Reporting Services" published by APress
ISBN: 1590594231    Authors: Rodney Landrum, Walter J. II Voytek   (Monday, July 19, 2004)
SQL Reporting Services offers the software developer a variety of options when it comes to customizing reports through the use of code. These options give the software developer the ability to write custom functions using .NET code that can interact with report fields, parameters and filters in much the same was as any of the functions that come "built in". This gives the developer the ability to extend the capabilities of SRS far beyond those that are available out of the box.
www.YukonXML.com/chapters/apress/reportingservices/dotnet/

Chapter 2: Report Authoring – Best Practices from book "Pro SQL Server Reporting Services" published by APress
ISBN: 1590594231    Authors: Rodney Landrum, Walter J. Voytek II   (Monday, July 12, 2004)
SQL Reporting Services provides a platform for developing and managing reports in an environment that includes multiple data sources of information. Obtaining the data from these disparate data stores is facilitated by standards such as OLE DB, LDAP, and ODBC. SQL reporting Services, henceforth referred to as SRS in the book, uses Visual Studio as the main report authoring environment to produce a Report Definition Language file or RDL. We will be working extensively in this environment throughout the book to build a reporting solution for our company. Before we introduce all of the many elements of the reporting environment, it is important to begin with the heart of any data-driven report, whether it is Crystal Reports, SRS, or Microsoft Access, and that is the query. With any report design application, the underlying data connection and query to produce the desired data is fundamental. Developing a query that returns the desired data efficiently is the key to a successful report.
www.YukonXML.com/chapters/apress/reportingservices/bestpractices/

Chapter 1 - An Overview of SQL Server Reporting Services from book "The Rational Guide To SQL Server Reporting Services"
ISBN: 0972688897    Authors: Anthony T. Mann   (Monday, March 01, 2004)
SQL Server Reporting Services is a set of innovative components and services that are part of Microsoft's overall Business Intelligence strategy. Business Intelligence is, quite simply, the ability to use technology to make better business decisions. These business decisions stem from an understanding of the vast amounts of data existing not only in large companies, but in small to medium-sized companies as well. In the past, many software vendors, including Microsoft, have targeted large companies for their Business Intelligence software.
www.YukonXML.com/chapters/mann/reportingservices/

Chapter 4 - New Development Features from the book "SQL Server 2005 New Features" published by McGraw-Hill/Osborne
ISBN: 0072227761    Authors: Michael Otey   (Monday, March 01, 2004)
The new development features that are found in SQL Server Yukon are the accumulation of many years' worth of effort by both the SQL Server development team and the .NET Framework development team. The most significant of these new development-oriented features is the integration of the .NET Common Language Runtime (CLR). The integration of the CLR brings with it a whole host of new capabilities, including the capability to create database objects by using any of the .NET-compatible languages, such as C#, VB.NET, and Managed C++. This chapter begins by introducing you to those new .NET CLR features and showing you some samples of how they are used. Next, the chapter addresses a topic that's more familiar to SQL Server DBAs and developers: the new features found in T-SQL. Finally, the chapter takes a walk on the client side and presents some of the new features found in the updated .NET Framework Data Provider for SQL Server that ships with SQL Server Yukon.
www.YukonXML.com/chapters/osborne/devfeatures/