As a counterpart to my recent survey on what the oldest version of SQL Server you have in production (see the results here), I kicked off a survey last week asking what the newest version of SQL Server is that you have in production.
Here are the results:
I’m not surprised by these results, and they reflect the straw-polls I do at the start of each class we teach. We’re seeing a ton of people putting 2012 into production and there’s a lot of interest in AlwaysOn Availability Groups because of the ability to have multiple copies of the primary, and direct reads on secondaries without having to use clunky database snapshots (like you have to do with database mirroring).
One thing I couldn’t get from the two surveys was the average spread of versions in production. What I can tell you from my class straw-polls is that most of attendees who are using 2012 also have older versions in production too. My impression is that more people are kicking the tires of 2012 by having it in production in some way, rather than having it in a test environment and then doing a comprehensive roll-out.
Anyway, glad to see a strong adoption rate for 2012!