Contact Us




Change Locale

Everything you need to know about SQL Server 2016

Microsoft | Posted on November 24, 2015

Microsoft SQL 2005 is going EOL on April 12, 2016, and the all-new SQL Server 2016 stands to bring the biggest, most exciting changes to SQL since its inception. Our Microsoft team recently hosted a private webinar for some of our best Microsoft clients, and shared their perspectives on what to expect with the new platform.

I’ve captured some of the key messages from the event. However, if you’d prefer to experience the Softchoice expert-led talk first hand, please watch the recorded broadcast now:

SQL Roadmap: 2005 End of Support

First up on the agenda was some important reminders about SQL 2005’s ever-nearing end of support. Mainstream support is already offline, and has been since July 2014. But for those of you with extended support, you only have until April 12, 2016 to upgrade to a secure, up to date version.

What if you don’t? We reminded our webinar guests that this means three big things: no more security updates; higher maintenance costs; and more likelihood that you may fail on compliance standards.

SQL Roadmap: SQL 2016 Preview

We also touched on some of the incredible new features of SQL 2016 – features that might just speed up your upgrade of 2005 if the risks above aren’t enough to sway you.

SQL 2016 comes packed with more in-depth, encrypted security, in-memory improvements, a mobile-friendly BI and Analytics dashboard, a stretch database for hyper-scale in the cloud, built-in advanced analytics and more.

SQL 2016 Features & Enhancements

Key Licensing Considerations for SQL 2016

Next, we covered the basics you need to know when licensing SQL 2016.
This comes down to two things: knowing which of the three licensing editions is right for you (you can select among SQL Standard, SQL BI and SQL Enterprise) and the new per-core model.

Per-core is a big one. What this means is that SQL is now licensed by core with a minimum of 4 cores per processor. If a server has 2 cores it must be licensed for 4 cores. If a server has 6 cores then 6 cores licenses. Important to note that each SQL license is for 2 cores.

SQL 2016 Licensing options

Assessing your environment

Attendees also learned about the importance of properly assessing their readiness before embarking on a SQL upgrade. Doing so ensures you have the best shot at not over-paying for licenses, and reduces your exposure to compliancy issues.

Softchoice has a proven methodology to help you know exactly what you need, called the SQL Server TechCheck Assessment. The TechCheck will point you to the lowest cost SQL licensing, while keeping you in line with Microsoft’s licensing rules.

You’ll walk away with a full view of your current compliance, as well as a list of possible ways to save, including things like leveraging Azure, when possible.

This is not a small detail – we also shared a case study where a client of ours saved $1.5 million, thanks to consolidations they made after taking our assessment.

Finishing up

We closed the webinar with a brief overview of new SQL deployment options, as well as a Q&A session with our experts. For that, you’ll have to watch the live recording, or simply get in touch with a Softchoice representative today. We’re here to help with all your SQL end of support and 2016 upgrade questions.


Related Articles

Culture | August 6, 2020 by Softchoice

This July, we celebrated our third annual Social Impact Month.   At Softchoice, July serves as a rallying point for every person in the company to generate meaningful impact. With the unprecedented events of this year, it was more important than ever that we looked to better support the communities in which we live and work while building a more giving and compassionate culture.   Although our […]

Culture | July 27, 2020 by Softchoice

Toward the end of February, the reality of the COVID-19 pandemic was becoming more evident to the Softchoice leadership team. Our People and Growth leaders knew they would need an agile response to keep our people and our customers safe.    Our business continuity plans to address technology redundancy were in place.  As a result of processes that had been in place for 3 years, we were perhaps ahead of most in our ability to move to a full remote work […]

Culture | June 17, 2020 by Softchoice

In 1989, Jone Panavas founded Softchoice along with David Holgate to make it easier for businesses to source and acquire hard–to–find software products. Jone and David set out to make Softchoice a different kind of company from the very beginning, one where inclusiveness was a core tenet and employees were encouraged to bring their authentic selves to work.   While the technology landscape has become far more complex in the last 30 years, another […]