Should You Care About SQL Server 2016?
Share...Tweet about this on TwitterShare on LinkedIn0Share on Google+0Share on Facebook1

As we eagerly await the drop of Microsoft SQL Server 2016 on June 1st, we look at whether the new features are anything to shout about.

In a blog post by Tiffany Wissner, Mircosoft’s Senior Director of Data Platform Marketing, she claims, “Microsoft is delivering an end-to-end data management and business analytics solution with mission critical intelligence for your most demanding applications as well as insights on your data on any device”.

As we know, Microsoft SQL Server 2016, Bigo Live Apk Download for Android brings new features and enhancements compared to the previous 2014 edition but are they worth taking any notice of?

Small/Medium Businesses

At the start of 2015, small businesses accounted for 99.3% of private sector businesses. When you include medium-sized businesses too the percentage increases to 99.9%. With that in mind, how will SQL Server 2016 benefit the majority?

According to Microsoft’s Hermida, small businesses can build their Server on the cloud through Azure. It means customers can pay for the service as they go. Hermida adds, “We have customers who pay for as little as $30 a month, to $300,000 a month, depending on the size and amount of data they have. But both clients enjoy the same capabilities of SQL Server.”

In addition, similar to SQL Server 2014, the 2016 edition will come in four versions; Enterprise, Standard, Developer, and Express. The latter two will be free, making it more accessible for smaller companies.

Big Data

SQL Server 2016 now includes PolyBase. While PolyBase isn’t new, it’ll be new to a lot of businesses using the service. By bridging the gap between Hadoop and SQL, PolyBase provides flexible storage options, platform support and, arguably the most important solution, it allows you to do Big Data without needing to learn a new set of skills. For Data Analysts it means using T-SQL in a common development environment.


SQL Server 2016 has a number of features that help minimise the chance of lost/stolen data. At the core of the new features is Always Encrypted, a feature that encrypts and decrypts your data in the client. The two-step encryption process adds extra protection, but just remember that the data is in the client so don’t encrypt the whole database as it will slow down your performance.

Just like the 2014 edition, SQL Server 2016 features Backup Encryption too. The feature is available in the SQL standard edition (helpful if you’re watching your budget), but because it only encrypts the backup, the feature won’t protect the data at rest on your SQL Server.


One of the most popular, and equally controversial, takeaways from the announcement of SQL Server 2016 is Microsoft’s decision to bring SQL Server 2016 to Linux.

SQL Server for Linux will provide “core relational database capabilities” to allow customers to get started with their deployments. However, more recently news came out supporting that the first release of the port (due in 2017) won’t be as flush with features like the Windows edition. It’s something that has caused backlash; why should Linux suffer a lack of features?

This isn’t an extensive list of all the things the new SQL can do, but it’s definitely some standout elements that we’re excited for. We’ll have to wait and see whether the features live up to their hype. We’ll be marking our calendars…

SQL Server 2016


Share...Tweet about this on TwitterShare on LinkedIn0Share on Google+0Share on Facebook1