Deep level technical short papers on specific SQL Server topics.

• 919 Views 4 Comments

  Increasing Throughput of Pipelines by Splitting Synchronous Transformations into Multiple Tasks

  • Author: admin
  • 08-18-2010

  Increasing Throughput of Pipelines by Splitting Synchronous Transformations into Multiple Tasks Authors : Sedat Yogurtcuoglu, Henk van der Valk, and Thomas...
• 2,238 Views 2 Comments

  Excel, Cube Formulas, Analysis Services, Performance, Network Latency, and Connection Strings

  • Author: CarlRabeler
  • 06-25-2010

  Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Marius Dumitru, John Sirmon, Nick Medveditskov This technical note discusses the usage of three...
• 5,429 Views 3 Comments

  Top 10 Hidden Gems in SQL 2008 R2

  • Author: KevinCox
  • 05-07-2010

  With all the new features in SQL 2008 R2, here are the major ones getting all the press: PowerPivot Parallel Data Warehouse Application and Multi-Server...
• 7,200 Views 16 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...
• 2,797 Views 2 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...
• 9,769 Views 11 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...
• 4,384 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...
• 10,117 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...
• 12,281 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...
• 4,612 Views 14 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...