We had a database and lots of functionality that worked fine in SQL Server 2008 R2. We recently upgraded both our development and production servers to SQL Server 2014. Unbeknownst to us, our development server stayed in compatibility mode for 2008 R2, but the Prod box is in Compatibility Mode for 2014.
My question, is where can I find what changed between SQL/Compatibility versions so we will know what needs fixing to maintain functionality. I know I can set (or have set) the Prod server to compatibility with 2008 but since I don't administer the prod box, I cannot make that call. My google-fu seems to keep turning up tutorials on how to change the compatibility level, but nothing on what actually changed so I can't tune our queries/procs/functions/etc to work well with the new version.