MinIO Supports Microsoft SQL Server 2022 Functionality
Customers can use external tables to store and query data.
This is a Press Release edited by StorageNewsletter.com on November 24, 2022 at 2:01 pmMinIO Inc. announced support for several features Microsoft SQL Server 2022.
This expanded support enables SQL queries to be executed vs. data that is distributed across clouds, larger than ever and is in different file formats.
“While AI and ML promise to provide some of the deepest insights into data, setting up and leveraging these ML pipelines requires highly sophisticated data science capabilities,” said Kris Inapurapu, CBO. “In many cases these are long ranging projects that take months if not years to complete, and may require retraining existing staff to learn these new data science paradigms. Microsoft SQL Server is already ubiquitous in the enterprise and with SQL Server 2022, object storage becomes a first class citizen through a technique called external tables. With this addition, the entire enterprise can query massive, distributed object stores with exceptional performance.”
One of the biggest benefits afforded by the new features set is the ability to query data where it resides without incurring the expense and complexity associated with moving it. SQL Server 2022 allows for continuous replication of data to and from the cloud enabling disaster recovery capabilities. When combined with the power of the company’s multi-cloud object storage suite, fast data can reside on NVMe-based fast data engines and tier it to any number of slower tiers based on media or clouds. MinIO and SQL Server 2022 users can R/W, and process big data using Transact-SQL or Spark libraries, allowing them to easily combine and analyze high-value relational data with non-relational high-volume big data.
MinIO’s object store is fast with published GET/PUT throughput benchmarks in excess of 325 and 165GB/s respectively on 32 nodes of NVMe. This performance has made MinIO the object store of choice for ML frameworks, analytics applications, databases, web applications and other performance-oriented workloads. The feature object storage suite is available on the public cloud, private cloud and edge. This includes public cloud deployments on Google Kubernetes Engine, Amazon’s Elastic Kubernetes Service, Microsoft Azure Kubernetes Service, private cloud deployments on Red Hat OpenShift, VMware Tanzu, HPE Ezmeral, SUSE Rancher in addition to millions of colo and edge deployments.
“We are pleased to add MinIO to our suite of supported object stores,” noted Asad Khan, VP, Azure data engineering, Microsoft Corp. “MinIO’s performance, scalability and multi-cloud capabilities have made them the object store for developers and architects across the globe. Given our respective footprints, we anticipate we will support customers across industries and geographies.”
The company multi-cloud object storage suite is available for Microsoft customers using SQL Server.
Resource:
Blog