Flylib.com
Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
ISBN: 0672327783
EAN: 2147483647
Year: 2005
Pages: 150
Authors:
Scalability Experts Inc.
BUY ON AMAZON
Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
Table of Contents
Copyright
Foreword
About the Author
We Want to Hear from You
Chapter 1. Changes in the Database Paradigm: How SQL Server 2005 Redefines the Role of a DBA
SQL Server Philosophy
History
SQL Server 2005 and Database Administrators
Summary
Chapter 2. SQL Server 2005 Database Engine Architectural Changes
The SQL Server Operating System (SQLOS)
Non-Uniform Memory Access (NUMA) Architecture Support
Query Optimization and Execution
Row Versioning
System Metadata Access and the Security Architecture
Storage Engine and IO Changes
Summary
Chapter 3. SQL Server 2005 Setup and Deployment
SQL Server 2005 Editions
Hardware and Software Requirements for Installing SQL Server 2005
SQL Server 2005 Setup Enhancements
Upgrading to SQL Server 2005
Summary
Chapter 4. A Tour of New Features in SQL Server 2005
Setup Enhancements
Database Administration and Management
Database Engine Enhancements
T-SQL Enhancements
SQL Server 2005 Security
Performance Monitoring and Tuning Enhancements
High-Availability Features
Business Intelligence Redefined
Notification Services
Full-Text Search Enhancements
Documentation Improvements
Summary
Chapter 5. SQL Server 2005 Tools and Utilities
Tools and Utilities Overview
Management and Authoring
Performance Monitoring, Tuning, and Optimization Tools
Operations and Configuration
Management APIs
Summary
Chapter 6. Transact-SQL Enhancements
T-SQL Versus SQLCLR
The TOP Operator
The TABLESAMPLE Clause
Common Table Expressions (CTEs)
Large Object Data Type Enhancements
T-SQL Error Handling
DDL Triggers
Event Notifications
Snapshot Isolation
Ranking Functions
New Relational Operators: PIVOT, UNPIVOT, and APPLY
The OUTPUT Clause
The BULK Rowset Provider
New Declarative Referential Integrity Actions
Metadata Views and Dynamic Management Views
Miscellaneous T-SQL Enhancements
Summary
Chapter 7. SQL Server 2005 Security
An Introduction to Security in SQL Server 2005
Authentication
Authorization
Auditing Enhancements
Cryptography Support
Surface Area Configuration (SAC)
SQL Server Agent Security Overview
SQLCLR Security Overview
Service Broker Security Overview
Summary
Chapter 8. Reliability and High Availability in the Database Engine
Reliability Enhancements
Availability Enhancements
Summary
Chapter 9. Performance Analysis and Tuning
Physical Database Design, Analysis, and Tuning
Troubleshooting Locking and Blocking
Query Performance Tuning
Designing Applications for Performance
Performance Monitoring and Tuning Tools
Summary
Chapter 10. XML and Web Services Support in SQL Server 2005
XML Primer
The xml Data Type
FOR XML Enhancements
Native XML Web Services Support
Summary
Chapter 11. SQL Server 2005 and .NET Integration
What Is the .NET Framework?
.NET Framework Integration
SQLCLR Integration Examples
Summary
Chapter 12. SQL Server Integration Services Overview
New SSIS Features
The SSIS Architecture
The SSIS Toolkit
Designing SSIS Packages
The World of Wizards
SSIS and Data Warehousing
Summary
Chapter 13. What s New in SQL Server Analysis Services 2005
OLAP, Data Warehousing, Business Intelligence, and Data Mining
Analysis Services Fundamentals
Analysis Services 2005 Enhancements
Performance Tuning for Analysis Services
Administering Analysis Services
Analysis Services Security Overview
Migrating from SQL Server 2000 Analysis Services to SQL Server 2005 Analysis Services
SQL Server 2005 Reporting Services (SSRS) Overview
Summary
Chapter 14. SQL Server Service Broker
An Introduction to Asynchronous Messaging
Understanding Service Broker
Service Broker Operations and Troubleshooting
Service Broker Security Overview
Summary
Chapter 15. SQL Sever 2005 Support for 64-Bit Processors
64-Bit Processor Usage Scenarios
SQL Server 2005 (64-Bit) in Detail
Summary
Index
SYMBOL
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
ISBN: 0672327783
EAN: 2147483647
Year: 2005
Pages: 150
Authors:
Scalability Experts Inc.
BUY ON AMAZON
Certified Ethical Hacker Exam Prep
Linux
Apply Your Knowledge
Web Server Hacking, Web Applications, and Database Attacks
Buffer Overflows, Viruses, and Worms
Scanning
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Configuring Intracluster IP Phone Communication
Cisco Catalyst Switches
Security Taboos
Using the CTL Client
Performance Counters
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Relationships in the Supply Chain
The Internationalization of the Retail Supply Chain
Market Orientation and Supply Chain Management in the Fashion Industry
Logistics in Tesco: Past, Present and Future
The Development of E-tail Logistics
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 240 Overcurrent Protection
Article 396 Messenger Supported Wiring
Article 408: Switchboards and Panelboards
Article 645 Information Technology Equipment
Example No. D3 Store Building
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity
Value Stream Mapping and Process Flow Tools
Voice of the Customer (VOC)
Data Collection
Variation Analysis
Complexity Value Stream Mapping and Complexity Analysis
Quartz Job Scheduling Framework: Building Open Source Enterprise Applications
Scheduling a Quartz Job Declaratively
Quartz Cookbook
Working with Jobs
Using Quartz with the Struts Framework
Conclusion
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