As this re-engineering is such a mammoth task, not all features of the SQLOS and SQLPAL are combined. This means that, for SQL Server 2017, there is a list of features in SQL Server that are not supported. The clear plan at Microsoft is to make sure that these features are introduced into future releases of SQL Server, with the ultimate goal of feature parity between SQL Server running on both operating systems:
- Database Engine:
- Transactional replication
- Merge replication
- Stretch DB
- Polybase
- Distributed query with third-party connections
- System extended stored procedures (XP_CMDSHELL, and so on)
- Filetable, FILESTREAM
- CLR assemblies with the EXTERNAL_ACCESS or UNSAFE permission set
- Buffer Pool Extension ...
