my 50 cents:
- I would suggest to swap step 1 and 2 in post-work, because in one particular case I got errors with DBCC CHECKDB which were fixed with the UPDATE USAGE statement
- reviewing collation should be part of pre-work
- Also I run step 8 of post-work as pre-work, before restoring the database on the new server.
- After taking the latest full backups on the source server, I'll put these databases in OFFLINE mode, to be sure no connections are made to the old server (after step 4)
- after installing SQL server (step 8 of pre-work), I'll run the server default configuration settings like DAC enabled, compression enabled etc. Step 2 of Data-loads is actually a part of this configuration
One thing which is not mentioned: You can only restore 2008+ in SQL 2014, if you have a SQL2005 (or SQL2000 :w00t: database), you'll have to restore it first to an intermediate version. This because only 3 lower compatibility levels are supported.
The best things in life are the simple things