New possibilities of MS SQL Server 2016 in Lime Systems solutions

MS SQL Server 2016 features used in Lime Systems financial software solutions for data processing, storage and analytics.

Modern databases continue to grow the functionality of processing and storing large amounts of information. This allows development companies to process and store the client information more effectively, undertake the multilevel analysis, and ensure the bigger relevance in decision-making. The Microsoft company, in its SQL Server 2016 solution, offered interesting and much-needed mechanisms, some of which were used by Lime Systems.

Let us remember that officially the partnership of Lime Systems with Microsoft started in 2004, and in 2011 the company received the status of Golden Partner of Microsoft, which shows the high level of the company’s specialists and solutions as a whole.

We distinguish several key changes that influenced the efficiency and peculiarity of the work of MS SQL Server 2016:
Least vulnerable database — high accessibility and disaster recovery
New features of SQL Server 2016 in the sphere of security allow protecting data for critically important workloads. Due to the multilevel approach to security, including a reliable mechanism of audit, transparent data encryption (TDE) mechanism, and others, the requirements of controlling bodies for critical information storage are fully met.

High productivity — SQL Server 2016 is keeping the leadership in all the productivity tests, which use the workload TPC-E (OLTP), TPC-H. The results of synthetic tests find their confirmation when realizing real tasks in real systems.
SQL Server 2016 includes wide possibilities for database management and maintenance. The extended list of operations, which can be performed in the ONLINE mode, significantly simplifies the tasks of administration, allowing the time of data non-availability to a significant extent.

Apart from that, SQL Server Management Studio received a useful possibility — Live Query Statistics, which allows monitoring of the query realization process. The data received as a result (time, %% of realization, quantity of data) are used for optimization.

It should be specially emphasized that Microsoft announced special conditions on migration to SQL Server 2016 from the competitive platforms. According to the idea of the corporation, this offer would make the unified solution on data storing, protection, processing, and analysis more affordable for those organizations that invested in the platforms of other producers. Such special conditions, which will help to economize on the cost of licenses for a new product, development of a migration plan, and training, would also be interesting to banking departments.

Benefits of SQL Server 2016 for secure, high-availability database platforms in banking and other mission-critical environments.