SQL Server 最佳实践
发布日期: 2007年4月19日
作者: Michael Thomassy, Sanjay Mishra
技术评论家: Prem Mehra, Mike Ruthruff, Don Vilen, Kevin Cox, Chris Lee, Siva Raghupathy, Jaaved Mohammed, Burzin Patel, Cihan Biyikoglu, Madhu Desarapu
数据库镜像可以在数据库服务器出现故障的时候切换到另一台服务器上。为了实现无缝的用户体验，很重要的一点是让应用程序能够自动重新连接到当前的主服务器上。该文章描述了如何确保你的应用程序在数据库镜像发生故障转移的时候自动实现故障跳转。文章中提到的客户端重定向工具包括Microsoft SQL Native Client, ADO.NET, 以及Microsoft JDBC Driver. 更多信息，请参阅白皮书 Implementing Application Failover with Database Mirroring
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
|
|
