Power hybrid and multicloud environments with Azure Arc data solutions

We know we are in the middle of a transformative time. At the heart of this transformation is the digitization of data. Data is the most strategic asset for organizations across all industries, and a new level of data agility is required to deal with dynamic changes in our world. Organizations that have embraced their data as a strategic asset are at a competitive advantage. In fact, a recent Gartner® Predict report estimates that 90 percent of data management tools and platforms that fail to support multicloud and hybrid capabilities will be set for decommissioning through 2026.1

But for all the powerful capabilities the cloud offers to help organizations on their transformation journey, not all data is created equal. The myriad of regulations to navigate, the need for data sovereignty, the low tolerance for any form of disruption keeps data from living in a single public cloud, expanding your data estate and complexity. Managing the vast amounts of data that exists across siloed, disparate systems, applications, and locations, while also getting the most from existing investments is not a balance many solutions can achieve.

This is why, back in November 2019, we debuted Azure Arc, a set of technologies that extends Azure innovations and cloud benefits to any infrastructure. Cloud-native databases like Azure SQL and PostgreSQL have been enabled by Azure Arc, delivering the much-needed consistency and cloud automation for all data workloads. We want you to focus less on managing data, and more on creating value and unlocking insights. Because true innovation starts at the data layer.

Innovate anywhere with Azure Arc

With Azure Arc-enabled data services, we can bring cloud data management to any infrastructure, across customer on-premises data centers, other third-party clouds, and the edge. Here’s how Azure Arc is delivering on that promise:

Always up to date with full automation. Benefit from an evergreen SQL with the latest features using automated updates so there is no more end-of-support. Those in-place, rolling updates ensure close to zero downtime, so you can maximize efficiencies and minimize disruptions
Get industry-leading, multi-layered security with built-in capabilities. With comprehensive encryption including Transparent Data Encryption and Always Encrypted, as well as Azure Role-Based Access Control and Policy, your data is protected both at the powerful database engine-level and by Azure Security capabilities from the cloud.
With elastic scale, you can scale up or down based on your resource needs without application downtime to optimize performance. You can also realize cost efficiencies by paying only for what you use without the need to overprovision.
Deliver a vastly simplified DevOps experience through full automation with built-in capabilities like rapid deploy, high availability, and disaster recovery. You can deploy a 3 replica SQL MI with full high availability (HA) in two minutes with a single command, and gain a unified view into your query performance, storage capacity, and error logs using dashboards directly from the built-in monitoring. Use the tools you are already familiar with.

All these capabilities can run in any environment regardless of the connectivity to Azure. You can run Arc-enabled data services without a connection to Azure. If you can be fully connected to Azure, the user experience is richer and in real-time, but it is not required, data services can keep running even without a connection to Azure. Azure portal deployment and other value-added management services are fully integrated under direct connection.

Built for mission-critical

And now, we’re making that solution available in an even more powerful way. We are excited to announce the general availability of Azure Arc-enabled data services Business Critical (BC) tier, designed to support the most demanding mission-critical data workloads.

With feature parity with SQL Server Enterprise Edition, it delivers all the proven capabilities customers have trusted for decades. It runs online transaction processing (OLTP) and hybrid transaction/analytics processing (HTAP) with record-setting performance, advanced high availability, and top-rated security.
It meets the most demanding business continuity requirements using Always On Availability Groups, so your app will have close to zero downtime in case of an automated failover.
Failover to another instance within the same Kubernetes cluster for local high availability, or to a different cluster in a different datacenter or even a public cloud, delivering “cloud-level redundancy”.
We also provide a free passive instance to run in your disaster recovery for even greater value
Choose the configuration that best suits your workloads, with no set limits on CPU and memory configuration. To further maximize the performance, we provide one free read-scale replica to offload any read-heavy workloads.

Our partner, Dell Technologies, conducted a series of OLTP benchmarks, using Intel technology, which took a closer look at the kind of performance possible with this new service tier. The results were remarkable. Arc-enabled SQL Managed Instance was proven to provide the same performance as SQL Server on Windows Server, so customers can run their workloads with confidence. The speed of provisioning and deprovisioning will massively speed up your continuous integration (CI) test runs. SQL instances can now be deployed very easily via automation and be available in 60 seconds, and Business Critical cuts multi-replica HA deployment time from hours or days to minutes with a single command! Those out-of-the-box experiences allow you to realize time efficiencies and redirect resources to where they matter most.

