SQL Server Customer Advisory Team - SQL Server Best Practices

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

SQLCAT Blogs


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


  • 167 Views 0 Comments

    Optimizing CREATE SET in Cube Calculation Scripts

    • Author: SQL Server Customer Advisory Team
    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...
  • 356 Views 0 Comments

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

    • Author: SQL Server Customer Advisory Team
    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,651 Views 0 Comments

    Loading data to SQL Azure the fast way

    • Author: SQL Server Customer Advisory Team
    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,019 Views 0 Comments

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

    • Author: SQL Server Customer Advisory Team
    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...
  • 767 Views 0 Comments

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

    • Author: SQL Server Customer Advisory Team
    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...
  • 909 Views 0 Comments

    SQL Azure Customer Best Practices

    • Author: SQL Server Customer Advisory Team
    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...
  • 988 Views 0 Comments

    Full-text query in local languages

    • Author: SQL Server Customer Advisory Team
    Author: Kun Cheng Reviewer: Alexei Khalyako Last week, I was presented with an interesting Full-text search problem, which I like to share with you, especially the ones who need to support international markets with SQL Server Full-text solution. The...
  • 904 Views 1 Comments

    Now that SQL Server 2008 R2 has RTM'ed...

    • Author: SQL Server Customer Advisory Team
    We have been pretty excited about the last few weeks where there has been a lot of buzz about SQL Server 2008 R2 RTM. As noted in the SQL Server Data Platform Insider blog posting , this release has a lot of interesting features and is a major release...
  • 1,167 Views 1 Comments

    Resolving DTC Related Waits and Tuning Scalability of DTC

    • Author: SQL Server Customer Advisory Team
    Author: Mike Ruthruff Contributors: Gert Drapers, Fabricio Voznika Reviewers: Prem Mehra, Jimmy May, Kun Cheng During a recent performance lab we encountered a large number of waits related to the use of distributed transactions. The specific application...
  • 1,074 Views 1 Comments

    Character data type conversion when using SQL Server JDBC drivers

    • Author: SQL Server Customer Advisory Team
    In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It started with typical SQL Server performance tuning exercise to identify the most expensive...
1 2 3 4 5 Next > ... Last »
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.