logo
logo

SELECT features FROM bumf... What's new in MS SQL Server 2016

avatar
Mark Alexander
Jun 01, 2016 23:11
img

A new Azure service that supports databases of up to 60TB, versions 250GB to 1TB for Azure SQL, but optimized for data warehousing with massively parallel processing for queries but a more limited subset of T-SQL available.

For example, a sales person might only be allowed to see their own sales records, despite other records existing in the same tables.

Dynamic Data Masking is another new feature.

A simple concept, but one that enables easy monitoring and troubleshooting of performance issues.

Entire tables can be migrated to Azure, or if a table has a mix of current and historical data, you can create a function to determine whether a row will be migrated.

The ScaleR library, developed by Revolution Analytics, includes algorithms for data import; sorting, merging, and splitting; statistical functions and cross tabulation; data visualization; modeling algorithms and decision trees.

collect
0
avatar
Mark Alexander
Jun 01, 2016 23:11
guide
Zupyak is a free content platform for publishing and discovering stories, software and startups.