Discover what’s new to Microsoft database services—recap from Microsoft Ignite | Azure Blog and Updates

[ad_1]

Whether or not it’s SQL Server, Azure SQL, open supply, or NoSQL, Microsoft’s database providers are right here that will help you construct cloud-native purposes or modernize present purposes with absolutely managed, versatile databases.

Final week at Microsoft Ignite, there have been many bulletins to assist organizations no matter the place they’re of their modernization journey. Our group is invested, and I wish to share how these bulletins are serving to us attain each buyer on the planet, modernize present purposes, and supply limitless database scale and efficiency for brand new purposes.

Attain each buyer on the planet

We introduced the preview of SQL Server 2022, essentially the most Azure-enabled SQL Server launch but. This allows simpler cloud integration than ever earlier than with new catastrophe restoration performance for Azure SQL Managed Occasion and seamless analytics over on-premises operational knowledge with Synapse Hyperlink for SQL Server. We proceed to boost the database engine together with new safety capabilities like SQL Server Ledger, and built-in question intelligence with Question Retailer and the third technology of Clever Question Processing enhancements. Be taught extra within the SQL Server 2022 announcement weblog.

Along with asserting a brand new model of SQL Server, we’ve new capabilities in Azure Arc. With Azure Arc-enabled knowledge providers, together with SQL Managed Occasion and PostgreSQL Hyperscale, you may get evergreen, managed providers anyplace you’re. Final week, we introduced the overall availability of point-in-time-restore (PITR) and in-place improve for Azure Arc-enabled SQL Managed Occasion. There’s additionally a brand new Microsoft Be taught module in the event you’re new to operating Azure providers anyplace.

Modernize present purposes

Azure is one of the best vacation spot for SQL Server, and increasingly clients are operating SQL Server on Azure Digital Machines. Just lately, we’ve added new and improved SQL Server on Azure Digital Machines market photographs. The brand new photographs have up to date configurations to stick to the most recent greatest practices, together with a brand new deployment expertise that means that you can customise settings, similar to MAXDOP and collation, based on your wants. Much more, SQL Assessments have arrived in preview so you possibly can maintain your SQL Server on Azure Digital Machine wholesome. You may schedule assessments, run an evaluation on-demand, and look at evaluation outcomes immediately from the SQL digital machine blade within the Azure portal.

Azure SQL Managed Occasion had a number of key bulletins, together with provides with considerably extra reminiscence per vCore (as much as 13.6 GB per vCore) and elevated storage as much as 16 TB in each the overall goal (common availability) and enterprise vital (preview) service tiers, offering extra room for app progress. Additionally, the brand new Hyperlink function for Azure SQL Managed Occasion permits SQL Server clients to make use of Azure SQL Managed Occasion for catastrophe restoration and restore Azure SQL Managed Occasion databases to SQL Server. Particulars about different extremely anticipated capabilities that are actually out there like Home windows (Kerberos) Authentication (restricted preview), AAD solely authentication, AAD authentication for Linked Server, BULK INSERT and BACKUP / RESTORE with Managed Identification credentials, distributed transactions between SQL Managed Situations, and far more.

In relation to open supply, Versatile Server, which is obtainable for Azure Database for MySQL (now typically out there) and for Azure Database for PostgreSQL (preview) is a brand new deployment choice that’s hosted utilizing native Linux and designed to offer extra granular management and adaptability. Versatile Server gives for max management of your databases, excessive availability choices to make sure zero knowledge loss, built-in capabilities for price optimization, and elevated productiveness enabled by integrations with Azure ecosystem. Versatile Server additionally helps customer-requested capabilities like customized upkeep home windows, zone redundant excessive availability, and price optimization options like burstable compute, begin cease and reserved cases. It’s no shock that the client adoption has been so robust. Be taught extra about Versatile Server and take a look at it without spending a dime.

Final week, we additionally introduced the overall availability of Azure Managed Occasion for Apache Cassandra offering the power to provision managed native Apache Cassandra clusters, with automated deployment and scaling operations, accelerating hybrid situations and decreasing ongoing upkeep.

Present limitless database scale and efficiency

Within the NoSQL area, Azure Cosmos DB is a totally managed NoSQL database constructed to assist manufacturing purposes at any dimension or scale. At Microsoft Ignite, we launched many new capabilities similar to partial doc updates, provisioned throughput maximums, and cost-savings suggestions in Azure Advisor—all typically out there. As well as, Azure Synapse Hyperlink customized partitioning, Cassandra API server-side retries, and a Logic App connector are actually in preview. To find out about these updates and different updates, go to the Azure Cosmos DB weblog.

A part of the Azure SQL household, Azure SQL Database is an clever and scalable relational database constructed for the cloud. With serverless compute and Hyperscale storage choices that mechanically scale assets on demand, we’re enabling you to give attention to constructing purposes. Final week, we launched configurable differential backups as typically out there and launched reminiscence grant suggestions enhancements in preview. For extra particulars, see the Azure SQL Tech neighborhood.

Final however actually not least, we introduced the overall availability of Postgres 14 on Azure’s Hyperscale (Citus) choice. This can be the primary time a significant cloud supplier has introduced the overall availability for a brand new Postgres main model on their platform sooner or later after the official launch. We additionally shipped the Citus 10.2 open supply launch and made it out there in Hyperscale (Citus) within the Azure portal. One other key announcement is Azure Personal Hyperlink assist for Hyperscale (Citus) (preview): now you can join your Hyperscale (Citus) nodes to the Azure digital community securely and privately.