SQL Server 最佳实践
发布日期: 2007年3月13日
作者: Bob Beauchemin, SQLskills
技术评论家: Laurentiu Cristofor, Al Comeau, Sameer Tejani, Devendra Tiwari, Rob Walters, Niraj Nagrani
此白皮书包含了和SQL Server 2005安全性相关的操作任务以及管理任务，并列举了最佳实践以及可以让SQL Server 系统更加安全的操作任务和管理任务。每个主题都描述了一个功能及其最佳实践。有关特定功能以及文章中所提到的数据定义语言(data definition language, DDL)，请参阅SQL Server 2005 Books Online. 文章中会区别SQL Server 2005中的新功能以及被修改过的默认功能。针对操作任务的代码示例使用了Transact-SQL 语言，因此需要读者对Transact-SQL 语言有所了解以便从此文章中学到更多内容。
更多信息，请参阅白皮书SQL Server 2005 Security Best Practices - Operational and Administrative Tasks
About denny.lee
Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of “SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2008)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
