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.
Explains new SQL Server 2014 permissions like IMPERSONATE ANY LOGIN and how they interact with CONTROL SERVER for security and privilege escalation.
A tutorial on connecting to Apache Hive using the open-source SQL Workbench tool via JDBC, covering driver setup and connection configuration.
