MS SQL Server 2005 eBooks

tang2049

By John C. Hancock, Roger Toren
Publisher: Addison Wesley Professional
Pub Date: August 28, 2006
Print ISBN-10: 0-321-35698-5
Print ISBN-13: 978-0-321-35698-7
Pages: 432

tang2049

Design, Build, and Manage High-Value BI Solutions with SQL Server 2005
In this book, two of Microsoft's leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft's strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management.
Hancock and Toren introduce practical BI concepts and terminology and provide a concise primer on the Microsoft BI platform. Next, they turn to the heart of the bookconstructing solutions. Each chapter-length case study begins with the customer's business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. You'll translate each model into a working system and learn how to deploy it into production, maintenance, and efficient operation.
Whether you're a decision-maker, architect, developer, or DBA, this book brings together all the knowledge you'll need to derive maximum business value from any BI project.
·Leverage SQL Server 2005 databases, Integration Services, Analysis Services, and Reporting Services
·Build data warehouses and extend them to support very large databases
·Design effective Analysis Services databases
·Ensure the superior data quality your BI system needs
·Construct advanced enterprise scorecard applications
·Use data mining to segment customers, cross-sell, and increase the value of each transaction
·Design real-time BI applications
·Get hands-on practice with SQL Server 2005's BI toolset

tang2049

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

tang2049

CHM版本，请全部下载完成后合并阅读！

1

tang2049

2

tang2049

3

tang2049

4

tang2049

5

tang2049

6

tang2049

7