What’s new with SQL Server 2017?

What’s new with SQL Server 2017?

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.

image_atlas_systems_12

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

Free Component Quote

If you have any questions or would like to tour our facility,

please feel free to call us at 800-727-7844.

Transform your IT Operations with this exclusive eBook on AIOps

Subscribe to our mailing list

Categories

Categories

Get more industry trends and insights

Previous
Next