Community Technology Preview (CTP) 2.0 is the first production-quality preview of SQL Server 2017, and it is available on both Windows and Linux.
Here are some of the exciting new features added to database engine
- Adaptive Query Processing – Faster query processing with improved plan quality.
- Store and analyse non-hierarchical relationships with Graph data support using node/edge query.
- Online index rebuild. Now you can pause and resume the online index rebuilds
- Cluster-less Availability Groups for scaling read operations. But with you scale up for read operation, you will not get high availability.
Do you know what is available on SQL Server on Linux? Here you go.
Operational Features
- Support for RHEL, Ubuntu, Docker
- SQL Server Linux on Docker
- Package based installs, Docker images
- Support for Open shift, Docker Swarm
- Failover clustering through pacemaker
- Availability Groups
- SQL Agent
- Replication
- SCOM management Pack
- Log shipping
- DMV’s
- Full-Text Search
- Transparent Data Encryption (TDE)
Programming Features
- In memory OLTP
- Column store
- Python
- Compression
- Always Encrypted
- Row Level Security
- Dynamic Data Masking
- Service broker
- Change Data Capture (CDC)
- Partitioning
- Auditing
- CLR
