Browse by Tags

• bi
• ETL
• Manageability & Serviceability
• Performance and Scalability
• upgrade

• Remember to move DTS2000 packages when upgrading msdb from 2005 to 2008

  Some customers prefer to upgrade to SQL Server 2008 by detaching all databases from their SQL Server 2005 instance and then reattaching them to a completely new SQL Server 2008 instance. If you choose this upgrade strategy, you should be aware that you Read More... Posted Friday, March 20, 2009 9:06 PM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Recommended Links, Manageability & Serviceability, bi, upgrade, ETL

• 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, Read More... Posted Friday, October 17, 2008 3:24 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Recommended Links

• SQL Server Scale Out

  After a few recent conversations with CIO and CTO types, I was amazed that there is still the concept out there that SQL Server doesn’t scale well. So I sat down to write a lengthy blog to dispel that rumor. After doing some research, I found that there Read More... Posted Thursday, June 12, 2008 9:00 PM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability, Recommended Links

• 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 Read More... Posted Sunday, February 03, 2008 3:05 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Recommended Links

• Performance Analysis Tool - DMVStats

  Tom Davidson wrote: I've been working with database applications for the last 25 years. A particular area of interest for me is SQL Server performance. As part of the Microsoft SQL Server Development Customer Advisory Team (SQLCAT) for the last 7 years, Read More... Posted Friday, July 13, 2007 2:38 PM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability, Recommended Links

• Three new best practices articles are available

  Three new best practices articles are available at the SQL Server Best Practices site on Technet ( http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx ). Two of the articles are on Analysis Services Processing and Querying best practices: Analysis Read More... Posted Tuesday, June 12, 2007 4:39 PM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Recommended Links

• New Best Practices Articles are available (May 2007)

  You can check out the three new Best Practices Articles Predeployment I/O Best Practices http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx by Mike Ruthruff Partial Database Availability http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdbavail.mspx Read More... Posted Friday, June 08, 2007 5:02 PM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Recommended Links

• SQL Server Best Practices Website

  http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx Read More... Posted Saturday, December 09, 2006 9:28 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Recommended Links