Deep level technical short papers on specific SQL Server topics.

• 1,872 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...
• 1,923 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...
• 2,631 Views 0 Comments

  Scheduling Sub-Minute Log Shipping in SQL Server 2008

  • Author: SanjayMishra
  • 02-24-2009

  Author : Sanjay Mishra Contributors : Mark Scurrell, Richard Waymire Technical Reviewers : Denny Lee, Prem Mehra, Richard Tkachuk, Burzin Patel, Kun Cheng...
• 2,222 Views 3 Comments

  Tuning Backup Compression Part 2

  • Author: SanjayMishra
  • 02-16-2009

  Authors : Sanjay Mishra, Mike Ruthruff Technical Reviewers : Steve Schmidt, Mike Purtell, Mark Souza, Juergen Thomas, Peter Scharlock, Burzin Patel, Prem...
• 12,690 Views 6 Comments

  Reporting Services Performance Optimizations

  • Author: denny.lee
  • 01-14-2009

  Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series Authors: Denny Lee, Lukasz Pawlowski Contributors:...
• 5,497 Views 10 Comments

  Diagnosing Transaction Log Performance Issues and Limits of the Log Manager

  • Author: Lindsey.allen
  • 12-09-2008

  Author: Mike Ruthruff Technical Reviewers: Benjamin Wright-Jones, Peter Byrne, Kun Cheng, Burzin Patel, Sanjay Mishra, Mark Souza, Michael Thomassy, Lubor...
• 3,953 Views 3 Comments

  Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services

  • Author: denny.lee
  • 11-18-2008

  Author : Denny Lee Contributors / Reviewers : Richard Tkachuk, Akshai Mirchandani, Robert Zare, Thomas Kejser, Gang Xiao, Cristian Petculescu Introduction...
• 10,920 Views 18 Comments

  Reporting Services Scale-Out Deployment Best Practices

  • Author: denny.lee
  • 10-21-2008

  Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series Authors: Denny Lee, Lukasz Pawlowski Contributors:...
• 9,698 Views 3 Comments

  The Many Benefits of Money…Data Type!

  • Author: admin
  • 09-25-2008

  Authors: Denny Lee, Thomas Kejser, Matt Neerincx Contributors / Reviewers: Peter Carlin, Brandon Berg, Eric Jacobsen, Burzin Patel Background Our initial...
• 4,958 Views 2 Comments

  SQL Server Service Broker: Maintaining Identity Uniqueness Across Database Copies

  • Author: MichaelThomassy
  • 08-12-2008

  Author: Michael Thomassy Technical Reviewers: Sanjay Mishra, Burzin Patel, Stuart Ozer A Deployment Method: Copying Databases When dealing with many large...