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

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 this will… Read more

32- and 64-Bit Connectivity from the Same Machine

Author: Chuck Heinzelman Reviewers: Steve Howard, Carl Rabeler, Shaun Tinline-Jones, Mike Weiner, Murshed Zaman   I was recently involved in a customer lab testing the Microsoft Business Intelligence stack.  I noticed an interesting behavior when working on one of my test servers.   Here’s the environment that I was working with: ·         Windows Server 2008… Read more

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 the complexity of your database application. Otherwise,… Read more

Reporting Services Scale-Out Deployment Best Practices

[Update 17 Aug 2017: the link below is broken; but you can find the original paper and many more in a consolidated PDF form at SQLCAT’s Guide to BI and Analytics] Check out the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series:… Read more

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 HTTP 503 Service Is Unavailable errors as… Read more