Description: Comprehensive and systematic introduction to SQL Server 2005 applications, development and management of technology, involving the installation and upgrade SQL Server, T-SQL enhancement, T-SQL applications, XML data processing, CLR integration, the development of SQL Server applications, endpoints, Service Broker, SQL Server Integration Services, SQL Server configuration, SQL Server security management, data encryption and decryption, data backup and restore, high availability database technology, SQL Server query object information, such as server performance monitoring.
File list (Check if you may need any files):
深入浅出SQL Server 2005开发、管理与应用实例
...........................................\第11章
...........................................\......\11.2.2 网络协议、TDS端点、端口侦听与广播
...........................................\......\........................................\TCP端点.sql
...........................................\......\11.4.3 角色
...........................................\......\...........\1. 应用程序角色演示.sql
...........................................\......\11.5.2 上下文切换
...........................................\......\.................\1. EXECUTE AS 示例.sql
...........................................\......\11.5.3 所有权链接
...........................................\......\.................\1. 所有权链接示例.sql
...........................................\第12章
...........................................\......\12.1.3 数据库主密钥
...........................................\......\...................\1. 数据库主密钥.sql
...........................................\......\12.2.1 证书
...........................................\......\...........\1. 使用证书加密数据.sql
...........................................\......\12.2.2 非对称加密
...........................................\......\.................\1. 使用非对称密钥加密数据.sql
...........................................\......\12.2.3 对称加密
...........................................\......\...............\1. 使用对称密钥加密数据.sql
...........................................\第13章
...........................................\......\13.1.4 备份媒体集、媒体簇和备份集
...........................................\......\.................................\1. 创建媒体集和显示备份媒体中的信息.sql
...........................................\......\13.2.3 部分备份
...........................................\......\...............\1. 部分备份示例.sql
...........................................\......\13.2.4 文件和文件组备份
...........................................\......\.......................\1. 文件和文件组备份示例.sql
...........................................\......\13.2.6 备份中的COPY_ONLY选项
...........................................\......\............................\1. 仅复制备份.sql
...........................................\......\13.4.2 还原备份
...........................................\......\...............\1. 完全备份与还原.sql
...........................................\......\...............\2. 部分备份与还原.sql
...........................................\......\...............\3. 文件和文件组备份与还原.sql
...........................................\......\...............\4. 日志备份与还原.sql
...........................................\......\...............\5. 差异备份和还原.sql
...........................................\......\13.4.3 将数据库还原到特定的恢复点
...........................................\......\.................................\1. 还原到特定时间点.sql
...........................................\......\.................................\2. 还原到特定的时间点(自动查找时间点).sql
...........................................\......\.................................\3. 还原到事务标记处.sql
...........................................\......\.................................\4. 还原到日志序列.sql
...........................................\......\13.4.4 段落还原
...........................................\......\...............\1. 段落还原示例.sql
...........................................\......\13.4.5 页面还原
...........................................\......\...............\1. 页面还原.sql
...........................................\......\13.5.2 抢救损坏数据库中的数据
...........................................\......\.............................\1. 部分文件损坏时的恢复.sql
...........................................\......\.............................\2. 全部数据文件损坏时的数据恢复.sql
...........................................\......\13.5.3 使用备份与还原实现双机热备份
...........................................\......\...................................\1. 双机热备份示例.sql
....