![[Video] Home Office Hours, Under Construction Edition](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/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.
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://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.
Explores the new ABORT_QUERY_EXECUTION query hint in SQL Server 2025 for blocking problematic queries via Query Store.
A guide for new DBAs on managing PostgreSQL extensions, covering installation, version checking, and essential maintenance practices.
Analyzes the pros and cons of renaming the built-in SQL Server 'sa' account as a security measure against brute-force attacks.
A fun exploration of psql's scripting capabilities, testing if it's Turing complete by implementing a Fibonacci sequence calculator.
PostgreSQL 19 adds a new %S prompt variable to psql to display the current search_path, aiding users who frequently work with multiple schemas.
A guide for Oracle DBAs on PostgreSQL query tuning, covering the pg_stat_statements extension and the PostgreSQL planner's cost model.
A technical comparison of PostgreSQL and Oracle physical storage, memory architecture, and processes for database administrators transitioning between the two systems.
Explains the benefits of SQL Server contained availability groups for simplifying failover and reducing DBA workload, contrasting them with traditional AGs.
Announcing a full-day SQL Server performance monitoring and troubleshooting PreCon session at SQLSaturday NYC 2025, led by a former Microsoft PM.
PostgreSQL 18 will allow dynamic adjustment of autovacuum_max_workers without a server restart, improving database maintenance flexibility.
Essential Linux skills for SQL Database Administrators to improve efficiency and marketability in modern IT environments.
A guide for SQL Server DBAs on using Ansible to automate database administration tasks like installation, backup, and user management.
Learn how to view and update user/group roles in Azure SQL Database using Azure Data Studio's preview features.
A series of technical how-to guides for Azure SQL Managed Instance, written by a Microsoft employee, with new posts planned.
Explores hidden PostgreSQL features like upsert row counts, column grants, and pivot tables to improve database workflows.
A guide to installing and configuring PostgreSQL on Linux, covering user setup, database creation, and common connection issues.
Technical analysis advising against using Basic and Standard (S0 & S1) tiers in Azure SQL Database, citing performance, permissions, and feature limitations.
