SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

Browse by Tags

Report Server Catalog Best Practices

Building and Deploying Large Scale SQL Server Reporting Services Environments—Technical Note Series Authors: Denny Lee, Lukasz Pawlowski Contributors: David Reinhold, John Gallardo, Dean Kalanquin, Robert Bruckner Technical Reviewers: Tim Shea, Mike Ruthruff, Burzin Patel Introduction This technical...

Posted to Weblog by denny.lee on 06-26-2008

Comments

Reporting Services Scale-Out Architecture

Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series Authors: Denny Lee, Lukasz Pawlowski Contributors: David Reinhold, Robert Bruckner Technical Reviewers: Burzin Patel Introduction This technical note is the introduction to the Building and Deploying Large...

Posted to Weblog by denny.lee on 06-05-2008

Comments

Resolving scheduler contention for concurrent BULK INSERT

Author: Thomas Kejser Reviewers: Stuart Ozer, Kun Cheng, Lindsey Allen, Mike Ruthruff and Mark Souza, Prem Mehra, Alex Verbidski Background information As you may be aware, SQL Server, through SQLOS, implements its own scheduling mechanism on top of the Windows operating system. This is done to spend...

Posted to Weblog by tkejser on 04-09-2008

Comments

Sample Robocopy Script to customer synchronize Analysis Services databases

Authors: Eric Jacobsen, Denny Lee Contributors: Mike Vovchik Technical Reviewers: Guillaume Fourrat, Richard Tkachuk, Thomas Kejser Applicable to: SQL Server 2005 Analysis Services Introduction As a quick follow up to the SQL Server Best Practices article Scale-Out Querying with Analysis Services , below...

Posted to Weblog by denny.lee on 01-17-2008

Comments

Scale-Out Querying with Analysis Services

SQL Server Best Practices Article Published: June 13, 2007 Writers: Denny Lee, Nicholas Dritsas Contributors: Lubor Kollar, Lindsey Allen This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large...

Posted to Weblog by denny.lee on 12-16-2007

Comments

SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned

Published: June 11, 2007 Writer: Ron Talmage, Solid Quality Learning Technical Reviewers: Prem Mehra, Jingwei Lu, James Podgorski, Sanjay Mishra The observations in this paper are based on tests run in the SQL Server Customer Lab for a customer who needed to scale up full-text search to a much greater...

Posted to Weblog by Lindsey.allen on 11-21-2007

Comments

SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability

SQL Server Best Practices Article Published: June 30, 2006 (2nd edition) Writers : Juergen Thomas Technical Reviewers : Bernardo Zamora, Sanjay Mishra, Elke Bregler, Clas Hortien, Martin Merdes Dr. Christian Hiller This white paper describes best practices that customers, system integrators, and partners...

Posted to Weblog by admin on 11-19-2007

Comments

Scale-Out Querying with Analysis Services Using SAN Snapshots

SQL Server Best Practices Article Published: September 2007 Writers : Carl Rabeler Contributors : Eric Jacobsen, Ron Talmage, Jon Danskin Technical Reviewers : Denny Lee, Eric Jacobsen, Nicholas Dritsas, Bill Plein This SQL Server Best Practices white paper describes the use of virtual copy SAN snapshots...

Posted to Weblog by admin on 11-19-2007

Page 1 of 1 (8 items)