SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.
 
Top 10 Lists: Review our summary list of best practices, recommendations, and common issues.

Top 10 List

View All Articles>
SQLCAT Blog Mirror: Review our tips and tricks from enterprise customer lessons learned; mirrored from our SQLCAT Blog at http://blogs.msdn.com/sqlcat.

Blog

  • 436 Views 3 Comments

    Ultimate guide to upgrading to SQL Server 2008

    For the ultimate guide to upgrading to SQL Server 2008, please refer to the SQL Server 2008 Upgrade Technical Reference Guide . A successful upgrade to SQL Server 2008 should be smooth and trouble-free. To achieve that smooth transition, you must devote...
  • 488 Views 0 Comments

    SQL Server 2008 Analysis Services Performance Guide now available

    Thomas Kejser and I made some significant updates to the SQL Server Analysis Services Performance Guide for SQL Server 2008 - it's available here . Our hope is to keep it alive and make updates as necessary. So if there is something you'd like...
  • 1,050 Views 1 Comments

    Best Practices for Integrated Full Text Search (iFTS) in SQL 2008

    This blog is a result of lessons learned while working with the new Integrated Full Text Search in SQL Server 2008. It is not intended to be an in-depth tutorial on how to implement it. Instead, it will concentrate on best practices. The basics of how...
  • 448 Views 0 Comments

    12,000 Concurrent Siebel CRM 8.0 Users On SQL Server 2008

    Recently, Wanda He from SQLCAT ISV team worked with Oracle Siebel group completed a new 12,000 concurrent users Siebel CRM 8.0 benchmark on SQL Server 2008 ( http://www.microsoft.com/isv/oracle/ ). The benchmark demonstrated that the combination of Microsoft...
  • 562 Views 0 Comments

    Reporting Services Scale-Out Deployment Best Practices

    Check out the the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series: Reporting Services Scale-Out Deployment Best Practices This technical note reviews the SSRS...
  • 504 Views 0 Comments

    Reintroducing sqlcat.com

    Check out the new look and feel of the sqlcat.com ! Now you have easy access and views of our Top 10 Lists, Technical Notes, Whitepapers, and Toolbox. As well, now our blogs our mirrored to sqlcat.com for easy access to all SQLCAT tips, best practices...
View All Articles>
Technical Notes: Deep level technical short papers on specific SQL Server topics

Technical Notes

View All Articles>
Whitepapers: Deep level technical whitepapers on specific SQL Server best practices.

Whitepapers

View All Articles>
Toolbox: Check out our toolbox of helpful tools and scripts.

ToolBox

View All Articles>

Resources

CSS Experts Blog: Great SQL Tips and Best Practices from SQL Escalation engineering team

SQLCAT ISV Team blog: Great SQL tips and best practices from the SQLCAT ISV team


Technical Spotlights

Check out our technical end-to-end studies on customer implementations


Presentations

Check out our presentations, radio, podcasts, and webcasts

sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
Copyright 2008 Microsoft Corporation. All Rights Reserved.