04 2009 档案

一个权限的设置，你会混淆么
摘要：实验环境；1 创建一个schema[代码]2 创建两个表，一个视图，一个存储过程[代码][代码][代码][代码]3 创建一个login[代码]这个时候使用SaleA登录MyDB是没有任何权限的。执行下列命令会得到4个错误[代码]错误信息：Msg 229, Level 14, State 5, Line 1SELECT permission denied on object 'Customer', ... 阅读全文
posted @ 2009-04-20 12:28 On the road.... 阅读(420) 评论(0) 推荐(0) 编辑
443 Chapter9.Database Mirroring
摘要：Database MirroringLesson 1: Overview of Database Mirroring1.Database Mirroring Roles(1)sample(2)sample2.Principal Role(1)Sample(2)sample3.Mirror Role4.Witness Server5.Database Mirroring Endpoints6.Ope... 阅读全文
posted @ 2009-04-16 17:27 On the road.... 阅读(339) 评论(0) 推荐(0) 编辑
443 Chapter8. Failover clustering -- not completed
摘要：这个太难写了。我觉得书上的有一个指令有问题，害得我做这个的实验的时候，花了n天的时间才搞定这个想放在这里，回头有空补全其相关知识。 阅读全文
posted @ 2009-04-16 17:25 On the road.... 阅读(136) 评论(0) 推荐(0) 编辑
443 Chapter7.Planning for High Availability in the Enterprise
摘要：Planning for High Availability in the EnterpriseLesson 1: Assessing Database Availability Requirements1.Calculating Availability(1) A = (F – ( MR + R )) / FA: AvailabilityF: Mean time between ... 阅读全文
posted @ 2009-04-16 17:22 On the road.... 阅读(210) 评论(0) 推荐(0) 编辑
443 Chapter6.Designing Database Security
摘要：Designing Database SecurityLesson 1: Designing Instance-level Security1.Configuring Service Account(1)In SQL Server 2005, when selecting the service account for SQL server instance, you should use an ... 阅读全文
posted @ 2009-04-16 17:17 On the road.... 阅读(336) 评论(0) 推荐(0) 编辑
443 CHapter5.Designing SQL Server Endpoints
摘要：Designing SQL Server EndpointsLesson 1: Overview of EndpointEndpoints control the capability to connect to an instance of SQL Server as well as dictating the communications methods that are acceptabl... 阅读全文
posted @ 2009-04-16 17:16 On the road.... 阅读(415) 评论(0) 推荐(0) 编辑
443 Chapter4.Designing Database Server Security Policies
摘要：Designing Database Server Security PoliciesLesson 1: Enforcing SQL Server Security through Group Policy1. What is Group Policy(1) Group policy is a framework that administrators use to control the co... 阅读全文
posted @ 2009-04-16 17:15 On the road.... 阅读(448) 评论(0) 推荐(0) 编辑
443.Chapter3
摘要：Lesson 1: Assessing database security needs for biz1. What is a security policy(1) A security policy is a document or set of documents containing rules that define the security framework of an organiz... 阅读全文
posted @ 2009-04-16 17:12 On the road.... 阅读(287) 评论(0) 推荐(0) 编辑
443.Chapter2 布署与合并多个数据库实例
摘要：第二章 部署与合并多个数据库实例I. Deploying multiple instances1. 设计数据库实例。当满足下列情况时，应安装多个数据库实例。 多个互相独立的sysadmin组 数据库服务器需要为不同的组织提供数据库 对不同的数据库实施不同的升级或者更新途径 隔离相同的SQL Server登录名 合并多个数据库服务器到单个数据库服务器2. 规划数据库实例。下列是在建立... 阅读全文
posted @ 2009-04-16 17:11 On the road.... 阅读(260) 评论(0) 推荐(0) 编辑
[Reference]SQL Server tempdb optimization tips
摘要：SQL Server 2005 tempdb optimization 阅读全文
posted @ 2009-04-15 22:46 On the road.... 阅读(304) 评论(0) 推荐(0) 编辑