[ad_1]
Whether or not it’s SQL Server, Azure SQL, open supply, or NoSQL, Microsoft’s database companies are right here that will help you construct cloud-native purposes or modernize current purposes with totally 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 workforce is invested, and I need to share how these bulletins are serving to us attain each buyer on the planet, modernize current 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 permits simpler cloud integration than ever earlier than with new catastrophe restoration performance for Azure SQL Managed Occasion and seamless analytics over on-premises operational information 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 era of Clever Question Processing enhancements. Be taught extra within the SQL Server 2022 announcement weblog.
Along with saying a brand new model of SQL Server, we’ve got new capabilities in Azure Arc. With Azure Arc-enabled information companies, together with SQL Managed Occasion and PostgreSQL Hyperscale, you may get evergreen, managed companies wherever you might be. 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 case you’re new to operating Azure companies wherever.
Modernize current purposes
Azure is the most effective vacation spot for SQL Server, and increasingly clients are operating SQL Server on Azure Digital Machines. Not too long ago, we’ve added new and improved SQL Server on Azure Digital Machines market pictures. The brand new pictures have up to date configurations to stick to the newest finest practices, together with a brand new deployment expertise that lets you customise settings, resembling MAXDOP and collation, in keeping with your wants. Much more, SQL Assessments have arrived in preview so you possibly can hold your SQL Server on Azure Digital Machine wholesome. You possibly can schedule assessments, run an evaluation on-demand, and look at evaluation outcomes straight from the SQL digital machine blade within the Azure portal.
Azure SQL Managed Occasion had a number of key bulletins, together with {hardware} presents 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 (basic availability) and enterprise crucial (preview) service tiers, offering extra room for app progress. Additionally, the brand new Hyperlink characteristic for Azure SQL Managed Occasion allows 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 obtainable 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 Cases, and way more.
Relating to open supply, Versatile Server, which is on the market for Azure Database for MySQL (now typically obtainable) and for Azure Database for PostgreSQL (preview) is a brand new deployment possibility that’s hosted utilizing native Linux and designed to offer extra granular management and adaptability. Versatile Server offers for optimum management of your databases, excessive availability choices to make sure zero information loss, built-in capabilities for value 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 value optimization options like burstable compute, begin cease and reserved situations. It’s no shock that the client adoption has been so robust. Be taught extra about Versatile Server and strive it at no cost.
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 eventualities and lowering ongoing upkeep.
Present limitless database scale and efficiency
Within the NoSQL house, Azure Cosmos DB is a completely managed NoSQL database constructed to assist manufacturing purposes at any dimension or scale. At Microsoft Ignite, we launched many new capabilities resembling partial doc updates, provisioned throughput maximums, and cost-savings suggestions in Azure Advisor—all typically obtainable. 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 deal with constructing purposes. Final week, we launched configurable differential backups as typically obtainable 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) possibility. 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 someday after the official launch. We additionally shipped the Citus 10.2 open supply launch and made it obtainable 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.
Get began at the moment
Get began at the moment to speed up innovation in your group irrespective of the place your information resides.
When you missed any of the workforce’s classes at Microsoft Ignite, you possibly can watch them on-demand:
[ad_2]
