![[Video] Office Hours: Car in the House Edition](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-b6c22bc628b8-full-47d765bc.webp)
Brent Ozar answers SQL Server questions in a video office hours session, covering topics like plan cache bloat, in-memory OLTP, index tuning, and more.
SQL Server diagnostic queries for July 2026, covering configuration, performance, and T-SQL scripts for various versions.
SQL Server diagnostic queries for performance and configuration analysis, covering versions from 2005 to 2025 and Azure.
SQL Server diagnostic queries for May 2026, covering configuration, performance, and memory analysis for multiple SQL Server versions.
SQL Server diagnostic queries for performance and configuration analysis, updated for April 2026.
Overview of new permissions in SQL Server 2025, including AI model execution and changes to existing permissions.
A guide on using Claude Code AI tool to automate SQL Server and Azure SQL DB tasks, including code changes and Github integration.
Explains how Row-Level Security in Azure SQL can cause single-threaded queries and suggests indexing as a performance solution.
![[Video] Office Hours in Tokyo, Japan](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/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.
Fixing a misleading Azure AD group permission error during DACPAC deployment in Azure DevOps, related to schema creation.
SQL Server auditing fails to capture permission change attempts, creating a security gap. Article details the issue and a temporary workaround.
A guide to implementing fine-grained permissions for SQL Server Extended Events to enforce the Principle of Least Privilege with role separation examples.
A former Azure SQL security engineer outlines seven key improvements needed for access control and security in SQL Server and Azure SQL.
Guide to configuring Git version control for Azure SQL Database and Synapse Dedicated Pool objects using Azure Data Studio.
Guide on configuring an external Apache Hive metastore with Azure SQL for use in an Azure Synapse Analytics Spark Pool, troubleshooting common connection errors.
A technical guide on configuring an external Apache Hive metastore using Azure Databricks and Azure SQL, detailing common configuration errors and solutions.
A Microsoft engineer reviews their 2021 professional year, highlighting blogging and presentations on Azure SQL Managed Instance and tech conferences.
A developer shares his journey from Microsoft critic and MVP to joining the Azure SQL Product Team as a Senior Program Manager.
Explains how to implement high availability for Azure web apps using private endpoints and SQL failover groups across multiple regions.
Explains the 'Need-to-know' security principle for SQL Server and Azure SQL, detailing access control methods and implementation scenarios.
