-
Generally Available: SQL MCP Server
SQL MCP Server offers secure, high‑performance access to production databases for building agentic applications, supporting both PostgreSQL and Azure Cosmos DB seamlessly.
-
Generally Available: Microsoft Entra server principals on Azure SQL Database
The GA release of server principals in Azure SQL Database lets you map Microsoft Entra identities to SQL logins using CREATE LOGIN ... FROM EXTERNAL PROVIDER, aligning authentication capabilities with on-premises SQL Server.
-
Generally Available: PostgreSQL Hub for Azure Developers
PostgreSQL Hub for Azure Developers offers curated sample applications, solution accelerators, and step‑by‑step learning paths to accelerate AI and app development on Azure PostgreSQL instances.
-
Generally Available: Maintenance control for Azure Database for PostgreSQL - reschedule, apply on demand, view and download
Azure Database for PostgreSQL Flexible Server now offers general availability of maintenance control features, enabling users to reschedule, apply updates on demand, and view or download maintenance logs to minimize service disruptions.
-
Retirement: Azure Synapse Link for Azure Cosmos DB NoSQL
Azure will retire the Synapse Link feature for Cosmos DB NoSQL on March 31, 2026, with full support for current users extending to March 31, 2029, before the service officially ends of life.
-
What's new with Postgres at Microsoft, 2026 edition
The 2026 update covers major advancements in Azure Database for PostgreSQL flexible server, including Premium SSDv2 storage enhancements for better performance and cost efficiency, as well as new infra‑as‑code deployment options for Elastic Clusters using Terraform, Bicep, and Ansible.
-
Introducing Durable Functions in PostgreSQL
pg_durable, an open‑source PostgreSQL extension developed by Azure engineers, enables long‑lived, fault‑tolerant workflows directly within Postgres, offering built‑in retries, parallelism, scheduling, and recovery without external orchestration.
-
Introducing Azure HorizonDB - PostgreSQL
Azure HorizonDB extends PostgreSQL with built‑in AI capabilities, including real‑time vector search via DiskANN and AI re-ranking, while maintaining compatibility with existing SQL workloads.
-
Our MongoDB TLA+ Workshop
The second MongoDB TLA+ workshop incorporated AI tools like Claude Code, dramatically increasing conversion rates and enabling nearly all attendees to start modeling real work projects within minutes.
-
Common Cache Strategies in Azure Managed Redis
Azure Managed Redis offers four cache strategies—Data Cache to store frequent DB query results, Content Cache for static page fragments, Session Store for user sessions—helping applications cut latency by up to 95% compared with direct database access.
-
SSIS 2025 Microsoft.Data.SqlClient Connection Error
The article explains how Anthropic's Fable 5 model helped diagnose and resolve an SSIS connection error by identifying a mismatch between referenced and installed versions of Microsoft.Data.SqlClient, then correcting a TLS 1.0 compatibility issue with Azure SQL DB using registry settings.
-
Azure Cache for Redis vs. Enterprise vs. Azure Managed Redis: What Retires When, and Where to Go
Migrating from Azure Cache for Redis to its replacement, Azure Managed Redis (AMR), involves updating connection strings from port 6380 to 10000 and adopting new tiers designed for higher performance and lower operational overhead.
-
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
SQL ART introduces a live blocking visualizer using SQL Server’s geometry data type to chart wait times, blocked sessions, and head blockers directly in SSMS, making complex blocking issues instantly understandable for DBAs.
-
How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)
The article explains how data scientists leverage Python libraries like psycopg2 and SQLAlchemy to interact with PostgreSQL, offering best practices for writing scalable queries that avoid performance pitfalls at large dataset sizes.
-
AI-200 Developers – What Is Azure Managed Redis
Azure Managed Redis offers enterprise‑grade Redis Enterprise capabilities—including native vector search via RediSearch, active‑active geo‑replication, up to 13 TB storage on supported tiers, and Entra ID authentication—making it the recommended in‑memory data platform for AI‑200 workloads
-
Build a Knowledge Graph in Azure HorizonDB with AI Functions and Apache AGE
Building a knowledge graph in Azure HorizonDB with AI Functions and Apache AGE enables answering complex cross‑service incident questions like upstream failure causes, team resolution rates, and cascading failure timelines with single Cypher queries.
-
Database AI Agents: The Read-Only Rule
The read‑only advisory system in Database AI Agents monitors databases and flags suspicious states without making any changes, ensuring data integrity while providing actionable insights.
-
It’s 2026. Why are databases still failing GDPR compliance audits?
The article reveals that persistent GDPR compliance failures stem largely from technical database issues like complex erasure across relational schemas, backup paradoxes undoing deletions, and audit log contradictions, highlighting gaps in SQL Server, PostgreSQL, Oracle, and MySQL implementations.
-
And Then There Was The Time RCSI Actually Made Query Results More Accurate.
The article demonstrates how switching to Read Committed Snapshot Isolation (RCSI) resolved inaccurate query results caused by row locking under default pessimistic isolation levels in SQL Server.
-
Dynamic SQL vs OR Clauses in SQL Server
This video explores using dynamic SQL to optimize queries with OR clauses in SQL Server, offering performance benefits over traditional case expressions and join clauses for complex search scenarios.
-
Announcing the Release of SSMS 22.7.0 - and many previews!
SSMS 22.7.0 introduces a "What’s New" page for quick release highlights, T-SQL formatting preview with customizable styling options, and Agent mode for GitHub Copilot to handle complex multi-step tasks in SQL development workflows.
-
Remigration – T-SQL Tuesday #199
Remigration—moving back from the cloud to on‑premises or private data centers—affects SQL Server Integration Services (SSIS) by increasing package executions up to 15% due to economic factors, while also boosting demand for related training resources.
-
Make upgrades predictable with Pre-Upgrade Validation Checks
Pre-Upgrade Validation Checks for Azure Database for PostgreSQL let you identify and resolve compatibility issues before initiating major version upgrades, reducing failed attempts and improving production readiness.
-
Moving Indexes To A New Filegroup: Microsoft Still Hates You
Moving indexes to a new filegroup in SQL Server is notoriously cumbersome—especially when dealing with heaps, nonclustered indexes containing large objects (LOBs), or simply rebuilding normal indexes requires scripting and recreating them on the target filegroup without an easy “move” option.
-
How to call an Ollama-based AI text embeddings model from SQL Server 2025
This article shows how to integrate Ollama‑hosted AI text embeddings models with SQL Server 2025 by enabling REST endpoints, defining an external model via CREATE EXTERNAL MODEL, and calling AI_GENERATE_EMBEDDINGS in T‑SQL for clean, reusable vector generation.
-
A Case for Simulation-Driven Resilience in Agentic Data Systems
Simulation‑driven resilience addresses metastability by using MESSI to model distributed system interactions, uncovering hidden failure modes before they cause production incidents.
-
Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For
SQL Server 2025 introduces GA vector storage for embeddings, allowing semantic search on existing relational data without separate databases, with performance considerations for production-scale embedding dimensions.