"The best time to plant a tree is twenty years ago, the second-best time is now" Chinese Proverb
SQL Server 2014 SP 2 introduced an interesting feature to provide a data free copy of a production database.
PowerShell provides an extremely efficient method to globally clean up and drop objects within your SQL Server estate based on some pattern matching in the object names. Some of the reasons you may wish to do this are: -
The SQL Server 2016 Upgrade Advisor is a great graphical user interface for analysing your existing SQL Server database to discover any features or syntax you are using that are not compatible with a 2016 upgrade.