Secure Cached Plans

SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database

Learn how you can add transactional replication to an AG to move data to an Azure SQL Database.

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

This article explains how I use sqlpackage to detect schema drift and generate a delta script that shows exactly what’s different.

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.