ETL and data warehouses are no longer needed. The possibility of Real-Time Operational Analytics allows in some cases to eliminate all the above mentioned disadvantages, i.e. The traditional approach to analytics has several drawbacks such as: the complexity of implementing ETL processes, the cost of purchasing additional data warehouses and licenses, and one of the most important drawbacks, which is unacceptable for many enterprises, is the delay of data. This is due to the fact that an ETL job is usually executed once a day, for example at the end of a working day, and the data can only be analyzed accordingly the next day. Real-Time Operational Analytics is the ability of SQL server to process both working OLTP load and analytical queries on the same database tables simultaneously, i.e.This feature provides data protection, both at rest and in motion, i.e. personal data) in encrypted form, with the encryption key stored on the client, resulting in a separation between those who own the data and can view it, such as a client whose personal data is encrypted and those who manage the data but should not have access to it, such as administrators or SQL Server programmers. “Always Encrypted”) is a feature that allows you to store some data (e.g. those new features that have appeared in SQL Server 2016. New features of Microsoft SQL Server 2016Īnd we will start, of course, with a review of new functionality, i.e. Installing Updates and Service Packages.System requirements for SQL Server 2016 installation.New features of Microsoft SQL Server 2016.
0 kommentar(er)
