Browse by Tags

• Analysis Services
• bi
• Development & Programming
• Development &amp
• ETL
• Manageability &amp
• Migration and Transition
• Performance and Scalability
• query performance
• Recommended Links
• Reliability and Availability
• Resource Utilization
• Serviceability
• SQL Analysis Service
• SQL Server
• 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

• 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 Read More... Posted Tuesday, February 24, 2009 7:19 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability, Manageability & Serviceability, ETL

• SQLCAT Toolbox

  SQLCAT members have published several tools on Codeplex and other places. They are all consolidated here at SQLCAT.com. http://sqlcat.com/toolbox/default.aspx Read More... Posted Friday, February 22, 2008 4:58 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Manageability & Serviceability, Manageability &amp

• 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 Read More... Posted Tuesday, January 29, 2008 6:02 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: SQL Server, Manageability & Serviceability, Manageability &amp, Development &amp

• 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 d atabases that support only non-Unicode information must be migrate d from non-Unicode data type to Unicode Read More... Posted Tuesday, January 22, 2008 9:18 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming, Performance and Scalability, Manageability & Serviceability, Manageability &amp, Development &amp

• 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 Read More... Posted Saturday, January 19, 2008 7:36 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Analysis Services, Reliability and Availability, Manageability & Serviceability

• New Best Practices Article

  Scale-Out Querying with Analysis Services Using SAN Snapshots Read More... Posted Thursday, September 13, 2007 5:10 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Analysis Services, SQL Analysis Service, Development & Programming, Performance and Scalability, Reliability and Availability, Manageability & Serviceability, query performance, Manageability &amp, Serviceability

• Renaming Olap Databases Issues within Analysis Services

  If you are view the XMLA script that is generated for an Analysis Services database, you will notice that there are both ID and NAME attributes. The reason Analysis Services has this differentiation is so one could rename an Olap database (which you could Read More... Posted Tuesday, July 31, 2007 4:06 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Manageability & Serviceability

• SQL Server 2005 Transactional Replication: Benefit of using SubscriptionStreams for low bandwidth, high latency environments

  Author: Bren Newman Introduction When using Microsoft SQL Server 2005 Transactional Replication, the Log Reader Agent reads the log, constructs SQL statements for published articles and posts it to the Distribution database; the Distribution Agent reads Read More... Posted Tuesday, May 08, 2007 7:00 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability, Reliability and Availability, Manageability & Serviceability

• Check out the exciting new SQL Server Best Practices website.....

  http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. Drawing on the extensive experience and expertise Read More... Posted Saturday, December 09, 2006 8:31 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Resource Utilization, Development & Programming, Performance and Scalability, Migration and Transition, Reliability and Availability, Manageability & Serviceability

• Managing Schema Changes (Part 2)

  SQLCAT Blog: Managing Schema Changes (Part 2) Question: What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability? Answer: In Part 1, we outlined the behavior of SQL Read More... Posted Saturday, April 01, 2006 2:10 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming, Performance and Scalability, Manageability & Serviceability

• Managing Schema Changes (Part 1)

  Question: What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability? Answer: A common requirement as business requirements evolve over time is managing schema changes. Read More... Posted Thursday, March 02, 2006 7:22 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming, Performance and Scalability, Manageability & Serviceability