![[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.
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.
Explains how to use DDL Triggers in SQL Server to log database schema changes for troubleshooting, contrasting it with formal SQL Auditing for security.
Explains Accelerated Database Recovery (ADR) in SQL Server 2019/Azure SQL, a feature designed to drastically reduce transaction rollback and database recovery times.
Explores the new Shortest Path algorithm support in SQL Server 2019's Graph Engine, a key feature for graph database functionality.
A guide to using the Tedious driver for Node.js to connect to Microsoft SQL Server, including a sample phone book application.
