MCPD

536|528|547
用SQL语句替代CURSOR
摘要: CURSOR --> SQL阅读全文
posted @ 2009-06-01 00:02 On the road.... 阅读(127) | 评论 (0) 编辑
444.Plan guide
摘要: guide plan阅读全文
posted @ 2009-05-19 10:09 On the road.... 阅读(78) | 评论 (0) 编辑
443 Chapter9.Database Mirroring
posted @ 2009-04-16 17:27 On the road.... 阅读(136) | 评论 (0) 编辑
443 Chapter8. Failover clustering -- not completed
posted @ 2009-04-16 17:25 On the road.... 阅读(24) | 评论 (0) 编辑
443 Chapter7.Planning for High Availability in the Enterprise
posted @ 2009-04-16 17:22 On the road.... 阅读(71) | 评论 (0) 编辑
443 Chapter6.Designing Database Security
posted @ 2009-04-16 17:17 On the road.... 阅读(142) | 评论 (0) 编辑
443 CHapter5.Designing SQL Server Endpoints
posted @ 2009-04-16 17:16 On the road.... 阅读(151) | 评论 (0) 编辑
443 Chapter4.Designing Database Server Security Policies
posted @ 2009-04-16 17:15 On the road.... 阅读(169) | 评论 (0) 编辑
443.Chapter3
posted @ 2009-04-16 17:12 On the road.... 阅读(96) | 评论 (0) 编辑
443.Chapter2 布署与合并多个数据库实例
posted @ 2009-04-16 17:11 On the road.... 阅读(63) | 评论 (0) 编辑
431.Chapter18.Implementing log shipping
摘要: Log Shipping story阅读全文
posted @ 2009-03-05 18:41 On the road.... 阅读(52) | 评论 (0) 编辑
SQL Server Logins, Database Users, Database Roles and Schemas
摘要: 一直以为自己很明白，其实那时自以为是。今天梳理了一下相关知识，总算是小有收获，赶紧记下，以便日后查阅。 阅读全文
posted @ 2009-03-04 19:51 On the road.... 阅读(169) | 评论 (0) 编辑
431.chapter14.working with SQL Server Performance
摘要: SQL server performance阅读全文
posted @ 2009-02-28 19:07 On the road.... 阅读(20) | 评论 (0) 编辑
431.chapter14.working with SQL Server Agent job
摘要: SQL Server Agent detail阅读全文
posted @ 2009-02-28 16:01 On the road.... 阅读(73) | 评论 (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.... 阅读(69) | 评论 (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.创建表，约束和用户自定义类型
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.... 阅读(175) | 评论 (1) 编辑
431.chapter2.configure log and datafiles
摘要: Configuring Database Files and Filegroups Concept, Knowleadge, and Practice阅读全文
posted @ 2008-08-17 00:03 On the road....| 编辑
工作中的小事情
posted @ 2008-06-22 22:57 On the road.... 阅读(69) | 评论 (0) 编辑