SQL versions compatible with Windows Server 2012

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

and http://blogs.msdn.com/b/vsanil/archive/2012/11/12/what-is-the-benefit-of-installing-sql-2012-on-windows-2012.aspx

R2 wave: http://blogs.technet.com/b/microsoft_blog/archive/2013/08/14/ve-the-date-windows-server-2012-r2-windows-system-center-2012-r2-and-windows-intune-update-coming-oct-18.aspx



About mauriciorpp

Hi, I am Piccolo - but not the one from Dragon Ball. I'm from a highly competitive and fast-paced world too, the IT industry, and this space will be used to share some challenges I face daily on my career. As you will see, I don't do brawls but I need to be a fighter! Stay tuned.
This entry was posted in SQLServer, Windows and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s