Be Mindful of Deprecated Features in SQL Servers

It’s important to always be mindful when moving databases between SQL version that implemented features have not been deprecated in later editions. Below is a list of deprecated features moving to SQL 2008 R2;

http://msdn.microsoft.com/en-au/library/ms143729(v=sql.105).aspx

… and SQL 2012;

http://msdn.microsoft.com/en-us/library/ms143729

Always remember to check your databases and environment using the relevant SQL Server upgrade advisor so you don’t run into any unexpected outages!