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

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 guidesreflect the knowledge gained by the CAT team while working with customers onmission-critical deployments, many of these deployments being the result ofdeep customer engagements by the CAT organization. Each guide provides not onlythe key… Read more

Why can’t I attach a database to SQL Server 2008 R2?

Recently, a problem was presented to me by a DBA using SQL Server 2008 R2.  He could not attach a database whose fileshad been copied from another server. This blog talks about the situation and the solution.  Here are the steps he went through to arrive at his situation. DBA #1 logs into a remote… 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

New Version of Partition Management Utility Available

I’m happy to announce availability of an updated version of the SQL Server Partition Management tool – now offering full support for SQL Server 2008 as well as improvements in handling SQL Server 2005.  The tool is available along with source code at http://www.codeplex.com/SQLPartitionMgmt. If you’re not already familiar with the tool, it provides a… Read more

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 to be switched-in must… Read more

New Best Practices Whitepaper published: "Best Practices for Migrating Non-Unicode Data Types to Unicode"

The database system in a company that is growing internationally must support multilingual characters in tables with Unicode data types. Existing databases that support only non-Unicode information must be migrated from non-Unicode data type to Unicode data type. This paper summarizes best practices for migrating database systems from non-Unicode to Unicode data type. http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL_bestpract_MigrationToUnicode.docx… Read more

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 all… Read more