text.skipToContent text.skipToNavigation
  1. Home
  2. Computer Science & IT
  3. Microsoft SQL Server 2005: Changing the Paradigm

Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition), 1st edition

Published by (August 30th 2005) - Copyright © 2006

1st edition

Microsoft SQL Server 2005: Changing the Paradigm

ISBN-13: 9780132799010

Includes: Instant Access

This product is not available in your country

What's included

  • Instant Access

    You'll get instant access to the digital content.

Overview

Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) will prepare database administrators for upcoming changes in SQL Server 2005. Obtain the skills necessary to run SQL Server 2005 from the experts at Microsoft Gold Partner. Get a head-start to understanding the new concepts and features of SQL Server 2005 from the database administrator's perspective, including:

  • SQL Server 2005 Architecture
  • Tool Sets
  • Scalability, Reliability and High Availability Chapter
  • Performance Tuning
  • Replication
  • .NET CLR Integration
  • DTS and Business Intelligence
Minimize the surprises in SQL Server 2005 with the help of Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition).

Table of contents

1. Changes in the Database Paradigm: How SQL Server 2005 Redefines the Role of a DBA.

    SQL Server Philosophy

    Enterprise Suitability

    Developer Friendliness

    Cost of Ownership

    Completeness

    Ubiquity

    History

    SQL Server 2005 and Database Administrators

    One Small Step for a DBA

    A Giant Leap for DBA-kind

    Where No One Has Gone Before

2. SQL Server 2005 Database Engine Architectural Changes.

    The SQL Server Operating System (SQLOS)

    User Mode Scheduler (UMS)

    Introducing SQLOS

    Non-Uniform Memory Access (NUMA) Architecture Support

    Query Optimization and Execution

    Statistics Management in SQL Server 2005

    Statement-Level Recompilation

    Calculating Query Plan Cost

    Parallel Query Processing

    Row Versioning

    System Metadata Access and the Security Architecture

    The Resource Database

    Metadata Access and Visibility

    User-Schema Separation

    Storage Engine and I/O Changes

3. SQL Server 2005 Setup and Deployment.

    SQL Server 2005 Editions

    Hardware and Software Requirements for Installing SQL Server 2005

    SQL Server 2005 Enterprise Edition 32-Bit Requirements

    SQL Server 2005 Enterprise Edition 64-Bit Requirements

    SQL Server 2005 Setu

For teachers

All the material you need to teach your courses.

Discover teaching material