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

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, Mosha Pasumansky, Akshai Mirchandani, Edward Melomed, Jonathan Ehren, Mark Tameling, Mukesh Kumar Technical ... 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
  • 234 Views 0 Comments

    Optimizing CREATE SET in Cube Calculation Scripts

      Posted by: SQL Server Customer Advisory Team
    • 08-31-2010
    Author: Thomas Kejser Reviewers: Peter Adshead, Nicholas Dritsas, Sanjay Nayyar, John Desch, Kevin Cox, Akshai Mirchandani, Anne Zorner In this blog we will describe an important optimization that you should apply to cubes that are processed often and...
  • 383 Views 0 Comments

    New Release of SQL Server Migration Assistant (SSMA) includes migration from MySQL and to SQL Azure

      Posted by: SQL Server Customer Advisory Team
    • 08-13-2010
    Wanted to let the community know the SQL Server Product Group just released version 4.2 of the SQL Server Migration Assistant! With this version, Microsoft has announced the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL...
  • 1,698 Views 0 Comments

    Loading data to SQL Azure the fast way

      Posted by: SQL Server Customer Advisory Team
    • 07-30-2010
    Introduction Now that you have your database set up in SQL Azure , the next step is to load your data to this database. Your data could exist in various sources ; valid sources include SQL Server, Oracle, Excel, Access, flat files and others. Your data...
  • 1,040 Views 0 Comments

    Identifying query compile/runtime parameter values using XML SHOWPLAN output.

      Posted by: SQL Server Customer Advisory Team
    • 06-09-2010
    I recently returned from Convergence 2010; the annual North American Microsoft Dynamics User Conference in Atlanta. It was a really great conference with many Customer, Partner, and Microsoft presentations and success stories. It was inspiring to see...
  • 792 Views 0 Comments

    Win a signed PowerPivot Architecture Technical Diagram at TechEd NA 2010!

      Posted by: SQL Server Customer Advisory Team
    • 06-06-2010
    There are many reasons to go to TechEd North America 2010 in New Orleans this year. After all, it is THE event for developers and IT Professionals. And if you want to know more about PowerPivot, here’s yet another reason why you need to go. There...
  • 930 Views 0 Comments

    SQL Azure Customer Best Practices

      Posted by: SQL Server Customer Advisory Team
    • 05-28-2010
    The SQLCAT team and the SQL Azure team have been working closely together with a number of customers even before we launched our CTP (Community Technology Preview) in November, 2009 at the PDC (Professional Developers Conference). After our production...
View All Articles>
Toolbox: Check out our toolbox of helpful tools and scripts.

ToolBox

View All rss
  • 1,783 Views 1 Comments

    ASLB Toolkit

    Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser The ASLB toolkit...
  • 4,218 Views 0 Comments

    Response Time Analysis using Extended Events

    Contributors: Raoul Illyes, Sanjay Mishra, Jerome Hallmans, Thomas Kejser, Mario Broodbakker This tool demonstrates response time analysis at the session...
  • 2,660 Views 0 Comments

    Restart SQL Audit Policy and Job

    Authors : Ayad Shammout, Denny Lee, Jack Richins As noted within the Reaching Compliance: SQL Server 2008 Compliance Guide (you can also check the sqlauditcentral...
  • 3,647 Views 0 Comments

    SSIS Package For Collecting SSAS DMV Data

    SSIS Package For Collecting SSAS DMV Data at http://www.codeplex.com/SQLSrvAnalysisSrvcs This project on Codeplex includes an SSIS package along with its...
  • 3,901 Views 0 Comments

    SSAS Monitoring Scripts For Management Data Warehouse

    SSAS Monitoring Scripts For Management Data Warehouse at http://www.codeplex.com/SQLSrvAnalysisSrvcs This project on Codeplex includes scripts for creating...
  • 5,370 Views 1 Comments

    SQL Server Partition Management Tool

    SQL Server Partition Management Tool is available at http://www.codeplex.com/SQLPartitionMgmt with source code. This tool provides a set of commands (at...
View All Articles>

Resources


Technical Spotlights

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

Check out our presentations, radio, podcasts, and webcasts

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.
For more information about PowerPivot, check out the SQLCAT series of PowerPivot postings
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.