Times of change are ahead of us. Lately the technology reached some kind of plateau, with performance and features staying relatively at the same level for several years. Go and check the hardware market: despite some big savings on power, the fastest CPU cores from a couple of years ago are still in the “fastest block”. The same goes for software: from 2006 until 2012 we did not have the kind of big changes that happened a few years before.
I know, there were changes and improvements, of course. They were just not big as the changes that happened before. The end result is that we have fewer compelling reasons to upgrade. If not much changed, why hurry? But we must not let this keep us preventing from using the latest and the greatest. So go ahead, do your research and deploy the latest versions, there are incremental benefits waiting for you. And I’m not even talking about the cloud, this is a separate topic.
TLDR: here are some considerations for using the latest OS and SQL versions. Push forward, and if you have any considerations to share please fell free to add your comments on this post.
- SQL 2005 is not supported on Windows 2012
- Windows 8 comes with .NET 4.0, and SQL 2012 requires .NET 3.5 – enable it first
- SQL2008R2 has some issues with clustering on Windows 2012
For more details, please read the full article: http://support.microsoft.com/kb/2681562
SQL 2012 Express with SP1 download: http://www.microsoft.com/en-us/download/details.aspx?id=35579 (I’m still trying to find the stand-alone SSMS installer for 2012).
And for some benefits of using both the latest and greatest: http://blogs.technet.com/b/dataplatforminsider/archive/2012/12/06/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012.aspx