Flylib.com
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
Year: 2006
Pages: 239
Authors:
Jeffrey Shapiro
BUY ON AMAZON
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
Year: 2006
Pages: 239
Authors:
Jeffrey Shapiro
BUY ON AMAZON
Adobe After Effects 7.0 Studio Techniques
Previews and OpenGL
Putting Masks in Motion
The Essentials
5D: Pick Up the Camera
Film, HDR, and 32 Bit Compositing
Visual C# 2005 How to Program (2nd Edition)
Wrap-Up
Wrap-Up
TreeView Control
Terminology
J.13. Class ATMCaseStudy
Cisco CallManager Fundamentals (2nd Edition)
Miscellaneous Solutions
Definition of Station Devices
Overview of Station Devices Supported by CallManager
Accessing CDR Data in the Central CDR Database
Appendix C. Protocol Details
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 5. Driven to a Better User Interface
Hack 23. Find a Place to Live
Hack 29. Find the Best Gasoline Prices
Hack 48. Tell Your Communitys Story
Hack 66. Add Your Own Custom Map
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
The Functional Triad Computers in Persuasive Roles
Computers as Persuasive Tools
Computers as Persuasive Media Simulation
Credibility and the World Wide Web
The Ethics of Persuasive Technology
Sap Bw: a Step By Step Guide for Bw 2.0
Creating an InfoSource for Transaction Data
Organizing Workbooks Using BEx Browser
Summary
Object Transport
Appendix A. BW Implementation Methodology
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies