Category Archives: Upgrades

  1. Dynamically generate the command line DMA statement for each database

    Leave a comment

    June 21, 2017 by Kenneth Fisher

    If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run …
    Continue reading

  2. Fixing Data Migration Assistant timeouts

    2

    December 8, 2016 by Kenneth Fisher

    I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the …
    Continue reading

  3. The new Data Migration Assistant has been released!

    4

    August 31, 2016 by Kenneth Fisher

    Monday Bob Ward (b/t) announced on twitter that the new Data Migration Assistant had been released. First things first the …
    Continue reading

  4. What is the database property “Compatibility Level”

    7

    July 8, 2015 by Kenneth Fisher

    What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in …
    Continue reading

  5. Clean up all (most) of the orphans on an instance

    3

    June 3, 2015 by Kenneth Fisher

    Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone …
    Continue reading

  6. Required reading before upgrading SQL Server.

    4

    October 8, 2014 by Kenneth Fisher

    I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,134 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013