Learning from Microsoft Advertising Platform on Azure SQL
Microsoft Advertising is a powerful search advertising platform designed to get your ads in front of the right customers. In this blog, we are going to share how we re-architected our systems on Azure, how we leveraged numerous exciting Azure SQL features, and how Microsoft Advertising Platform thrives as Azure SQL continues to deliver innovation and excellence.How-to restore across different SQL Managed instances when using TDE with Customer Managed Keys
This how-to post focuses on how-to restore across different SQL Managed instances when using TDE with Customer Managed Keys. Transparent Data Encryption (TDE) with Customer Managed Keys uses Azure Key Vault, which provides highly available and scalable secure storage for RSA cryptographic keys backed by FIPS 140-2 Level 2 validated hardware security modules (HSMs).Introducing Azure SQL Managed Instance Next-gen GP
The next generation of the general purpose service tier for Azure SQL Managed Instance is a major upgrade that will considerably improve the storage performance of your instances while keeping the same price as current general purpose tier. Key improvements in the next generation of general purpose storage include support for 32 TB of storage, support for 500 DBs, lower storage latency, improved storage performance, and the ability to configure the amount of IOPS (I/O operations per second).Monitoring options available for Azure SQL Managed Instance
For customers in production with Azure SQL Managed Instance, to ensure business continuity you might want to consider continuously monitoring and tuning the instance performance. This article provides a single point of view describing options available to you in setting up resource, performance monitoring and alerting on your managed instance.Community Update - Introducing the Microsoft Azure Data Community Advisory Board
Earlier this year, Microsoft launched our Azure Data Community initiative, with assets such as a landing page for the community, a support network for local Community Groups, and Microsoft Teams subscriptions for Community Group leaders. To drive this initiative, we’ve chosen various recognized Community experts from all over the globe to act as an advisory board to Microsoft on community needs.
Improving concurrency of asynchronous statistics update
In Azure SQL Database and Azure SQL Managed Instance, the background process that updates statistics asynchronously can now wait for the schema modification lock on a low priority queue. This improves concurrency for workloads with frequent query plan (re)compilations. New behavior is enabled with the ASYNC_STATS_UPDATE_WAIT_AT_LOW_PRIORITY database-scoped configuration.10 Reasons why Azure SQL is the Best Database for Developers
Azure SQL has a lot of features ready to help developers to create the best modern apps they can. JSON, Graph and spatial support, ColumnStore and RowStore storage models, Locking and Non-Locking transactions, 40+ of research in performance optimization are just a few examples of those. Here's the top 10 reasons, among hundreds!, that shows why we think Azure SQL is the best database for developers. And now it is web scale too! 😉
