[Video] Office Hours at Atlantis, Bahamas
Brent Ozar answers top-voted SQL Server questions from the community in a video Q&A session recorded in the Bahamas.
Brent Ozar answers top-voted SQL Server questions from the community in a video Q&A session recorded in the Bahamas.
Updates to the SQL Server First Responder Kit and Consultant Toolkit, including new AI-powered query tuning and long-term performance tracking features.
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.
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.
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.