Content by Anna Hoffman (15)
Anna Hoffman reviews Microsoft SQL announcements at Ignite 2026, including Hyperscale cross-database querying, local Azure SQL development containers, and Database Hub general availability. She also covers AI-assisted database investigations, migration tooling, GitHub Copilot model support, and new encryption, identity, and backup protection capabilities.
Anna Hoffman reviews Microsoft SQL updates released throughout 2026, spanning Azure SQL, SQL Server, Microsoft Fabric, and database tooling. The roundup covers Hyperscale scaling, vector search, recovery and security controls, migration options, Copilot-assisted workflows, database deployment, and driver updates, with availability details and limitations to check before adopting them.
Anna Hoffman explains how Always Encrypted lets SQL Server and Azure SQL Database query sensitive columns while keeping keys outside the database operator’s control. Drawing on the original research, she examines secure enclaves, encryption leakage, performance costs, and the security trade-offs between VBS and Intel SGX enclaves.
Anna Hoffman examines the research behind Accelerated Database Recovery in Azure SQL Database and SQL Server. She explains how persistent row versions and logical revert shorten recovery and rollback, reduce transaction log usage, and introduce throughput trade-offs, alongside version-store cleanup improvements and SQL Server 2025 support for tempdb.
Anna Hoffman explains why Azure SQL Database Hyperscale combines distributed storage and compute tiers with a single-writer SQL engine. She outlines scaling limits, SQL compatibility, replica options, and pricing, then examines a Microsoft-commissioned Aurora benchmark while emphasizing that developers should test their own workloads.
Anna Hoffman breaks down the Socrates research behind Azure SQL Database Hyperscale. She explains how separating compute, transaction logs, page servers, and durable storage enables fast replicas and snapshot-based backups, then connects those design choices to current database size limits, throughput, caching, and compatibility with existing T-SQL applications.
Anna Hoffman explains how Microsoft SQL spans on-premises, Azure, and Microsoft Fabric, highlighting what’s new in the engine, developer tooling, and migration options. She also demonstrates AI-assisted performance troubleshooting and scalable vector search, and shows how Azure Arc/Azure Local and Foundry-based experiences can support modern data-driven apps.
Anna Hoffman recaps the key Microsoft SQL announcements shared at SQLCon/FabCon Barcelona 2026, covering hybrid and migration updates, Database Hub changes, Hyperscale improvements, SQL DB in Fabric updates, and developer-focused tooling and agent-related updates.
Anna Hoffman introduces the Azure SQL Database Foundations series: four videos (with companion repos) that walk developers through getting started with Hyperscale, migrating and optimizing existing databases, scaling for performance, and adding AI features like vector search and RAG directly on operational data.
Anna Hoffman explains automatic backup immutability for Azure SQL Database and Azure SQL Managed Instance in a Q&A-style session, covering what “immutable backups” mean, why WORM matters, how to enable the feature, retention options, and how to verify whether backups are protected.
Anna Hoffman recaps the year’s updates across SQL Server, Azure SQL, and SQL database in Microsoft Fabric, with a focus on developer tooling. She also covers themes like security, performance, availability, CI/CD, containers, and how AI and vectors are shaping the SQL ecosystem, plus a look at roadmap direction.
Anna Hoffman introduces Change Event Streaming (CES) in public preview across Microsoft SQL, showing where it fits for modern, event-driven application scenarios and how it differs from approaches like CDC and mirroring in SQL Server 2025, Azure SQL, and Fabric SQL.
Anna Hoffman summarizes Microsoft SQL announcements from Build 2026, focused on an “agentic” database developer workflow powered by GitHub Copilot across VS Code and SSMS, plus Azure SQL Hyperscale capabilities and new security and streaming features.
Anna Hoffman explains what SQL Server 2016 end of support in July 2026 means, outlines customer options (including Extended Security Updates), and walks through Microsoft’s zero-cost Cloud Accelerate Factory offering to help teams migrate or modernize onto Azure SQL or newer SQL Server versions.
Anna Hoffman introduces SQLCon, co-located with FabCon, a premier event in Atlanta tailored for SQL Server, Azure SQL, Microsoft Fabric, and Power BI professionals. This guide spotlights sessions, hands-on workshops, and the latest Microsoft data advancements.
End of content