微軟宣布 SQL Server 2019 預覽版

Today is the first day of Microsoft's Ignite 2018 conference in Orlando, and it announced SQL Server 2019, a public preview of which will be available today. The promise of the new database management system (DBMS) is that businesses will be able to manage their relational and their non-relational databases in one offering.
微軟 Ignite 2018 的第一天，微軟就宣布了 SQL Server 2019 預覽版。這個新的數(shù)據(jù)庫管理系統(tǒng)（DBMS）讓用戶可以一步到位地管理他們的關(guān)系型數(shù)據(jù)以及非關(guān)系型數(shù)據(jù)。

Microsoft says that it improved PolyBase so that it has connectors to more data sources, including "Azure SQL Data Warehouse, Azure Cosmos DB, Mongo DB, Oracle, and Teradata". Users will now be able to use T-SQL to query all of their databases, so you won't be locked into separate data silos; in other words, all of your databases can talk to each other. It also has big data baked in with support for Spark and Hadoop.
微軟表示這個版本改善了 PolyBase，從而它可以連接到更多的數(shù)據(jù)源，包括 Azure SQL DW、Azure Cosmos DB、Mongo DB、Oracle 和 Teradata。用戶可以通過 T-SQL 訪問所有的數(shù)據(jù)庫而不用將他們鎖定在不同的倉庫。也就是說，所有的數(shù)據(jù)庫之間可以連通。它還支持 Spark 和 Hadoop 的大數(shù)據(jù)。

SQL Server 2019 can, unsurprisingly, run on-prem, on Azure Stack, or in the cloud. Users will have access to SQL Server Machine Learning Services and Spark Machine Learning, so they'll get insights on all of their data, again, regardless of what form that data comes in.

毫不驚奇的是，SQL Server 2019 支持在本地、Azure Stack 和云端運行。用戶可以訪問 SQL Server 機器學習服務和 Spark 機器學習，從而用戶可以探查所有的數(shù)據(jù)而不管這些數(shù)據(jù)從何種形式而來。

Microsoft today also announced Azure SQL Database Managed Instance, which will allow users to bring their SQL Server database to the cloud with no code changes at all. The firm promises that it has the full feature set of SQL Server, which is an impressive promise. By using the service to move to Azure, Microsoft says that businesses can save up to 80% over using competitors.
微軟還宣布了 Azure SQL Database 托管實例。該功能允許用戶將本地的 SQL Server 數(shù)據(jù)庫遷移到云端且不需要修改任何代碼。這是因為它是一個完整功能的 SQL Server。這是一個引人注目的功能。微軟說，使用該服務遷移到云，業(yè)務成本將比其他競爭產(chǎn)品節(jié)省到 80%。

But of course, this is Ignite, so that's not all for data news. Microsoft announced a preview for Azure SQL Database Hyperscale, which is a "highly scalable service tier" that lets you grow a database up to 100TB. Azure Database for MariaDB is in preview now as well, bringing support for the open-source database to Microsoft's cloud offerings.
當然，這只是 Ignite，并不是完全針對數(shù)據(jù)方面的新聞。微軟宣布 Azure SQL Database Hyperscale 的預覽版，這是一個“高擴展的服務層”，使數(shù)據(jù)庫可以增長到 100TB。 Azure Database for MariaDB 也在預覽版中，在微軟的云端提供開源數(shù)據(jù)庫的支持。

And while it wouldn't be Ignite without database news, it wouldn't be database news without Cosmos DB news. Multi-master at global scale is generally available now, enabling "unprecedented write scalability and availability". Microsoft also announced the Cassandra API is generally available.

“Cosmos DB has delivered a high performance, worldwide platform for our global reputation system. With a click of a button we can rapidly deploy regions worldwide to deliver excellent response time to our customers and partners. The Cosmos DB Cassandra API eliminated major engineering efforts during the migration of our services as we were able to integrate with very minimal changes. Our largest service is slated to migrate with the launch of Cassandra API support.” Michael Shavell, Technical Director / Architect at Symantec.

Finally, Microsoft announced the preview for Azure Data Explorer, which is designed for "lightning fast" data exploration. You can use it to find insights about "petabytes of structured and unstructured data".

以上中文譯文由本博主提供，僅供參考。如有錯漏，以英文原文為準。

原文 《Microsoft announces SQL Server 2019 - public preview available now》 https://www.neowin.net/news/microsoft-announces-sql-server-2019---public-preview-available-now

SQL Server 2019 Preview 下載地址： https://www.microsoft.com/en-us/sql-server/sql-server-2019