SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.
 
 

Featured

SQL Server Consolidation Guidance

Writers: Sung Hsueh, Antony Zhong, Madhan Arumugam Technical Reviewers: Claude Lorenson, Clifford Dibble, Lindsey Allen, Sambit Samal, Sethu Kalavakur, Prem Mehra, Sameer Tejani, Il-Sung Lee, Jack Richins, Brian Dewey, Mathew John, Jamie Reding, Jonathan ... More
Whitepapers: Deep level technical whitepapers on specific SQL Server best practices.

Whitepapers

View All rss
View All Articles>
Technical Notes: Deep level technical short papers on specific SQL Server topics

Technical Notes

View All rss
View All Articles>
Top 10 Lists: Review our summary list of best practices, recommendations, and common issues.

Top 10 List

View All rss
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

View All rss
  • 202 Views 0 Comments

    Full Text Indexing Terabytes of Files with SQL Server and Cloud Storage

      Posted by: SQL Server Customer Advisory Team
    • 02-02-2010
    Author: Darko Sancanin, Nicholas Dritsas Reviewers and contributors: Lubor Kollar, Stuart Ozer, Michael Thomassy Business Case There are currently over 50 million files (over 10 Terabytes of data) that the customer is migrating into a custom project management...
  • 731 Views 0 Comments

    Whitepaper About Star Join Optimizations

      Posted by: SQL Server Customer Advisory Team
    • 12-16-2009
    When we talk to Data Warehouse customers – they often raise questions about the star joins improvements SQL Server 2008. Star join is a set of optimizations that provide some interesting performance gains in data warehouse workload. Instead of digging...
  • 788 Views 0 Comments

    Monitoring free space in tempdb transaction log

      Posted by: SQL Server Customer Advisory Team
    • 12-14-2009
    Author: Thomas Kejser Reviewers: Peter Byrne, Sunil Agarwal, Prem Mehra, Peter Scharlock, Lindsey Allen, Mark Souza As part of your database monitoring, you may be keeping track of the free space in the transaction log. One reason to do this, is to detect...
  • 874 Views 0 Comments

    Performance Comparison between Data Type Conversion Techniques in SSIS 2008

      Posted by: SQL Server Customer Advisory Team
    • 12-01-2009
    Authors : Sedat Yogurtcuoglu and Thomas Kejser Technical Reviewers : Kevin Cox, Denny Lee, Carl Rabeler, Dana Kaufman, Jesse Fountain, Alexei Khalyako, Dana Kaufman Overview Data type conversion is one of the most common ETL tasks used in Microsoft® SQL...
  • 860 Views 1 Comments

    PowerPivot for SharePoint Installation Guides DRAFT

      Posted by: SQL Server Customer Advisory Team
    • 11-20-2009
    The installation of PowerPivot for SharePoint can be a little complex at times - especially the PowerPivot for SharePoint multi-server farm scenario. In order to help with this, the Analysis Services team and the SQLCAT team came together and created...
  • 1,498 Views 1 Comments

    PowerPivot Jump Start!

      Posted by: SQL Server Customer Advisory Team
    • 11-10-2009
    As you may already know, the new name for Project Gemini is PowerPivot and the official names are PowerPivot for Excel and PowerPivot for SharePoint. For information and to sign up for notification on the release dates, check out the official PowerPivot...
View All Articles>
Toolbox: Check out our toolbox of helpful tools and scripts.

ToolBox

View All rss
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
Search
Sign In

Recent Posts

Other Languages

Popular Tags

 
CAT | Customer Advisory Team | Meet the members of the largest SQL Server implementation team.
Copyright 2008 Microsoft Corporation. All Rights Reserved.