Deep level technical whitepapers on specific SQL Server best practices.

• 748 Views 2 Comments

  PowerPivot for SharePoint: Single Server Installation

  • Author: denny.lee
  • 08-30-2010

  Writers: Leon Cyril, Dave Wickert, Denny Lee Technical Reviewers: Lee Graber, Jennifer Chu, Kathy MacDonald, Artur Pop, Heidi Steen Published: September...
• 1,001 Views 8 Comments

  Analysis Services ROLAP for SQL Server Data Warehouses

  • Author: denny.lee
  • 08-23-2010

  SQL Server Technical Case Study Writers: Denny Lee, Kay Unkroth Investigators: Denny Lee, Thomas Kejser Contributors: James Podgorski, Richard Tkachuk...
• 2,764 Views 5 Comments

  PowerPivot Technical Diagram: PowerPivot Security Architecture

  • Author: denny.lee
  • 08-17-2010

  Because PowerPivot for Excel and PowerPivot for SharePoint involves so many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint...
• 3,285 Views 3 Comments

  Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products

  • Author: CarlRabeler
  • 07-22-2010

  Author: Tom Wisnowski Contributors: Carl Rabeler, Denny Lee, Philippe-Joseph Arida, Luca Bandinelli, Kevin Donovan, Pej Javaheri, Cephas Lin, Dave Manning...
• 4,310 Views 1 Comments

  Database Upgrade to SQL Server 2008 Tools and Approaches

  • Author: AlexeiK
  • 07-22-2010

  Writer: Dmitry Artemov Contributor: Alexei Khalyako Technical Reviewer: Alexei Khalyako, Kevin Cox, Mark Souza, Murshed Zaman, Peter Scharlock Editor:...
• 3,494 Views 11 Comments

  Develop Reporting Services reports using Analysis Services data; a SQL Server 2008 technical case study

  • Author: Nicholas Dritsas
  • 06-22-2010

  Writers: Nicholas Dritsas, Nopparat Leelavanich Contributors: Artich Asawachaiyawong, Sairung Inlert Technical Reviewers : Carl Rabeler, Robert Bruckner...
• 1,712 Views 6 Comments

  Scale-Out Querying for Analysis Services with Read-Only Databases

  • Author: denny.lee
  • 06-08-2010

  SQL Server Technical Article Authors : Denny Lee, Kay Unkroth Contributor : James Podgorski Technical Reviewers : Akshai Mirchandani, Murshed Zaman, T...
• 2,638 Views 3 Comments

  Proven SQL Server Architectures for High Availability and Disaster Recovery

  • Author: SanjayMishra
  • 06-07-2010

  Writer: Paul S. Randal (SQLskills.com) Contributors: Sanjay Mishra, Prem Mehra Technical Reviewers: Darmadi Komo, Vineet Rao, Gopal Ashok, Kimberly L....
• 2,068 Views 1 Comments

  PowerPivot for SharePoint - Transitioning from a Single Server to SharePoint Farm

  • Author: denny.lee
  • 05-31-2010

  SQL Server Technical Article Authors : Dave Wickert, Denny Lee, Ed Campbell Technical Reviewers : Zohar Raz, Mark Souza Published : June 2010 Applies to...
• 2,050 Views 0 Comments

  High Performance SQL Server Workloads on Hyper-V

  • Author: Lindsey.allen
  • 05-27-2010

  Contributors: Lindsey Allen, Carl Rabeler, Arvind Rao, Mike Ruthruff, Arno Mihm Technical Reviewers: Prem Mehra,  Mike Weiner, Sung Hsueh, Madhan...