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
Beginning Cryptography with Java
The JCA and the JCE
Symmetric Key Cryptography
Distinguished Names and Certificates
CMS and S/MIME
SSL and TLS
VBScript Programmers Reference
A Quick Introduction to Programming
The Scripting Runtime Objects
Windows Script Host
Windows Script Components
Appendix A VBScript Functions and Keywords
SQL Hacks
Hack 2. Connect to SQL from a Program
Hack 28. Avoid Dividing by Zero
Hack 33. Get Values and Subtotals in One Shot
Hack 77. Fill in Missing Values in a Pivot Table
Hack 89. Choose Any Three of Five
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 350 Liquidtight Flexible Metal Conduit Type LFMC
Notes to Tables
Tables 11(A) and 11(B)
Example D3(a) Industrial Feeders in a Common Raceway
Example No. D4(b) Optional Calculation for Multifamily Dwelling
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
Deployment Scenarios Using ACLs
Cisco WebVPN Solution
Troubleshooting PKI
Firewall Management Using ASDM
Case Studies
AutoCAD 2005 and AutoCAD LT 2005. No Experience Required
Basic Commands to Get Started
Gaining Drawing Strategies: Part 2
Using Layers to Organize Your Drawing
Managing External References
Appendix A Look at Drawing in 3D
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