Browse by Tags

• Analysis Services
• Architecture
• Availability
• Bulk Insert
• Capacity
• Change Data Capture
• Cluster
• Collations
• Compliance
• Concurrency
• Consolidation
• CRM
• Data Modeling
• Data Types
• design
• etl
• Failover
• Failover Clustering
• Featured
• Heaps
• I/O
• Index
• ISV
• Loading
• Log Shipping
• Manageability
• Mirroring
• OLTP
• Operations
• Optimization
• Processing
• Querying
• SAN
• SAP
• Scalability
• Scale-Out
• Security
• Semantic
• Service Broker
• Siebel
• SQL
• SQL Server
• SQL Server 2008
• Transaction Log
• Troubleshooting
• Tuning
• Unicode
• Virtualization
• Waits and Queues
• XML

• Analysis Services ROLAP for SQL Server Data Warehouses

  SQL Server Technical Case Study Writers: Denny Lee, Kay Unkroth Investigators: Denny Lee, Thomas Kejser Contributors: James Podgorski, Richard Tkachuk... Posted Aug 23 2010, 09:57 PM by denny.lee with | with 8 comment(s) Filed under: Performance, Analysis Services, Featured, Tuning, SQL Server, Architecture

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

  SQL Server Technical Article Authors : Denny Lee, Kay Unkroth Contributor : James Podgorski Technical Reviewers : Akshai Mirchandani, Murshed Zaman, T... Posted Jun 08 2010, 05:27 PM by denny.lee with | with 6 comment(s) Filed under: Performance, Analysis Services, Scale-Out

• High Performance SQL Server Workloads on Hyper-V

  Contributors: Lindsey Allen, Carl Rabeler, Arvind Rao, Mike Ruthruff, Arno Mihm Technical Reviewers: Prem Mehra,  Mike Weiner, Sung Hsueh, Madhan... Posted May 27 2010, 10:13 AM by Lindsey.allen with | with no comments Filed under: Performance, Analysis Services, Consolidation, Virtualization, SQL Server, SQL Server 2008

• Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services

  How Microsoft adCenter takes advantage of groundbreaking performance and scalability enhancements and innovative design tools available with Microsoft... Posted Sep 19 2009, 07:12 PM by denny.lee with | with 4 comment(s) Filed under: Performance, Analysis Services, SAN, Availability, Capacity, Optimization, design

• A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network

  Writer: Thomas H. Grohser (=tg=) Contributor: Lindsey Allen Technical Reviewers : Sanjay Mishra, Lubor Kollar, Stuart Ozer, Thomas Kejser, Juergen Thomas... Posted Aug 13 2009, 08:06 PM by Lindsey.allen with | with 10 comment(s) Filed under: Performance, SQL, Scalability, Operations, SQL Server, Manageability, SQL Server 2008

• High Availability and Disaster Recovery at ServiceU: A SQL Server 2008 Technical Case Study

  Writer: David P. Smith (ServiceU Corporation) Contributors: Ron Talmage (Solid Quality Mentors); Sanjay Mishra, Prem Mehra Technical Reviewers: James Podgorski... Posted Aug 04 2009, 04:59 PM by SanjayMishra with | with 2 comment(s) Filed under: Performance, SAN, SQL, Availability, Mirroring, Concurrency, Failover, Log Shipping, Compliance, Transaction Log, SQL Server, Architecture, Manageability, OLTP, SQL Server 2008, Cluster, Failover Clustering

• Improving Microsoft CRM Performance and Securing Data with SQL Server 2008

  Writers: Microsoft Corporation Contributors: Amir Jafri, Jim Toland, Peter Scharlock Technical Reviewers: Srini Acharya, Sunil Agarwal, Peter Carlin, Roger... Posted May 28 2009, 02:22 PM by Peter with | with 2 comment(s) Filed under: Performance, Security, ISV, CRM, SQL Server 2008

• SQL Server 2008 with Siebel CRM Applications

  Writers: Microsoft Corporation Technical Reviewers: Anu Chawla, Wanda He, George Heynen, Peter Samson Published : April 2009 Applies To: SQL Server 2008... Posted May 19 2009, 03:32 PM by wandahe with | with 1 comment(s) Filed under: Performance, ISV, Siebel, SQL Server 2008

• Troubleshooting Performance Problems in SQL Server 2008

  Writers: Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel Technical Reviewers: Jerome Halmans, Fabricio Voznika... Posted Apr 14 2009, 12:21 AM by Cheng_kun with | with 3 comment(s) Filed under: Performance, SQL, Troubleshooting, Scalability, Waits and Queues, Index, I/O, Optimization, Operations, Tuning, SQL Server

• Service Broker: Performance and Scalability Techniques

  Writer: Michael Thomassy Contributors: Sanjay Mishra Technical Reviewers: Lindsey Allen, Lubor Kollar, Mark Souza, Thomas Kejser, Burzin Patel Published... Posted Mar 24 2009, 11:16 AM by MichaelThomassy with | with no comments Filed under: Performance, Scalability, SQL Server, Service Broker, OLTP

• The Analysis Services 2008 Performance Guide

  SQL Server Techical Article Published: October 2008 Writer: Richrd Tkachuk and Thomas Kejser Technical Reviewers: T.K. Anand, Marius Dumitru, Greg Galloway... Posted Feb 15 2009, 11:49 AM by tkejser with | with 7 comment(s) Filed under: Performance, Analysis Services, Tuning

• The Data Loading Performance Guide 2008

  SQL Server Technical Article Published: January 2009 Writers: Thomas Kejser, Peter Carlin and Stuart Ozer Contributors: Sunil Agarwal, Ted Lee, David Schwartz... Posted Feb 15 2009, 07:38 PM by tkejser with | with 2 comment(s) Filed under: Performance, etl, Bulk Insert, Tuning, SQL Server

• Tuning the Performance of Change Data Capture in SQL Server 2008

  SQL Server Best Practices Article Published: November 2008 Writer: Steffen Krause Contributors: Sanjay Mishra, Gopal Ashok, Greg Yvkoff, Rui Wang Technical... Posted Nov 24 2008, 02:50 PM by SanjayMishra with | with 4 comment(s) Filed under: Performance, Loading, Concurrency, Capacity, Operations, Change Data Capture, Transaction Log

• Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations

  Published : October 2008 Writers : Lindsey Allen, Mike Ruthruff, Prem Mehra Reviewers : Cindy Gross, Burzin Patel, Denny Lee, Michael Thomassy, Sanjay... Posted Oct 03 2008, 01:38 PM by Lindsey.allen with | with 39 comment(s) Filed under: Performance, SQL, Consolidation, Virtualization

• Best Practices for Semantic Data Modeling for Performance and Scalability

  Published : August 2008 Writer : Sharon Bjeletich Reviewer : Thomas Kejser More and more business applications are architected as business frameworks,... Posted Sep 03 2008, 11:20 PM by SanjayMishra with | with 8 comment(s) Filed under: Performance, Scalability, design, Data Modeling, Semantic