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
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
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
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
Figure 5-1: Notification Services overview
Figure 5-2: Notification Services architecture overview
Figure 5-3: The New Notification Services Instance dialog
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
Figure 7-1: An overview of OPENXML
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
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
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
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