11. Data Warehousing

SQL Server has been delivering industry-leading capabilities for the modern data warehouse workload for many years. Mission-critical security features built into each edition of SQL Server such as row-level security, Always Encrypted, data masking, and others ensure that your data is secure at all times. Built-in advanced analytics using R and Python allows you to operationalize your data science models in a secure and performant way. SQL Server also offers industry-leading performance based on the TPC-E and TPC-H benchmarks for 3 TB and 10 TB data warehouse workloads (https://cloudblogs.microsoft.com/sqlserver/2019/05/16/sql-server-2017-achieves-top-tpc-benchmarks-for-oltp-and-dw-on-linux-and-windows/). Because of all this, SQL Server is a clear leader and trusted platform by organizations around the globe for data warehouse workloads both on-premises and in the cloud.

Many organizations use data warehouses to process and aggregate large volumes of data...