文件名称:SQLServer2005samples
- 所属分类:
- SQL Server数据库
- 资源属性:
- [SQL] [源码]
- 上传时间:
- 2012-11-26
- 文件大小:
- 2.09mb
- 下载次数:
- 0次
- 提 供 者:
- z**
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
全面系统地介绍了SQL Server 2005应用、开发和管理方面的技术,涉及安装和升级SQL Server、T-SQL增强、T-SQL应用、XML数据处理、CLR集成、开发SQL Server应用程序、端点、Service Broker、SQL Server Integration Services、SQL Server配置、SQL Server安全管理、数据的加密与解密、数据备份与还原、数据库的高可用性技术、查询SQL Server对象信息、服务器性能监视等内容。-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.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
深入浅出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
....
...........................................\第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
....