| 作 者： | 美国扎实学习质量研究所 |
| 出版社： | 世界图书出版公司 |
| 丛编项： | |
| 版权说明： | 本书为公共版权或经版权方授权，请支持正版图书 |
| 标 签： | SQL |
| ISBN | 出版时间 | 包装 | 开本 | 页数 | 字数 |
|---|---|---|---|---|---|
| 未知 | 暂无 | 暂无 | 未知 | 0 | 暂无 |
Introduction
Acknowledgments
Part I HOW to Create a SQL Server Database to Store Your Application Data
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
Using the XML Datatype
Using the File System with XML Data
Where to Store External Application Files.
Conclusion
Chapter 1 Quick Reference
2 Basic Database Security Principles
Designing Network Security to Secure Your Database System
Granting Remote Access
Securing External Access
Managing Access to SQL Server Instances
Selecting an Authentication Mode
Connecting to a SQL Server Instance
Managing Access to SQL Server Databases
Granting Access to Databases
Granting Database Permissions
Managing Application Roles.
Managing Access to Schemas
Introducing Schemas
Managing Access to Tables and Columns
Modifying Access to a Table.
Providing Access to Columns Individually
Managing Access to Programmable Objects
Managing Security for Stored Procedures
Managing Security for User-Defined Functions
Managing Security for Assemblies
Managing Ownership Chains
Managing the Execution Context
Conclusion
Chapter 2 Quick Reference
3 Disaster Recovery Techniques to Protect Your Database
Using Full Database Backups.
The Simple Recovery Model
Backup Devices
Performing Full Database Backups
Using Differential Backups
Performing Differential Backups
Using Transaction Log Backups
The Full Recovery Model
Performing Transaction Log Backups
Recovering a Database
Retrieving Backup Information
Restoring a Database Using SQL Server Management Studio
Restoring a Database from a Simple Backup Strategy Using T-SQL
Restoring a Database from a Full Backup Strategy Using T-SQL
Restoring System Databases
Scheduling Backups Using the SQL Maintenance Plan Wizard
Conclusion
Chapter 3 Quick Reference
4 Transferring Your Database to Other Systems
Using Backup and Restore to Transfer Your Data
Full Backup Only
Full Backup With Differential and Transaction Log Backups
Using Detach and Attach to Transfer your Data
Using Replicaton to Transfer your Data
Using SSIS to Transfer Your Data
Automationg and Scheduling the transfer of Your Data
Conclusion
Chapter 4 Quick Reference
……
Part II How to Query Data from SQL Server
Part III How to Modify Data in SQL Server
Index＝
