Deep level technical short papers on specific SQL Server topics.

• 2,062 Views 7 Comments

  Mirroring a Large Number of Databases in a Single SQL Server Instance

  • Author: SanjayMishra
  • 02-10-2010

  Authors : Sanjay Mishra, Prem Mehra Technical Reviewers : Lubor Kollar, Michael Thomassy, Lindsey Allen, Mike Ruthruff, Kaloian Manassiev, Kevin Cox, Thomas...
• 689 Views 1 Comments

  Analysis Services Load Balancing Solution

  • Author: CarlRabeler
  • 02-08-2010

  Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser ASLB is a custom...
• 2,864 Views 2 Comments

  Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices

  • Author: CarlRabeler
  • 02-08-2010

  Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser This technical...
• 2,507 Views 1 Comments

  Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization

  • Author: AlexeiK
  • 02-08-2010

  Author: Alexei Khalyako Contributors : Dmitry Artemov, Sergey Pyrin Technical Reviewers: Vijay Tandra Sistla , Mike Weiner, Mark Souza Editor: Beth Inghram...
• 6,532 Views 3 Comments

  SQL Server Reporting Services Disaster Recovery Case Study

  • Author: denny.lee
  • 10-23-2009

  Authors : Ayad Shammout (CareGroup Healthcare), Denny Lee Technical Reviewers : Lukasz Pawlowski, Sanjay Mishra, Prem Mehra, Michael Thomassy, Lindsey...
• 7,609 Views 2 Comments

  Deploying a Business Intelligence Solution Using SharePoint, Reporting Services, and PerformancePoint Monitoring Server with Kerberos

  • Author: CarlRabeler
  • 10-13-2009

  Author: Carl Rabeler Reviewers: Prem Mehra, Troy Starr, Kevin Donovan, Burzin Patel, Doron Bar-Caspi, Prash Shirolkar, John Wyss This technical note describes...
• 3,094 Views 13 Comments

  Resolving PAGELATCH Contention on Highly Concurrent INSERT Workloads

  • Author: tkejser
  • 09-22-2009

  Authors: Thomas Kejser, Lindsey Allen, Arvind Rao and Michael Thomassy Contributors and reviewers: Mike Ruthruff, Lubor Kollar, Prem Mehra, Burzin Patel...
• 3,592 Views 2 Comments

  DBCC Checks and Terabyte-Scale Databases

  • Author: stuarto
  • 08-13-2009

  Author: Stuart Ozer Contributors: Suresh Kandoth, Ryan Stonecipher Technical Reviewers: Peter Carlin, Burzin Patel, Bob Ward 1. Overview: Historically...
• 6,448 Views 5 Comments

  Initializing a Transactional Replication Subscriber from an Array-Based Snapshot

  • Author: premmehra
  • 05-04-2009

  Author: Benjamin Wright-Jones Contributors: Ken England, Prem Mehra, Mike Ruthruff, Greg Yvkoff, Qun Guo and Gopal Ashok Technical Reviewers: Joseph Sack...
• 6,373 Views 1 Comments

  Bulk Loading Data into a Table with Concurrent Queries

  • Author: AlexeiK
  • 04-06-2009

  Authors: Alexei Khalyako, Stuart Ozer Contributor: Sanjay Mishra Technical Reviewers: Mark Souza, Denny Lee, Burzin Patel Introduction This article describes...