#azure-sql-database

Azure Table Storage: The Middle Ground Between a SQL Table and a Document Database

I published a comparison of Azure SQL, Cosmos DB, and Blob Storage a little while back. Looking back at it, Azure Table Storage was a real…

Mirror Azure SQL with Workspace Identity in Microsoft Fabric

Using Workspace Identity to secure Azure SQL connectivity in Microsoft Fabric Mirroring

C# Lambda Expressions and LINQ: The Two Features That Changed How I Write Code

When I first started writing C# I used foreach loops for everything. Filter a list — foreach loop. Find one item — foreach loop. Transform…

Azure SQL Database and Private Endpoint

A practical note on Azure SQL Database, Private Endpoint, and regional constraints in virtual network selection

Post 10: Handling Schema Evolution Mid-Migration: Managing Live DDL Changes over Change Data…

You are in week three of a live replication catch-up phase, syncing a 40TB database footprint. Suddenly, an automated CI/CD pipeline pushes…

Post 9: Architecture of a 40TB Live Replication Pipeline: Managing CDC Catch-Up Pressure

Seeding a 40TB database into the cloud is a static engineering challenge. Keeping it synchronized under a live production load of 4,000…

Securing Fabric Data Agents Where It Matters: Row-Level Security Behind Natural Language Answers

Why Fabric Data Agent security shouldn’t live in the prompt, and how SQL Row-Level Security works across users

Azure SQL Database and SQL Pool autoscaling

Azure SQL Database is a solid choice for managed relational workloads, but one thing it does not offer out of the box for most…

How to Create an Azure SQL Database Step by Step (Beginner to Advanced Guide)

Introduction

NineData Cloud-Native Intelligent Data Management Platform New Feature Release｜December 2025…

Throughout December, we continued to iterate around multi-cloud database support and the expansion of heterogeneous data replication…

Azure Solution Design AZ-305 part-3

In this article we will see about flavors of Azure SQL implementation.

CI/CD to Azure SQL with Flyway Made Easy

Treating your database like code is no longer optional, it’s a requirement for reliable, scalable systems.

Connecting Rust to Azure SQL Without Losing Your Mind

How to use Rust, Tokio, and Tiberius to connect to Azure SQL Database.

Microsoft Entra ID Yeets Me Out, And Azure SQL Backs It Up.

This is a story of how I regained access to my Azure SQL database from SSMS.

Mastering Azure SQL Database Automatic Updates, Backups 2025

azure database, Azure SQL, azure sql advisor recommendations, azure sql automatic backups, azure sql automatic updates, azure sql…

How Optimized Locking in SQL Server 2025 handles concurrent updates

A practical look at how the new locking model manages concurrent updates using Transaction ID (TID) locks

SQL Server 2025 Optimized Locking

The feature with a magical name that changes how SQL Server Engine acquire locks

Ile może kosztować index w Azure SQL DB?

Czy Wiecie, że Index w Azure SQL DB może kosztować nawet 64 euro* miesięcznie?

Unique indexes and ANSI_NULLS in SQL Server and Azure SQL!

How to ensure uniqueness and allow NULLs with ANSI_NULLS set to OFF!

Azure Resource Graph Explorer Query for fetching all the SQL Managed Instances

Azure Resource Graph is an Azure service designed to extend Azure Resource Management by providing efficient and performant resource…

LES BASES DE DONNÉES DANS LE CLOUD MICROSOFT

Un atelier pratique et immersif sur les bases de données dans le cloud de Microsoft☁️! Cet événement est idéal pour ceux qui souhaitent…

Efficient Data Copying from SQL Server to Azure Data Lake Storage Gen2: Stage-1

Introduction

A Modern Approach to Aggregating Multiple Databases within a Microsoft Environment

Leveraging .dacpac’s to merge databases

Create new firewall rules for Azure SQL databases

You are receiving the following error message because your IP address (client or local) has not been added to the Azure firewall on the…

Unlocking the Power of Azure SQL Solutions with DP-300T00 Certification

SQL in Azure — PaaS vs IaaS

Architects often choose between Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS). Not delving into the details, IaaS vs…

Connect Azure SQL DB as External Hive Metastore to Azure Databricks Spark Cluster and SQL Endpoint

Every Databricks workspace has an internal Hive metastore holding metadata. However, some scenarios require an external metastore that is…

SQL Server Managed Instance the database got deleted from the Azure portal but it’s still showing…

One of my customer’s SQL Managed Instance (MI), has an automation where he was deleting database every night and then restoring it.