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 with more SQLCAT learnings.  You can also… Read more

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 cannot detach an msdb database from a SQL Server 2005 instance… Read more

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, and lessons learned. Right now, you can see our graphic noting… Read more

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: Deep level technical short papers Technical… Read more

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, I’ve had an opportunity to observe what works (and more importantly what doesn’t… Read more

Four new best practices articles are available

Four 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 Services Processing Best Practiceshttp://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspxby Denny Lee, Nicholas Dritsas, Carl Rabeler Analysis Services Query Performance Top 10 Best Practiceshttp://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssasqptb.mspxby Carl Rabeler For those of you interested… Read more

New Best Practices Articles are available (May 2007)

You can check out the three new Best Practices Articles Predeployment I/O Best Practiceshttp://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspxby Mike Ruthruff Partial Database Availabilityhttp://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdbavail.mspxby Danny Tambs Comparing Tables Organized with Clustered Indexes versus Heapshttp://www.microsoft.com/technet/prodtechnol/sql/bestpractice/clusivsh.mspxby Burzin Patel, Sanjay Mishra  … Read more