MCPD - 随笔分类 - On the road....

摘要：CURSOR --> SQL 阅读全文

posted @ 2009-06-01 00:02 On the road.... 阅读(461) 评论(0) 推荐(0)

摘要：guide plan 阅读全文

posted @ 2009-05-19 10:09 On the road.... 阅读(294) 评论(0) 推荐(0)

摘要：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.... 阅读(350) 评论(0) 推荐(0)

443 Chapter8. Failover clustering -- not completed

摘要：这个太难写了。我觉得书上的有一个指令有问题，害得我做这个的实验的时候，花了n天的时间才搞定这个想放在这里，回头有空补全其相关知识。阅读全文

posted @ 2009-04-16 17:25 On the road.... 阅读(146) 评论(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.... 阅读(217) 评论(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.... 阅读(343) 评论(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.... 阅读(424) 评论(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.... 阅读(460) 评论(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.... 阅读(296) 评论(0) 推荐(0)

443.Chapter2 布署与合并多个数据库实例

摘要：第二章部署与合并多个数据库实例I. Deploying multiple instances1. 设计数据库实例。当满足下列情况时，应安装多个数据库实例。 多个互相独立的sysadmin组 数据库服务器需要为不同的组织提供数据库 对不同的数据库实施不同的升级或者更新途径 隔离相同的SQL Server登录名 合并多个数据库服务器到单个数据库服务器2. 规划数据库实例。下列是在建立... 阅读全文

posted @ 2009-04-16 17:11 On the road.... 阅读(269) 评论(0) 推荐(0)

431.Chapter18.Implementing log shipping

摘要：Log Shipping story 阅读全文

posted @ 2009-03-05 18:41 On the road.... 阅读(326) 评论(0) 推荐(0)

SQL Server Logins, Database Users, Database Roles and Schemas

摘要：一直以为自己很明白，其实那时自以为是。今天梳理了一下相关知识，总算是小有收获，赶紧记下，以便日后查阅。阅读全文

posted @ 2009-03-04 19:51 On the road.... 阅读(619) 评论(0) 推荐(0)

431.chapter14.working with SQL Server Performance

摘要：SQL server performance 阅读全文

posted @ 2009-02-28 19:07 On the road.... 阅读(258) 评论(0) 推荐(0)

431.chapter14.working with SQL Server Agent job

摘要：SQL Server Agent detail 阅读全文

posted @ 2009-02-28 16:01 On the road.... 阅读(356) 评论(0) 推荐(0)

431.chapter12.Working with HTTP Endpoints

摘要：understanding HTTP Endpoint security and create a http endpoint which can be vistion through a client by sending SOAP request 阅读全文

posted @ 2009-02-27 12:23 On the road.... 阅读(252) 评论(0) 推荐(0)

431.chapter10. working with flat files

摘要：1 准备工作 2 bcp 3 bulk insert 4 bulk xml 5 ssis import/export 阅读全文

posted @ 2009-02-26 16:07 On the road....

431.chapter2.configure database recovery model

摘要：SQL Server Recovery Mode 阅读全文

posted @ 2009-02-26 14:23 On the road....

431.chapter3.创建表，约束和用户自定义类型

摘要：2 约束就是用户输入超出允许范围的数据（1）check约束：通过限制列的可接受值，强制域的完整性。通过任何基于逻辑运算符号返回true或者false的逻辑值创建check约束。一个列可以有多个check约束，按照约束的创建顺序进行验证搜索条件必须为逻辑表达式，并且不能引用其他表列级别的check约束只能引用被约束的列，表级别的约束只能引用用一个表中的列不能再text，ntext或image... 阅读全文

posted @ 2009-02-25 12:04 On the road....

431.chapter2.configure database mail

摘要：SQL Database Mail SQL 2005数据库邮件是一种通过 Microsoft SQL Server 2005 Database Engine 发送电子邮件的企业解决方案。通过使用数据库邮件，数据库应用程序可以向用户发送电子邮件。邮件中可以包含查询结果，还可以包含来自网络中任何资源的文件。数据库邮件旨在实现可靠性、灵活性、安全性和兼容性。阅读全文

posted @ 2008-08-18 19:10 On the road.... 阅读(359) 评论(1) 推荐(0)

431.chapter2.configure log and datafiles

摘要：Configuring Database Files and Filegroups Concept, Knowleadge, and Practice 阅读全文

posted @ 2008-08-17 00:03 On the road....

随笔分类 - MCPD

公告