Explores advanced mapping techniques in EF Core 10, focusing on JSON column support and modern entity-value type relationships.
SQL Server 2025 CU1 allows creating/restoring databases in contained availability groups, but with notable limitations and a specific required process.
![[Video] Office Hours Aboard the Groove Cruise](https://alldevblogs.blob.core.windows.net/thumbs/article-f9fade5cfd19-full-e09cf7ed.webp)
A video Q&A session on database administration topics, recorded during a music festival cruise, answering SQL Server and DBA questions.
A blog post urging SQL Server DBAs to upgrade SSMS, highlighting new features like improved code completion and easier installation.
Author's session on SQL Server Contained Availability Groups selected for SQLBits 2026 conference, covering best practices and gotchas.
Updated SQL Server diagnostic queries for February 2026, with fixes and improvements for various SQL Server and Azure versions.
Brent Ozar announces his upcoming sessions at the SQLBits conference, covering SQL Server performance tuning, indexing strategies, and cloud evolution.
![[Video] Home Office Hours, Under Construction Edition](https://alldevblogs.blob.core.windows.net/thumbs/article-b73a5187ece0-full-9d3fb4e0.webp)
Brent Ozar answers SQL Server questions during home office construction, covering AI tools, query performance, Azure databases, and tech job trends.
Explains a SQL Server edge case where automatic statistics updates don't always invalidate cached execution plans, focusing on system-created stats.
A debate on whether SQL Server DBAs need to know Windows clustering and if high availability features are worth the operational complexity.
![[Video] Office Hours in Tokyo, Japan](https://alldevblogs.blob.core.windows.net/thumbs/article-14278cd3a80f-full-1eb1b061.webp)
Brent Ozar answers SQL Server, Azure SQL, and database management questions from viewers during an informal 'Office Hours' session in Tokyo.
Guide to configuring BizTalk Server's native backup jobs to store database backups directly in Azure Blob Storage using SQL Server's BACKUP TO URL feature.
A developer documents building HyperVideo, an interactive AI-powered video player with real-time Q&A using Azure AI services and Blazor.
A technical guide on fixing SSMS 22's unexpected insertion of tabs instead of spaces, highlighting a hidden query window setting.
Microsoft re-released SQL Server 2022 Cumulative Update 23 (CU23) with fixes, including a security update, and discusses patching strategies.
A comprehensive checklist for securing and ensuring high availability of SQL Server database applications, covering deployment, operations, and resilience.
Updated SQL Server diagnostic queries for January 2026, covering multiple versions and Azure services for performance and configuration analysis.
Explores the new JSON data type and JSON Index in SQL Server 2025, focusing on their compatibility and limitations with Columnstore Indexes and Batch Execution Mode.
A tutorial on building an ASP.NET Core API with Azure Functions, Durable Functions, and SQL Server, using GitHub Copilot to generate the project architecture.
Explores the integration of new Vector data types and Vector Indexes with Columnstore Indexes in SQL Server 2025 for similarity search and RAG.