Broad partner ecosystem

Our ambition to help you digitally transform your business with the cloud and edge is boundless, we know we can’t do it alone. No single cloud provider can deliver all the infrastructure and as-a-service solutions you’ll need. That’s why we’re building an ecosystem of partners across service providers, platform providers including OS and Container platforms, and independent software vendors (ISVs) to help you envision, plan, and deploy the full stack of hybrid and multicloud solutions. Our history in both productivity and the datacenter is unique among cloud providers. Microsoft is at our best when our platforms fuel the growth of others, and I’m thrilled to see how energized the ecosystem is to evolve with us.

Get started

Review Azure Arc documentation on data services and trial the new Business Critical tier in the Azure portal.
Sign up for the Azure Hybrid, Multicloud, and Edge Day digital event to learn about the latest innovation from Azure Arc.

12021 Gartner, Predicts 2022: Data Management Solutions Embrace Automation and Unification

GARTNER is a registered trademark and service mark of Gartner, Inc. and/or its affiliates in the U.S. and internationally and is used herein with permission. All rights reserved.
Quelle: Azure

Find out why your SQL Server data belongs on Azure

The global events of the last couple of years have introduced significant changes to how companies operate and the way we work, accelerating digital transformation for many as they seek the additional flexibility, scale, and cost savings of the cloud. More companies are choosing Azure SQL for their SQL Server workloads and it’s easy to see why. Azure SQL provides a full range of deployment options ranging from edge to cloud and a consistent unified experience that makes the most of your on-premises skills and experience. It’s very cost-effective, too, when you use the Azure Hybrid Benefit to maximize your on-premises licensing investments.

Customers moving SQL Server workloads to the cloud have choices. Whether simply migrating to virtual machines (VMs) to offload infrastructure costs or modernizing on fully-managed database services that do more on your behalf, every choice on Azure is a great one.

SQL Managed Instance leads in price-performance for mission-critical workloads

More companies are choosing managed services because of the benefits they provide like lower total cost of ownership, productivity gains, and even accelerated time to market.

According to a study by Enterprise Strategy Group, customers who migrated their SQL Server data from on-premises to Azure Virtual Machines reduced their costs by up to 47 percent. Customers who continued to modernize their data from virtual machines to managed database services realized an additional 17 percent cost savings and an expected incremental $30M in new revenue due to faster release cycles. When it comes to modernizing your SQL Server data at scale, Azure SQL Managed Instance is your best choice.

It’s also a price-performance leader. Principled Technologies, an independent research firm, recently published a study where they benchmarked SQL Managed Instance and SQL Server on Amazon Web Services (AWS) RDS across three different workloads. SQL Managed Instance emerged as the leader across each of these workloads, with up to five times faster performance while costing up to 93 percent less than AWS RDS.1

SQL Managed Instance combines the broadest SQL Server engine compatibility back to SQL Server 2008, with all the benefits of a fully managed and always up-to-date platform-as-a-service (PaaS). You can use it to quickly and confidently modernize your custom and vendor-provided apps to Azure and further unlock the benefits of Azure’s integrated service platform. When a hybrid approach is required, you can run Azure Arc-enabled SQL Managed Instance on the infrastructure of your choice.

“We wanted an easy transition from on-premises SQL Server, and Azure SQL Managed Instance looks just like SQL Server—with all the operational benefits of a platform as a service.”—Hardayal Singh, Senior Principal Enterprise Architect, City National Rochdale

SQL Server on Azure Virtual Machines leads SQL Server on AWS EC2 

SQL Server on Azure Virtual Machines saves money and simplifies management of security and high availability at no additional cost. SQL Server on Azure Virtual Machines not only saves money, is flexible at scale, meets peaks in demands, and accelerates innovation, but leads SQL Server on Amazon Web Services (AWS) Elastic Cloud Compute (EC2) in overall speed and price performance.

