Shulou(Shulou.com)06/01 Report--

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.

On the first day of Microsoft Ignite 2018, Microsoft announced a preview of SQL Server 2019. This new database management system (DBMS) allows users to manage their relational and non-relational data in one step.

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.

Microsoft says this version improves PolyBase so that it can connect to more data sources, including Azure SQL DW, Azure Cosmos DB, Mongo DB, Oracle and Teradata. Users can access all databases through T-SQL without locking them in different repositories. In other words, all databases can be connected. It also supports big data of Spark and Hadoop.

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.

Not surprisingly, SQL Server 2019 supports running on-premises, Azure Stack, and the cloud. Users can access the SQL Server machine learning service and Spark machine learning, so that users can explore all the data, no matter where the data comes from.

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.

Microsoft also announced an example of Azure SQL Database hosting. This feature allows users to migrate local SQL Server databases to the cloud without any code modification. This is because it is a fully functional SQL Server. This is a compelling feature. Microsoft said that using the service to migrate to the cloud, business costs will be reduced by 80% compared with other competitive products.

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.

Of course, this is just Ignite, not all about data news. Microsoft announced a preview of Azure SQL Database Hyperscale, a "highly scalable service layer" that allows databases to grow to 100TB. Azure Database for MariaDB also provides open source database support in Microsoft's cloud in the preview version.

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".

The above Chinese translation is provided by this blogger for reference only. If there are any mistakes or omissions, the original English text shall prevail.

Original "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 download address: https://www.microsoft.com/en-us/sql-server/sql-server-2019

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.