Microsoft SQL Server 2005: The Complete Reference: Full Coverage of all New and Improved Features
Microsoft SQL Server 2005: The Complete Reference: Full Coverage of all New and Improved Features
ISBN: 0072261528
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 239
Pages: 239
Authors: Jeffrey Shapiro
- Table of Contents
- Back Cover
- Microsoft SQL Server 2005-The Complete Reference
- Introduction
- A Book for All Teammates
- Whats Inside
- Work in Progress
- Part I: SQL Server 2005 System and Platform Architecture
- Chapter 1: Getting to Know SQL Server 2005
- Line-of-Business Applications
- The Distributed Network Application
- So, What Is SQL Server 2005?
- Central Design Themes
- Overview of the Core Architectures
- The Collateral Services
- Chapter 2: Database Architecture
- Introduction to SQL Server Databases
- The Logical Database Architecture
- The Physical Database Architecture
- The Network Ahead
- Chapter 3: RDBMS Architecture
- The TPC Benchmarks
- An Overview of the DBMS Components
- The Relational Database Engine
- Memory Architecture
- SQL Server I0 Architecture
- SQL Servers Thread and Task Architecture
- SQL Server Transaction Architecture
- Reading and Writing the Data Pages
- SQL, Query Optimization, and Query Processing
- Inside Data Streams, Again
- Pulling the Relational Train
- Chapter 4: Connecting to and Administering the Database Engine
- Connecting to SQL Server
- SQL Server 2005 Administrative Architecture
- Introducing SQL Server Tools
- Getting Started with SQL Server Management Studio
- SQL Servers Automated Administration Architecture
- SQL Server Agent
- Using the SQL Server Agent
- Configuring SQL Servers Mailing Engines
- Maintenance Plans
- The Network Ahead
- Part II: Administering SQL Server 2005
- Chapter 5: Security
- Data Security Primer
- SQL Server Access
- Kerberos Tickets: The Keys to Trusted Access
- Secure Sockets Layer
- Microsoft Certificate Services
- Trusted Access Versus Nontrusted Access
- SQL Server Security: The Internal Environment
- Managing SQL Server Security
- Auditing
- The SQL Server Security Plan
- In Review
- Chapter 6: Databases, Tables, and Indexes
- The New SQL Server 2005 File System
- Understanding Filegroups
- Creating a SQL Server Database
- Tables
- Moving Data, Log, and Full-Text Files
- Indexes
- Performance, Optimization, and Tuning
- In Review
- Chapter 7: SQL Server Disaster Recovery
- Establishing Baselines for Disaster Recovery
- Transaction Recovery
- SQL Server 2005 Recovery Architecture
- SQL Server 2005 Backup and Restore Architecture
- Types of Database Backups for SQL Server 2005
- Backup Devices
- Backing Up SQL Server
- SQL Server Backup Bandwidth
- SQL Server Backup by Design
- Creating a Backup Maintenance Plan
- In Review
- Chapter 8: Distributed Database Architecture
- SQL Server 2005 Replication Services
- Types of Replication
- Understanding the Replication Options
- Getting Started with Replication
- Designing a Replication Topology
- Standby Servers
- Log Shipping
- Mirroring
- Resolving Mirror Errors
- Fail-Over
- In Review
- Chapter 9: SQL Server 2005 High Availability
- Availability Management
- Understanding Scale-Up
- SQL Server 2005 Scale-UpScale-Out
- Understanding the Microsoft Cluster Models
- Limitations of Server Clusters
- SQL Server 2005 Server Clustering
- In Review
- Part III: Programming SQL Server 2005
- Chapter 10: Transact-SQL Primer
- T-SQL: Basic Concepts
- T-SQL Constants
- T-SQL Expressions
- T-SQL Operators
- T-SQLVariables
- T-SQL Functions
- T-SQL Flow-Control
- Identifiers
- Moving On
- Chapter 11: Understanding the SQL Server Common Language Runtime
- Getting to Know the Frameworks Runtime
- The Common Language Runtime
- Understanding Assemblies
- The .NET Security Model
- Working with the SQL Server Base Class Library
- Getting Started with the CLR
- Going Further
- Chapter 12: Data Integrity
- Understanding SQL Server Data Integrity
- Planning Integrity
- Configuring and Programming Integrity
- The Constraints Syntax
- User-Defined and Alias Data Types
- In Review
- Chapter 13: Triggers
- Triggers
- The Nuances of Triggers
- Trigger Execution Types
- The Trigger Plan
- Creating Triggers
- Programming the Trigger
- The Examples
- Deferred Name Resolution
- First and Last Triggers
- Trigger Recursion
- Trigger Nesting
- Rolling Back Trigger Transactions
- Managing Triggers
- Final Words on Developing Triggers
- Putting Triggers to Good Use
- To Recap
- Chapter 14: Stored Procedures and Functions
- The Nuances of Stored Procedures
- The Stored Procedure Plan
- Creating Stored Procedures
- Calling Stored Procedures
- Sending Data to Stored Procedures
- Receiving Data from Stored Procedures
- Stored Procedure Nesting
- Rolling Back Stored Procedures
- Temporary Stored Procedures
- Warming Up SQL Server
- Managing Stored Procedures
- The Example
- User Defined Functions in T-SQL
- Procedures and Functions on the CLR
- To Recap
- Part IV: Working with SQL Server 2005
- APPENDIX-T-SQL Reference
- Chapter 15: Working with Operational Data
- INSERT and the Table Variable
- UPDATE
- DELETE
- DML, Integrity, and Constraints
- Permissions
- Parameterized Queries
- Getting Bold
- Chapter 16: Working with Tabular Data
- Table Derivatives
- SELECT
- FROM
- The Search Is On
- WHERE
- GROUP BY
- HAVING
- ORDER BY
- COMPUTE
- FOR
- Joins
- Union
- Views, and Then Some
- In Review
- Chapter 17: Working with Transactional Data
- SQL Server 2005 Lock Management
- Transaction Processing
- Types of Transactions
- Distributed Transactions
- Working with Cursors
- SQL Server 2005 XML
- SQL Server and the XML Love Affair
- What Is an XML Document?
- Elements of an XML Document
- XQuery
- Understanding the FOR XML Clause in T-SQL
- Getting XML Data Through HTTP
- XML Updategrams and OpenXML: Data Manipulation Through XML
- The X-Files
- SOAP Toolkit
- In Review
- Chapter 18: Monitoring SQL Server
- The SQL Server Profiler
- Monitoring the SQL Server Platform
- Getting Ready to Monitor SQL Server
- Performance Monitoring
- Platform Monitoring Tools
- Getting to Know Your Servers
- Monitoring for Bottlenecks
- Performance Monitoring Overhead
- DBCC
- In Review
- Index
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z
- List of Figures
- List of Tables
- List of Code Examples
Microsoft SQL Server 2005: The Complete Reference: Full Coverage of all New and Improved Features
ISBN: 0072261528
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 239
Pages: 239
Authors: Jeffrey Shapiro