In a recent study from GigaOm, performance was tested between Microsoft SQL Server on Azure Virtual Machines versus SQL Server on AWS EC2 instances across transactional and analytical workloads. Microsoft SQL Server came out on top meeting customers’ mission-critical requirements with up to 42 percent faster transactional performance while costing up to 31 percent less than AWS EC2.2

With SQL Server on Azure Virtual Machines you can shift your SQL workloads with ease and maintain 100 percent SQL Server compatibility and operating system-level access. In addition, when you register your self-installed VMs with SQL Server IaaS Agent extension, you can save money and simplify management of security, high availability, and storage administration. With SQL Server IaaS Agent extension, you get built-in security and management benefits, including automated backups, for free and pay only for what you use by converting licenses between pay-as-you-go, Azure Hybrid Benefit, and HA/DR license types.

H&R Block made plans to stay ahead of the changes, providing seamless multichannel experiences and unifying its disparate data sources to better serve its customers. By moving its various workloads to Microsoft SQL Server the tax provider has been able to enhance service delivery, scale to meet its peaks in demand, and accelerate innovation. The company was able to move its customer-facing systems—including a DIY online tax-filing app and an appointment application used by 10,000 offices—to SQL Server on Azure Virtual Machines with minimal issues before, during, and after migration.

“Investing in Azure data services and data platforms has really set up an amazing foundation for us to continue to deliver and accelerate new products and services to our clients.”—Aditya Thadani, Vice President of Architecture and Information Management, H&R Block

Get started today

Read the reports from Principled Technologies and GigaOm.
Ready for that next step? Use Azure Migrate to assess your data’s readiness for the cloud and use the provided tools to start your journey today.

1Price-performance claims based on data from a study commissioned by Microsoft and conducted by Principled Technologies in April 2022. The study compared performance and price performance between a 16 vCore, 64 vCore and 80 vCore Azure SQL Managed Instance using premium-series hardware on the business-critical service tier and the db.m6i.32xlarge, db.r5b.4xlarge and db.r5b.16xlarge offerings for Amazon Web Services Relational Database Service (AWS RDS) on SQL Server. Benchmark data is taken from a Principled Technologies report using recognized standards, HammerDB TPROC-C, HammerDB TPROC-H and Microsoft MSOLTPE, a workload derived from TPC-E. The MSOLTPE is derived from the TPC-E benchmark and as such is not comparable to published TPC-E results, as MSOLTPE results do not comply with the TPC-E Specification. The results are based on a mixture of read-only and update intensive transactions that simulate activities found in complex OLTP and analytics application environments. Price-performance is calculated by Principled Technologies as the cost of running the cloud platform continuously divided by transactions per minute or per second throughput, based upon the standard. Prices are based on publicly available US pricing in South Central US for Azure SQL Managed Instance and US East for AWS RDS as of April 2022 and incorporates Azure Hybrid Benefit for SQL Server, excluding Software Assurance and support costs. Performance and price-performance results are based upon the configurations detailed in the Principled Technologies report. Actual results and prices may vary based on configuration and region.

2Price-performance claims based on data from a study commissioned by Microsoft and conducted by GigaOm in April 2022. The study compared price performance between SQL Server 2019 Enterprise Edition on Windows Server 2022 in Azure E32bds_v5 instance type with P30 Premium SSD disks and SQL Server 2019 Enterprise Edition on Windows Server 2022 in Amazon Web Services Elastic Cloud Compute instance type r5b.8xlarge with General Purpose (gp3) volumes. Benchmark data is taken from a GigaOm Transactional Field Test derived from a recognized industry standard, TPC Benchmark™ E (TPC-E) The Field Test does not implement the full TPC-E and as such is not comparable to any published TPC-E benchmarks. Prices are based on publicly available US pricing in North Central US for SQL Server on Azure Virtual Machines and Oregon for AWS EC2 as of April 2022. The pricing incorporates three-year reservations for Azure and AWS compute pricing, and Azure Hybrid Benefit for SQL Server and Windows Server, and License Mobility for SQL Server in AWS, excluding Software Assurance and support costs. Actual results and prices may vary based on configuration and region.
Quelle: Azure