Microsoft SQL Server

SQL Server Core Engineer Tips

July, 2009

  • Migration SQL Server 2000 DTS to SSIS 2005/2008

    Migration DTS packages to SSIS 2005/2008 Setup SSIS with DTS 2000 On the migration of 2000 DTS to SSIS 2005/2008. There are many known issues in the migration of DTS 2000. It is recommended to execute the DTS inside SSIS 2005/2008 without migration. And...
  • Migration SQL Server 2000 to SQL Server 2008

    The purpose of this post is to explain the minimum required for the migration of Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You can use the same principles to migrate a Microsoft SQL Server 2005 to Microsoft SQL Server 2008. 1. SQL server...
  • Which Service Pack do I have to install on SQL Server ?

    The model of delivery patch for Microsoft SQL server follows a very precise process that is described in the following article : http://support.microsoft.com/kb/935897/ We always recommend applying the latest Service Pack (SP) for SQL. However, you should...
  • Welcome to SQL Server ryders

    Hello all, My name is Michel Degremont. I'm Technical Specialist on SQL Server since 4 years @ Microsoft EMEA. I've just created this blog to share with you various experience and question that I am meeting regularly. In this blog, I will talk about Microsoft...