MS SQL Server 2005 eBooks

zr_gd

多谢楼主。
楼主能否重新传一下Programming MS SQLServer 0605MS的PMSS 19.txt，附件有误，无法下载。 请楼主修复一下， 多谢！

zr_gd

Up again. Please fix the problem. Thanks.

tang2049

已经更新，请重新下载！

linroger

These books are what I need.  Thanks.   You are great!!

yuanqixun

支持,不知楼主有没有sap相关的商务智能的书?

tang2049

最初由 yuanqixun 发布
[B]支持,不知楼主有没有sap相关的商务智能的书? [/B]

这个好象我没有，呵呵……

tang2049

今天继续更新几本新书！

tang2049

By  Solid Quality Learning

Publisher: Microsoft Press
Pub Date: April 19, 2006
Print ISBN-10: 0-7356-2316-3
Print ISBN-13: 978-0-7356-2316-3
Pages: 496

tang2049

SQl Server 2005 is Microsofts next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. This is a skill-building, learn-by-doing tutorial to help developers and database administrators with basic product knowledge begin to master SQL Server 2005.

tang2049

Copyright
    Introduction
    Acknowledgments
    Part I:  How to Create a SQL Server Database to Store Your Application Data
           Chapter 1.  Choosing Which Application Data to Store in Your Database
       Where to Store Application Settings
       Where to Store User Settings
       Where to Store XML Documents
       Where to Store External Application Files
       Conclusion
           Chapter 2.  Basic Database Security Principles
       Designing Network Security to Secure Your Database System
       Managing Access to SQL Server Instances
       Managing Access to SQL Server Databases
       Managing Access to Schemas
       Managing Access to Tables and Columns
       Managing Access to Programmable Objects
       Conclusion
           Chapter 3.  Disaster Recovery Techniques to Protect Your Database
       Using Full Database Backups
       Using Differential Backups
       Using Transaction Log Backups
       Recovering a Database
       Scheduling Backups Using the SQL Maintenance Plan Wizard
       Conclusion
           Chapter 4.  Transferring Your Database to Other Systems
       Using Backup and Restore to Transfer Your Data
       Using Detach and Attach to Transfer Your Data
       Using Replication to Transfer Your Data
       Using SSIS to Transfer Your Data
       Automating and Scheduling the Transfer of Your Data
       Conclusion
    Part II:  How to Query Data from SQL Server
           Chapter 5.  Computing Aggregates
       Counting Rows
       Computing Totals and Subtotals
       Computing Running Totals
       Computing Statistical Values
       Designing Your Own User-Defined Aggregates Using the CLR
       Conclusion
           Chapter 6.  Improving Query Performance
       Understanding Query Plans
       Creating Indexes to Provide Faster Query Execution
       Tuning Queries Using the Database Engine Tuning Advisor
       Conclusion
           Chapter 7.  Building Queries Dynamically
       A User Interface for Building Queries
       Retrieving Information about the Tables in a Database
       Sorting and Filtering Dynamically
       Parameters and Security in Dynamic Queries
       Conclusion
           Chapter 8.  Working with Data from Remote Data Sources
       Reading Data from Remote Sources at the Middle Tier
       Reading Data from Remote Sources in SQL Server
       Inserting, Updating, or Deleting Data from Remote Sources in SQL Server
       Conclusion
           Chapter 9.  Reading SQL Server Data from the Internet
       Direct Access to SQL Server
       Interoperability with Other Systems through HTTP Endpoints
       Access to SQL Server through an Extra Layer
       Conclusion
    Part III:  How to Modify Data in SQL Server
           Chapter 10.  Using Transactions to Provide Safe Database Concurrency
       Business Transactions and SQL Server Transactions
       Defining Transactions in SQL Server
       Managing Transaction Isolation
       Transactions in ADO.NET
       Conclusion
           Chapter 11.  Keeping History Data
       Taking a Snapshot of Your Database
       Summarizing Data in History Tables
       Summarizing Data in Indexed Views
       Tracking Changes Using Audit Columns and Audit Tables
       Conclusion
           Chapter 12.  Introduction to Reporting Services
       Requirements for a Reporting Solution
       Design Considerations
       Reporting Services Architecture
       Creating a Basic Report
       Conclusion
           Chapter 13.  Introduction to Notification Services
       A Notification Services Scenario
       Gathering Requirements
       Building the Application
       Running the Application
       Conclusion
    Index