Lead Image © alphaspirit, 123RF.com
What's new in SQL Server 2016
Faster, Safer, Mobile
A fairly stable Community Technology Preview version 2.2 of SQL Server 2016 has been available since July 2015. With the newest release, Microsoft wants to optimize the features that have already been on board since SQL Server 2014. Microsoft places great emphasis on providing databases quickly and efficiently for analysis. This includes in-memory data processing. In this process, SQL Server stores frequently used tables directly in the working memory to provide faster access. It should also be possible to process real-time data better and faster in the future.
In addition to real-time processing, Microsoft has also worked on availability of data and expanded the business intelligence (BI) capabilities accordingly. If you have been using a BI system based on SQL Server up to now, it usually only received its data for processing at certain times – often just once a day. For example, if you use the BI system to analyze payment transactions, the analyses could only be carried out previously if the data was transferred to the server. However, in SQL Server 2016, you can access the source data from the data warehouse in real time using in-memory Columnstore and in-memory online transactional processing (OLTP), allowing you to analyze the data in the BI system in real time. This application is just one example of many.
Generally, with SQL Server 2016, Microsoft wants a massive speedup in the analysis of real-time data and transactions and to make it possible for many applications to store data in-memory. Applications that rely on this database (e.g., to analyze data) use these features transparently. The analysis applications themselves therefore don't need to support the real-time analysis process, because the underlying database manages the technology itself. The application just needs to access the processed data. SQL Server 2016 also monitors and optimizes queries via the Query Store and can store them for later use.
SQL Server 2016 is optimized
...
Buy this article as PDF
(incl. VAT)
Buy ADMIN Magazine
US / Canada
UK / Australia
Related content
-
Connecting Windows Server 2016 with Azure
Microsoft continues to integrate Windows Server with the Azure cloud. With Cloud Witness and the RDS Connection Broker, you can operate distributed environments more reliably and efficiently, and SQL databases migrate sensibly into the cloud. -
SQL Server 2022 and Azure
SQL Server 2022 focuses on even closer collaboration between on-premises SQL servers and SQL functions in Azure, including availability and data analysis. We highlight the innovations of the database server and the interaction with versatile and powerful Azure services. -
Replication between SQL Server and Azure SQL
Wherever Microsoft SQL Server runs on local networks, individual or all databases can be migrated to Azure SQL by transactional replication. Various opportunities unfold, including analytics in the Azure cloud and global access routes for mobile users and home and branch offices. -
What's new in SQL Server 2017
Microsoft SQL Server 2017 introduces SQL Server on Linux, along with machine learning services, support for graph data, and on-premises Power BI. -
Windows Server 2016 for small servers
Small businesses often do not need the full-blown version of Windows Server 2016. If the application scenarios are manageable, the cheaper Essentials version is the ideal solution; however, it does come with a number of restrictions.