Key SQL Server v.Next on Windows and Linux CTP 1.1 database engine enhancements include
- Language and performance enhancements to natively compiled T-SQL modules, including support for OPENJSON, FOR JSON, JSON built ins as well as memory-optimized tables support for computed columns.
- Improved the performance of updates to non-clustered columnstore indexes in the case when the row is in the delta store.
- Batch mode queries now support “memory grant feedback loops,” which learn from memory used during query execution and adjusts on subsequent query executions; this can allow more queries to run on systems that are otherwise blocking on memory.
New T-SQL language features:
- Introducing three new string functions: TRIM, CONCAT_WS, and TRANSLATE
- BULK IMPORT supports CSV format and Azure Blob Storage as file source STRING_AGG supports WITHIN GROUP (ORDER BY)s
Key enhancements in SQL Server v.Next on Windows CTP 1.1 for Analysis Services
- New infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This infrastructure enables:
- Support for additional data sources, such as MySQL. Additional data sources are planned in upcoming CTPs.
- Data transformation and data mashup capabilities.
- Support for BI tools such as Microsoft Excel enable drill-down to detailed data from an aggregated report. For example, when end-users view total sales for a region and month, they can view the associated order details.
- Support for ragged hierarchies in reports, such as organizational and account charts.
- Enhanced security for tabular models, including the ability to set permissions to help secure individual tables.
No comments:
Post a Comment