Faster Delivery = Happy Users
Automated Process = Fewer Errors
Standards = Cost Reduction
Order Visibility = Confidence
Linking Systems = Efficiency
While a few enterprises have already made the upgrade, many IT leaders have just begun asking questions about the new database solution, trying to define its place on their roadmap.
We saw this first-hand when nearly 70 IT leaders from across North America joined us for a live video meet up, hosted by Softchoice and Spiceworks
In this expert-led meetup, we discussed performance, new licensing and latest security features of SQL Server 2016.
No surprise, security was one of the top points of interest on the meetup.
The only thing about to SQL upgrades more exciting than security is performance. As the backbone of Big Data-driven businesses, more power is not just nice to have, but crucial.
For anyone running SQL Server 2005 SP4 and onward, you have the ability to migrate directly to SQL Server 2016. Other versions might require a middle step, depending on your service pack. It’s also key to note you have two basic approaches available to you: In Place and Side by Side migrations.
In Place is a full out, immediate swap for businesses who just want to get it over with and start playing. Because of the potential for unanticipated blocking issues and errors, demanding much more upfront care, we prefer Side By side as the go-to approach. This allows you to keep critical, production data safe on older working versions. This happens while you set up a new environment at the same time as and QA.
This is not a new addition because core-based licensing has been the norm since v2012 in enterprise editions. This is still the case. The Standard Edition is designed for less critical apps so you can choose between Core, or Server Plus CAL model. Only choose the latter if counting your users is easy and predictable.
Speaking of editions, one has been removed. The Business Intelligence edition is now gone. If you purchased it and have Software Assurance, you can now transfer up to the Enterprise product.
SQL Server 2016 also backs up Microsoft’s new push toward open technologies. Whereas in the past Linux might have been seen as a competitor, today it is a collaborator. You can now run the SQL database engine on Linux servers.
While the conversations here are useful, you need specific advice on your unique needs and environment. You can find more information on SQL Server 2016 licensing and migration in our free guide here.