QUERY GENERATION
- SQL engine settings have been fine-tuned to generate SQL that is optimized for Microsoft SQL Server 2017.
- Strategy supports 27 of SQL Server's 34 data types, allowing dashboard designers to bring in the critical information they require for analysis.
SUPPORTED AUTHENTICATION MODES AND OPTIONS
- Standard username and password authentication
- Windows authentication
- Kerberos authentication
- SSL encryption
ANALYTICAL FUNCTION SUPPORT
- SQL Server supports a wide range of built-in functions which allows Strategy to push down almost all the analytical functions that are supported within its platform. Strategy currently supports 131 analytical functions, of which 115 functions are mapped to built-in functions in SQL Server for calculation on the database.
WHAT'S NEW IN MICROSOFT SQL SERVER 2017
There are no data types added or removed compared with the previous version. However, Microsoft SQL Server 2017 includes many new Database Engine features, enhancements, and performance improvements.
- CLR assemblies can now be added to a whitelist.
- Resumable online index rebuild
- The IDENTITY_CACHE option
- A new generation of query processing improvements that will adapt optimization strategies to your application workload’s runtime conditions.
- Automatic database tuning
- New graph database capabilities
- Setup now allows specifying initial tempdb file size up to 256 GB (262,144 MB) per file
- The modified_extent_page_count column in sys.dm_db_file_space_usage
- SELECT INTO T-SQL syntax now supports loading a table into a FileGroup other than the user's default by using the ON keyword.
- Cross-database transactions are now supported among all databases that are part of an Always On Availability Group, including databases that are part of the same instance.
- New Availability Groups functionality includes clusterless support, Minimum Replica Commit Availability Groups setting, and Windows-Linux cross-OS migrations and testing.
- New dynamic management views
- The Database Tuning Advisor (DTA) has additional options and improved performance.
- In-memory enhancements include support for computed columns in memory-optimized tables, full support for JSON functions in natively compiled modules, and the CROSS APPLY operator in natively compiled modules.
- New string functions are CONCAT_WS, TRANSLATE, and TRIM, and WITHIN GROUP is now supported for the STRING_AGG function.
- There are new bulk access options (BULK INSERT and OPENROWSET (BULK...)) for CSV and Azure Blob files.
- Memory-optimized object enhancements
- DATABASE SCOPED CREDENTIAL
- Database COMPATIBILITY_LEVEL 140 is added.
The Strategy internal reference number for this Knowledge Base article is KB439902.
KB439902
