Browse by Tags

• Analysis Services
• Development & Programming
• Manageability & Serviceability
• Manageability &amp
• Migration and Transition
• Performance and Scalability
• query performance
• Resource Utilization
• Serviceability
• SQL Analysis Service

• SQL Server 2005 Best Practices Analyzer (January 2008) -- Now Available!

  It's a new year and, with it, we come bearing gifts! We have a pretty significant update to SQL Server 2005 Best Practices Analyzer. It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple Read More... Posted Saturday, January 19, 2008 7:36 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Analysis Services, Reliability and Availability, Manageability & Serviceability

• New Best Practices Whitepaper published: "Database Mirroring and Log Shipping Working Together"

  Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single Read More... Posted Friday, January 11, 2008 11:42 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Reliability and Availability

• New Best Practices Article

  Scale-Out Querying with Analysis Services Using SAN Snapshots Read More... Posted Thursday, September 13, 2007 5:10 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Analysis Services, SQL Analysis Service, Development & Programming, Performance and Scalability, Reliability and Availability, Manageability & Serviceability, query performance, Manageability &amp, Serviceability

• SQL Server 2005 Transactional Replication: Benefit of using SubscriptionStreams for low bandwidth, high latency environments

  Author: Bren Newman Introduction When using Microsoft SQL Server 2005 Transactional Replication, the Log Reader Agent reads the log, constructs SQL statements for published articles and posts it to the Distribution database; the Distribution Agent reads Read More... Posted Tuesday, May 08, 2007 7:00 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability, Reliability and Availability, Manageability & Serviceability

• Check out the exciting new SQL Server Best Practices website.....

  http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. Drawing on the extensive experience and expertise Read More... Posted Saturday, December 09, 2006 8:31 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Resource Utilization, Development & Programming, Performance and Scalability, Migration and Transition, Reliability and Availability, Manageability & Serviceability