Скачать через торрент Brust A.J., Forte S. - Programming Microsoft SQL Server 2005 бесплатно torrent (книга, аудиокнига, журнал, комикс

Copyright
Acknowledgments
Introduction
Part I: Design Fundamentals and Core Technologies
Chapter 1. Overview
A Tough Act to Follow
Industry Trends, SQL Server Features, and a Book to Show You the Way
A Collaborative Effort for, and by, Developers
Chapter 2. Exploring the T-SQL Enhancements in SQL Server 2005
Introducing SQL Server Management Studio
Common Table Expressions
The PIVOT and UNPIVOT Operators
TOP Enhancements
Ranking Functions
Exception Handling in Transactions
New Data Types
The WAITFOR Command
DDL Triggers and Notifications
SNAPSHOT Isolation
Statement-Level Recompile
Summary
Chapter 3. An Overview of SQL CLR
Getting Started: Enabling CLR Integration
Visual Studio/SQL Server Integration
Your First SQL CLR Stored Procedure
CLR Stored Procedures and Server-Side Data Access
Deployment
CLR Functions
CLR Triggers
CLR Aggregates
CLR Types
Security
Examining and Managing CLR Types in a Database
Best Practices for SQL CLR Usage
Summary
Chapter 4. XML and the Relational Database
XML in SQL Server 2000
The XML Data Type
FOR XML Commands
Querying XML Data Using XQuery
Summary
Chapter 5. Introducing SQL Server Management Studio
The New Management Studio Interface
Using Object Explorer
Management Studio Solutions, Projects, and Files
Creating Objects
Creating Queries
Using Templates
Maintenance Features
Performance Tools
Summary
Chapter 6. Using SQL Server Management Objects (SMO)
What Is SMO?
Working with SMO in Visual Studio
Summary
Chapter 7. SQL Server 2005 Security
Four Themes of the Security Framework
SQL Server 2005 Security Overview
Authentication and Authorization
Encryption Support in SQL Server 2005
Protecting SQL Server 2005
How Hackers Attack SQL Server
Summary
Part II: Application Development and Reach Technologies
Chapter 8. ADO.NET 2.0, Typed DataSet Objects, and .NET Data Binding
A Brief History of Data Access Object Models
What's New in ADO.NET 2.0?
Typed DataSet Enhancements
"Pure" ADO.NET: Working in Code
It's Not Just Text: Processing XML Columns with ADO.NET and the System.Xml Namespace
Embedding SQL CLR Objects in Typed DataSet Objects
Windows Forms Data Binding
Data Binding on the Web
Summary
Chapter 9. Debugging
About the Sample Code
Ad Hoc Debugging
Application Debugging
Mixing SQL CLR and T-SQL Code
Test Script Debugging
Debugging Queries External to Visual Studio
Remote Debugging
Summary
Chapter 10. SQL Server 2005 Native XML Web Services
Understanding Native XML Web Services
Exposing SQL Programmability as Web Services
Example Native XML Web Services Project
Best Practices for Using Native XML Web Services
Summary
Chapter 11. Transactions
What Is a Transaction?
Local Transactions Support in SQL Server 2005
Transaction Terminology
Isolation Levels
Distributed Transactions
Transactions in SQL CLR (CLR Integration)
Putting It All Together
Summary
Chapter 12. SQL Server Service Broker: The New Middleware
What Is Middleware?
What Is SQL Server Service Broker?
What Is a SQL Server Service Broker Application?
Service Broker Architecture
Integrated Management and Operation
Routing and Load Balancing
Service Broker Programming in T-SQL
Defining Service Broker Objects
Service Broker and Query Notification
Service Broker's Place in the Middleware World
Summary
Chapter 13. Using SQL Server 2005 Notification Services
What Is a Notification Application?
Working with Notification Services
A Sample Notification Application
Summary
Chapter 14. Developing Desktop Applications with SQL Server Express Edition
What Is SQL Server Express Edition?
Configuration
Working with SQL Server Express Edition
Installing SQL Server Express Edition
Summary
Chapter 15. Developing Applications with SQL Server 2005 Everywhere Edition and SQL Server Merge Replication
SQL Everywhere Integration with SQL Server 2005
Creating a SQL Everywhere Application with SQL Server Replication and Visual Studio 2005
Summary
Part III: Reporting and Business Intelligence
Chapter 16. Using SQL Server 2005 Integration Services
History of Data Transfer in SQL Server
Working with Integration Services Packages
Using Integration Services Packages
Security
Programming Integration Services
Extensibility
Summary
Chapter 17. Basic OLAP
Wherefore BI?
OLAP 101
Building Your First Cube
Running Queries
Summary
Chapter 18. Advanced OLAP
What We'll Cover in This Chapter
Advanced Dimensions and Measures
Calculations
Key Performance Indicators
Actions
Partitions, Aggregation Design, Storage Settings, and Proactive Caching
Perspectives
Translations
Roles
Summary
Chapter 19. OLAP Application Development
Using Excel
Beyond OWC: Full-On OLAP Development
Summary
Chapter 20. Extending Your Database System with Data Mining
Why Mine Your Data?
Getting Started
Using the Data Mining Wizard and Data Mining Designer
Using Data Mining Extensions
Data Mining Applied
Summary
Chapter 21. Reporting Services
Report Definition and Design
Report Management
Report Access and Delivery
Report Server Architecture
Summary
About the Authors
Contributing Authors
Index