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.
A guide to converting SQL Server Profiler templates to Extended Events (XEvents) sessions using the SSMS GUI for performance monitoring.
A former Application DBA shares advanced SQL and database optimization techniques for developers, focusing on performance and efficiency.
A technical guide on configuring Workload Classifiers in Azure Synapse Analytics to map users and queries to specific workload groups for resource management.
A technical guide covering PostgreSQL basics, including schemas, user/role management, and SQL commands for permissions.
A technical guide exploring workarounds to update SQL Server statistics on secondary replicas in Availability Groups, including scripts and methods.
A critique of a MongoDB outage post-mortem, discussing the pitfalls of 'accidental DBAs' and the need for specialized database reliability engineering.
A technical walkthrough on setting up and testing the Auditing feature in Azure SQL Database, including configuration and reporting.
A technical walkthrough on setting up and using the Dynamic Data Masking feature in Azure SQL Database for on-the-fly data obfuscation.
