Microsoft SQL Server 2005 New Features

Chapter 1: Database Architecture and Storage Engine Features

Figure 1-1: Comparing 32-bit and 64-bit memory addressing

Figure 1-2: Data partitioning

Figure 1-3: SQL Server 2005’s object ownership chain

Figure 1-4: SQL Server 2000’s ownership chains

Figure 1-5: SQL Server 2005’s execution context

Chapter 2: Database Administration and Development Tools

Figure 2-1: SQL Computer Manager

Figure 2-2: SQL Server Management Studio

Figure 2-3: SQL Server Management Studio—Solution Explorer

Figure 2-4: SQL Server Management Studio—New Project

Figure 2-5: Business Intelligence Development Studio

Figure 2-6: Business Intelligence Development Studio—New Project

Figure 2-7: Query Editor Showplan

Figure 2-8: Database Tuning Advisor

Chapter 3: Availability and Recovery Features

Figure 3-1: Eight-node cluster support

Figure 3-2: Database Mirroring

Figure 3-3: Database Snapshots

Figure 3-4: Database Mirroring and Database Snapshot create a reporting server

Figure 3-5: Early restore access

Chapter 4: Programmability Features

Figure 4-1: Creating a New SQL Server Project with Visual Studio 2005

Figure 4-2: The SQL Server .NET Data Provider Reference

Figure 4-3: Adding a CLR stored procedure

Figure 4-4: Adding a CLR user-defined function

Figure 4-5: Adding a CLR trigger

Figure 4-6: Creating a .NET SQL Server UDT

Figure 4-7: Adding a user-defined aggregate

Chapter 5: Notification Services

Figure 5-1: Notification Services overview

Figure 5-2: Notification Services architecture overview

Figure 5-3: The New Notification Services Instance dialog

Chapter 6: SQL Server Service Broker

Figure 6-1: Queued application design

Figure 6-2: SQL Server Service Broker dialog

Figure 6-3: SQL Server Service Broker conversation group

Figure 6-4: SQL Server Service Broker metadata

Chapter 7: XML Integration

Figure 7-1: An overview of OPENXML

Chapter 8: Reporting Services

Figure 8-1: Reporting Services overview

Figure 8-2: Reporting Services Report Designer

Figure 8-3: Report Designer Fields Window

Figure 8-4: OLAP Report Designer

Figure 8-5: Report Server overview

Figure 8-6: Reporting Services Report Manager

Figure 8-7: Creating a new report: New Project

Figure 8-8: The Report Wizard Welcome dialog

Figure 8-9: Select the Data Source

Figure 8-10: Query Builder

Figure 8-11: Select the report type

Figure 8-12: Design the table

Figure 8-13: Choose the table style

Figure 8-14: Completing the wizard

Figure 8-15: Deploying the Reporting Services solution

Figure 8-16: Accessing Reporting Services reports from a URL

Figure 8-17: Running Reporting Services reports

Figure 8-18: Drilling down into the report

Chapter 9: Integration Services

Figure 9-1: Integration Services architecture

Figure 9-2: Data Transformation Pipeline components

Figure 9-3: Data Transformation Runtime overview

Figure 9-4: Integration Services package overview

Figure 9-5: Integration Services Import/Export Wizard—Data Source Selection

Figure 9-6: Integration Services Import/Export Wizard—Package Execution

Figure 9-7: Opening a data transformation project

Figure 9-8: Control Flow Designer

Figure 9-9: Connection Manager

Figure 9-10: Data Flow Designer

Figure 9-11: Running the package inside the Designer

Figure 9-12: The Package Explorer

Figure 9-13: Configuration Wizard

Figure 9-14: The dtexecui tool

Chapter 10: Analysis Services

Figure 10-1: The unified dimensional model

Figure 10-2: SQL Server Computer Manager

Figure 10-3: SQL Server Management Studio MDX Editor

Figure 10-4: Creating a data source view

Figure 10-5: Data Source View Designer

Figure 10-6: Cube Wizard

Figure 10-7: Identify Fact and Dimension Tables

Figure 10-8: Select Measures

Figure 10-9: The Cube Editor

Figure 10-10: The Cube Browser

Figure 10-11: Profiling Analysis Services

Figure 10-12: XMLA connects clients to Analysis Services

Appendix A: Installation and Upgrading

Figure A-1: SQL Server 2005 installation splash screen

Figure A-2: SQL Server Component Update

Figure A-3: Welcome to the SQL Server Installation Wizard

Figure A-4: System Configuration Check

Figure A-5: Components To Install

Figure A-6: Feature Selection

Figure A-7: Instance Name

Figure A-8: Service Account

Figure A-9: Authentication Mode

Figure A-10: Collation Settings

Figure A-11: Report Server Virtual Directories

Figure A-12: Report Server Database Setup

Figure A-13: Report Server Delivery Settings

Figure A-14: Error Reporting

Figure A-15: Ready To Install

Figure A-16: Installation Progress