Mastering SQL Server 2008

Author: Michael Lee  

Publisher: John Wiley & Sons Inc‎

Publication year: 2009

E-ISBN: 9780470467398

P-ISBN(Paperback): 9780470289044

P-ISBN(Hardback):  9780470289044

Subject: TP Automation Technology , Computer Technology;TP39 computer application

Language: ENG

Access to resources Favorite

Disclaimer: Any content in publications that violate the sovereignty, the constitution or regulations of the PRC is not accepted or approved by CNPIEC.

Description

As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.

Chapter

Acknowledgments

pp.:  1 – 9

About the Authors

pp.:  9 – 11

Contents at a Glance

pp.:  11 – 12

Contents

pp.:  12 – 15

Introduction

pp.:  15 – 25

Chapter 3: Databases, Files, and Resource Management

pp.:  63 – 93

Chapter 4: Tables and CRUD Operations

pp.:  93 – 117

Chapter 5: Procedural Programming

pp.:  117 – 161

Chapter 6: Managing Data Integrity

pp.:  161 – 191

Chapter 7: SQL Server and XML

pp.:  191 – 217

Chapter 8: Managing User Security

pp.:  217 – 251

Chapter 9: Data Recovery

pp.:  251 – 281

Chapter 10: Monitoring SQL Server Activity

pp.:  281 – 311

Chapter 11: Using the SQL Server Agent Service

pp.:  311 – 347

Chapter 12: Data Availability and Distribution

pp.:  347 – 377

Chapter 13: SQL Server Data Security

pp.:  377 – 417

Chapter 14: Indexing Strategies for Query Optimization

pp.:  417 – 443

Chapter 15: Transactions and Locking

pp.:  443 – 471

Chapter 16: Using the Resource Governor and Policy-Based Management

pp.:  471 – 501

Chapter 17: SQL Server and the .NET Client

pp.:  501 – 531

Chapter 18: SQL Server and the Common Language Runtime

pp.:  531 – 567

Chapter 19: Using Spatial Data

pp.:  567 – 597

Chapter 20: Service-Oriented Architecture and the Service Broker

pp.:  597 – 623

Chapter 21: Full-Text Search Services

pp.:  623 – 651

Appendix A: The Bottom Line

pp.:  651 – 683

Appendix B: SQL Server Analysis Services Overview

pp.:  683 – 721

Appendix C: SQL Server 2008 Reporting Services

pp.:  721 – 737

Index

pp.:  737 – 751

LastPages

pp.:  751 – 795

The users who browse this book also browse


No browse record.