Microsoft hopes it has a sequel better than Godfather Part II: SQL Server 2019 previewed

27 september 2018
By

Ignite SQL Server 2019, the latest version of Microsoft’s venerable database, dropped into preview at the company’s Orlando shindig, Ignite, this week.

Head honcho of SQL Server at Redmond, Asad Khan, was keen to mention the 25 years of history behind the database software. Graybeards who remember the first 16-bit OS/2 release of the software in 1989 would be forgiven for raising an eyebrow at that figure, as would Unix fans recalling the original Sybase release back in 1987.

The 2019 version is quite different to the first version shipped on Windows NT, 4.21, in 1993 and it would be difficult to imagine Microsoft back then being as happy to cuddle up with all manner of alternative platforms as its modern day counterpart.

Linux

Additional support for Linux arrives in the preview, as the port, announced back in 2016 and released in 2017, with some notable missing functionality, sees some of the holes closed as Replication (Transactional, Snapshot and Merge) makes an appearance along with support for the Microsoft Distributed Transaction Coordinator (MSDTC). In-database Machine Learning is also present as is OpenLDAP.

However, if you want to talk to the server from your Linux desktop, the command line or VS Code remains your friend since Microsoft has yet to port its legacy SQL Server Management Studio. Alternatively, you could take a look at the freshly released Azure Data Studio, a renamed SQL Operations Studio and available on Windows, macOS and Linux.

Big Data, SQL Server’s big thing

Hidden away in the preview (and you’ll need to apply to get on the limited public preview) is support for deploying a Big Data cluster with SQL Server and Spark Linux containers on Kubernetes, accessible using the Hadoop Distributed

Bron: The Register Lees het complete artikel hier: http://go.theregister.com/i/cfa/http://www.theregister.co.uk/2018/09/27/sql_server_2019/

Follow us on Twitter

Tags: ,

Geef een reactie

Het e-mailadres wordt niet gepubliceerd. Verplichte velden zijn gemarkeerd met *


negen + 5 =

Archief