Azure SQL Database MAXDOP

Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore

Learn a few ways to improve performance in your Azure SQL Databases through better indexing, partitioning, and columnstore index consideration.

DMV Comparison for SQL Server 2019 vs Azure SQL Database

What DMVs were added to Azure SQL Databases, and which DMVs are missing from Azure SQL Databases but still exist on SQL Server 2019 or other versions?

Deploy DACPAC to Azure SQL Database using Visual Studio

This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Visual Studio.

Implementing Vector Datatype with Azure SQL Server

This article shows how to insert data into a database, create embeddings, and then use this data to search the data with a natural language interface.

Serverless Gets Faster

In Azure SQL Database serverless edition, we get an upgrade to our configuration.

Manage Elastic jobs in Azure using Azure Elastic Jobs Manager

Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Learn how to configure the service in this article.

Database Mirroring is Back in Azure SQL Database

Database Mirroring comes back to SQL, at least to Azure SQL Database with Fabric as the destination. Read a few of Steve's thoughts on this feature.

Check Azure SQL DB Space Used

Learn how you can check the space used for your Azure SQL databases.

Deploying Azure SQL Database Using an ARM Template

Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templates are one IaC solution for Azure (ARM templates).