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.
Overview of official documentation, learning resources, and training materials for Microsoft SQL Server 2025.
Part 2 of a tutorial on setting up Change Event Streaming in SQL Server 2025, focusing on Azure Event Hub configuration and database setup.
Explores SQL Server 2025's Change Event Streaming (CES), a feature for real-time data change streaming to Azure Event Hubs.
Explains the new Optimized Locking feature in SQL Server 2025, detailing how it reduces lock memory and improves concurrency.
Explores the new ABORT_QUERY_EXECUTION query hint in SQL Server 2025 for blocking problematic queries via Query Store.
A technical checklist for database application vendors to ensure SQL Server security, high availability, and best practices in deployment and operations.
