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.
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.
