Browse by Tags

• Development & Programming
• Manageability & Serviceability
• Manageability &amp
• Migration and Transition
• Performance and Scalability
• Programming
• SQL Server

• 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

• FoxPro to SQL Server migration experience

  At first I was going to write a detailed white paper about the conversion effort. But someone has already done it. There is a series of very good guides at: http://www.ciol.com/content/special/foxpro/foxpro_Special.htm Since FoxPro is nearing its end Read More... Posted Saturday, January 26, 2008 4:52 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: SQL Server, Migration and Transition, Programming, 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