Skip to the content

Microsoft Announce General Release of SQL Server 2016

SQL has long been the go-to database platform providing market leading security and Business Intelligence (BI) capabilities. Now Microsoft have released SQL Server 2016, which is packed full of new features. As a company specialising in business management software (i.e. Microsoft Dynamics® NAV) with SQL databases at their core, our focus is on the real world benefits to people trying to manage their business systems. Here we will look at some of the key features.

SQL Server 2016: Everything Built In

The reality of The Internet of Things (IoT) and Big Data is that it is becoming more than just something that is talked about by experts and something that businesses are actually using to drive performance. SQL has a wide range of features that are not only part of the package but actually built in to the core of its operation. This helps to reduce the effects of increased performance requirements and makes the functionality much more usable.

In-database Advanced Analytics

Most databases get analytics based on moving data to the application tier; as data volumes increase the burden on the application tier increases creating high latency which effects database scalability. SQL allows you to analyse operational data in real time using R Services from directly within the SQL Server database. This means that data does not need to be moved for analysis and greatly improves both the performance and scalability of the system.

End to end mobile BI

Microsoft have been making a big push on making big use of Big Data, with it’s market leading Power BI application bringing Business Intelligence (BI) from the bottom of a list of software benefits to a key selling point. As part of the BI reporting road map, the latest release of SQL marks a significant milestone for SQL Server Reporting Services (SSRS). The Microsoft SQL Server Mobile Report Publisher allows a simple connection to SSRS to access data and create attractive and meaningful reports and publish them via web and mobile devices. Included as part of the Power BI app, the single unified mobile experience allows for easier access to dashboards and reports.

Least Vulnerable Database

SQL has an unmatched security record, with six years of achieving the least number of vulnerabilities of any major database platform. This data is compiled by the independent government agency, the National Insitute of Standards and Technology (NIST). The Always Encrypted features allow developers to protect data allows trust from businesses with mission critical data work-flows.

Industry Leading OLTP

In-Memory Online Transaction Processing (OLTP), also known as In-Memory Optimization, is the latest in Microsoft’s processing technology. The effect is that the data processing is the highest on the market based on a high availability of the data. When originally shipped with SQL server 2014 (code named Hekaton) there were certain limitations such as limited memory of tables, limited data type, etc.

With SQL Server 2016 Microsoft has addressed most of these restrictions, allowing you to take advantage of the many performance improvements without any of the previous issues that blocked the adoption of the platform.

From on-premises to Cloud

Microsoft’s big push for cloud applications and cloud storage has been at the forefront of their developmental road map. With the latest release of SQL they have provided a consistent experience across servers and database as a service. This makes it easier for companies to adopt the platform whether their data is in a datacentre, private cloud or in Microsoft Azure, allowing for easier transition between these hosting platforms.

SQL Server Training

To find out more about using SQL server, why not get trained by the experts by booking on to our SQL Server Basics training course.

Book Now

Jesse Lawrence

Jesse is our marketing manager, keeping an eye on the latest news in the market as well as having worked on the GDPR legislation. 

comments powered by Disqus

Latest Blog Posts

I find their approach to our relationship very professional whilst being refreshingly realistic. We now consider them to be part of our team

Lee Crowhurst, Technical Director

Partner with the Experts

With over 200 years of combined experience in Microsoft business solutions, our team will help to get you up and running, as well as building a partnership that keeps you supported, all from our UK offices. 

From functionality and licencing to business strategy, we like your questions; contact our experienced team for open, honest and reliable advice so that we can find the answers.