Querying SQL vNext with F#
SQL vNext is Microsoft's major release for SQL open source and platform-independent DBs. It has introduced major features of the relational database to Linux: in-memory OLTP, in-memory columnstores, transparent data encryption, Always Encrypted, and row-level security, to make SQL Server the platform of choice across operating systems. It provides us with development language selection options, on-premise or cloud options, and operating system options such as Linux (Red Hat, SUSE, and Ubuntu), and Linux-based Docker containers or windows, adaptive query processing, SQL graphs, improvements to analysis services, reporting services, and integration services.
It has new features such as integration services; till now SQL Server 2016 SSIS package execution was limited to one machine, but now integration services give high-performance package execution by distributing execution on multiple machines like parallel execution on different servers. It involves:
- SSIS Scale...