Category Archives: Upgrades
-
Dynamically generate the command line DMA statement for each database
Leave a commentJune 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 -
Fixing Data Migration Assistant timeouts
2December 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 -
The new Data Migration Assistant has been released!
4August 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 -
What is the database property “Compatibility Level”
7July 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 -
Clean up all (most) of the orphans on an instance
3June 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 -
Required reading before upgrading SQL Server.
4October 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
