Optimizing compute resource allocation to achieve performance goals while controlling costs can be a challenging balance to strike especially for database workloads with complex usage patterns. SQL Database serverless automatically scales compute based on workload demand and bills for compute used per second.
The world of data changes at a rapid pace, with more and more data being projected to be stored and processed at the edge.
This blog post continues the Azure SQL Database architecture series where we share background on how we run the service, as described by the architects who originally created the service.
We are excited to reveal a public preview of a new feature in Azure SQL Database, both in logical server and Managed Instance, called CLUSTERED COLUMNSTORE ONLINE INDEX build. This operation enables you to migrate your data stored in row-store format to the columnstore format and maintain your columnstore data structures with the minimal downtime on your workload.
The SQL Security team is pleased to share the public preview release of Static Data Masking. Static Data Masking is a data protection feature that helps users sanitize sensitive data in a copy of their SQL databases.
SQL Information Protection policy can now be managed in Azure Security Center. The policy management enables centrally defining customized classification and labeling policies, that will be applied across all databases on your tenant.
Today we pre-announced the public preview of Azure SQL Database Hyperscale. Azure SQL Database Hyperscale is a new SQL-based and highly scalable service tier for single databases that adapt on-demand to your workload's needs.
In this blogpost, you will learn how Azure SQL Database intelligent performance feature Intelligent Insights has successfully helped a customer troubleshoot a hard to find 6-month intermittent database performance issue in a single day only.
Today, we announced general availability of Azure SQL Data Warehouse (SQL DW) Compute Optimized Gen2 tier, the new generation of Azure SQL DW. Azure SQL DW is a fast, flexible, and secure cloud...
Apache Spark is a unified analytics engine for large-scale data processing. Today you can use the built-in JDBC connector to connect to Azure SQL Database or SQL Server to read or write data from Spark jobs.