Category Archives: Upgrades
-
SQL Homework – October 2018 – Time for an upgrade
1October 1, 2018 by Kenneth Fisher
When you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was …
Continue reading -
Dynamically generate the command line DMA statement for each database
1June 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!
5August 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