Browse by Tags

Tagged Content List
  • Blog Post: AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios

    Author : Sanjay Mishra Contributors : Piyush Ranjan, Steven Schneider Reviewers : Ed Muth, Chuck Heinzelman, Silvano Coriani, Rama Ramani, Juergen Thomas, Cephas Lin, Lori Clark, Luis Carlos Vargas Herring Once you have created AlwaysOn Availability Groups in Windows Azure VM ( tutorial ) and created...
  • Blog Post: SQLCAT.Com - eBook Downloads

    As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication. MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated...
  • Blog Post: SQLCAT.com consolidated index of Whitepapers

    In an effort to migrate as much content as possible from SQLCAT.com to the MSDN SQL CAT site we have consolidated all of the Whitepapers published over the last few years. While all of the content actually exists on Technet and MSDN download sites, SQLCAT was a great resource to start looking. Hopefully...
  • Blog Post: Technical Reference Guides for Designing Mission-Critical Solutions using SQL Server are available

    The Technical Reference Guides for Designing Mission-Critical Solutions provide planning and architecture guidance for various mission-critical workloads deployed by users. These guides reflect the knowledge gained by the CAT team while working with customers on mission-critical deployments, many of...
  • Blog Post: Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot

    Author : Shaun Tinline-Jones Reviewers : Mike Ruthruff, Sanjay Mishra, Alexei Khalyako Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot...
  • Blog Post: “QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query

    Author : Shaun Tinline-Jones Technical Reviewers : Thomas Kejser, Steve Howard, Jaime Alva Bravo, Kun Cheng, Jimmy May Note: Validation for this post was performed in the SQL CAT Customer Lab on an HP Proliant DL580 G7 , Intel Xeon Nehalem E7-4870 2.40 GHz 4 socket, 10 physical cores, 20 logical...
  • Blog Post: Optimize Recursive CTE Query

    Author : Shaun Tinline-Jones Reviewers: Lubor Kollar; Conor Cunningham; Steve Howard; Kun Cheng; James Podgorski; Jimmy May; Joseph Sack; Welly Lee; Neeraj Joshi; Keith Bauer Introduction We recently assisted a global ISV to address a performance issue related to a poor performing recursive...
  • Blog Post: Linked Servers to SQL Azure

    Authors: Kevin Cox & Michael Thomassy Contributors: Lubor Kollar Technical Reviewers: Shaun Tinline-Jones, Chuck Heinzelman, Steve Howard, Kun Cheng, Jimmy May Overview Connecting directly to a SQL Azure database from a reporting tool (like Microsoft Excel and PowerPivot, or SQL Server...
  • Blog Post: SQL Azure Customer Best Practices

    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 release in January, 2010, we've continued working...
  • Blog Post: Character data type conversion when using SQL Server JDBC drivers

    Author: Kun Cheng Reviewers: Wanda He, Kevin Cox, Michael Thomassy, Peter Scharlock 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...
  • Blog Post: 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 plan sufficiently for the upgrade, and match...
  • Blog Post: 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 the new full text search feature works is found in...
  • Blog Post: SQL PASS 2008 Just may be the best PASS Conference yet

    Coming up this November 18-21 st is the SQL PASS Conference in Seattle, WA (right in Microsoft’s backyard). See http://summit2008.sqlpass.org/ for all the details. This SQL PASS will be very special. The SQL Server engineering team is sending up to 300 developers to the conference. You won’t have to...
  • Blog Post: New Best Practices Articles Published - Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned

    Due to the improvements in the Windows Server 2008 memory manager related to the change in the algorithm for scanning pages in memory, SQL Server 2008 Analysis Services performed equally well during both partition and dimension processing with or without memory preallocation when running on Windows Server...
  • Blog Post: New Best Practices Articles Published - Scaling Up Reporting Services 2008 vs. Reporting Services 2005: Lessons Learned

    Reporting Services 2008 was able to respond to 3–4 times the total number of users and their requests on the same hardware without HTTP 503 Service Is Unavailable errors compared with Reporting Services 2005, regardless of the type of renderer. In stark contrast, Reporting Services 2005 generated excessive...
  • Blog Post: SSIS 2008 - world record ETL performance

    Using SQL Server 2008 and SSIS 2008 the SQL Server Performance team working with Unisys and SQL CAT have shown SSIS scaling to world record performance! We loaded 1.18 TB in under 30 minutes . You can find more information here: http://blogs.msdn.com/sqlperf/archive/2008/02/27/etl-world-record...
  • Blog Post: Introducing SQLCAT.com

    The SQL Customer Advisory Team has put the final touches on the site http://sqlcat.com/ which is our new hub for all things that are part of the SQLCAT! Our new site is a portal to all SQLCAT resources including: Top 10 Lists : Summary list of Best Practices and Recommendations Technical Notes...
  • Blog Post: New Partition Management Tool Available on Codeplex

    As anyone working with partitioned tables knows by now, the process of creating stand-alone ‘staging’ tables to support switching data into or out of a partition can be a management challenge, especially if the design of the partition table or its indices change over time. A staging table for new data...
  • Blog Post: FoxPro to SQL Server migration experience

    At first I was going to write a detailed white paper about the conversion effort. But someone has already done it. There is a very good guide at: http://nationalcom.com/home/download/Conversion-VFP-SQLServer.pdf Since FoxPro is nearing its end of life, the company I was working with needed to convert...
  • Blog Post: SQL Server 2005 Best Practices Analyzer (January 2008) -- Now Available!

    It's a new year and, with it, we come bearing gifts! We have a pretty significant update to SQL Server 2005 Best Practices Analyzer . It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools. And...
Page 1 of 1 (20 items)