Cost Optimizing Azure SQL Databases - More for Less
Dive deep into Azure SQL Database cost optimization strategies, exploring various dimensions and aspects to maximize efficiency and value.
The New Database Landscape - Revealing Shifts and Charting the Next Horizon
Explore the evolving database landscape through personal experiences, customer insights, and industry trends, revealing shifts and future directions in database technologies.
Best Practices in PostgreSQL Tuning - Navigating Key Performance Bottlenecks in the Cloud
Optimize PostgreSQL performance in cloud environments through practical techniques for diagnosing and solving common bottlenecks, enhancing database efficiency and health.
Writing T-SQL Code for the Engine - Performance Optimization Techniques
Optimize T-SQL queries for better engine performance through strategic rewriting techniques. Learn powerful scenarios to enhance database efficiency.
SQL Server Containers and Kubernetes - Going to Production
Modernize your data estate with SQL Server containers in Kubernetes. Learn to build a hybrid data estate for flexible deployment options.
An Introduction to Extended Events
Learn to set up and utilize Extended Events for SQL Server performance monitoring and troubleshooting.
Soaring to New Heights with Accelerated Database Recovery
Uncover mechanisms of accelerated database recovery for smoother database recovery journeys. Explore techniques to enhance performance and efficiency in SQL Server environments.
What to Look Out for When Migrating Your Data to the Cloud - Is It Really the Right Choice?
Explore key considerations for cloud data migration, including costs, services, and potential challenges. Gain insights for informed decision-making and successful implementation.
War Stories: Fighting the PostgreSQL Support Trenches
Dive into 20+ years of PostgreSQL support experiences, learning valuable lessons through entertaining anecdotes from the trenches.
Migration Validation Made Easy with Ora2Pg - PGConf NYC 2021
Explore Oracle to PostgreSQL migration validation using Ora2Pg. Learn schema and data validation techniques, object migration strategies, and best practices for successful database transitions.
How to Improve PostgreSQL Monitoring and Observability with PMM - PGConf NYC 2021
Enhance PostgreSQL monitoring and observability using Percona Monitoring and Management (PMM). Learn to set up, navigate dashboards, detect bottlenecks, troubleshoot issues, and optimize configurations.
PostgreSQL Query Performance Insights
Gain insights into PostgreSQL query performance patterns using tools like pg_stat_activity, pg_stat_statements, auto_explain, pgBadger, and pg_stat_monitor for effective measurement, analysis, and optimization.
Do It in SQL: pgbouncer_wrapper - Controlling pgbouncer with SQL Commands
Learn to control pgbouncer with SQL commands using pgbouncer_wrapper. Explore its capabilities, get inspired, and contribute to its improvement.
Anthony's Favorite dbatools Cmdlets and Use Cases - PowerShell Summit 2023
Explore Anthony Nocentino's favorite dbatools cmdlets and their practical applications in PowerShell for efficient database management and automation.
Introduction to Liquibase
Learn the basics of Liquibase, an open-source tool for managing database schema changes. Explore its usage, advantages, and how it tracks and applies updates across different database systems.
Monitoring Azure SQL with Azure Monitor and Managed Grafana
Learn to monitor Azure SQL using Azure Monitor and visualize metrics with Managed Grafana for effective database performance tracking and management.
Database Guardrails - A New Era for Developers and Databases
Explore OpenTelemetry-based database guardrails to validate data access, ensure scalable queries, and automate observability for improved SDLC and troubleshooting.
Performance Tuning for Azure Cosmos DB - NDC Oslo 2024
Optimize Azure Cosmos DB performance through indexing policies, connection configurations, workload estimation, and throughput selection. Learn .NET/SDK settings and server-side programming for faster solutions.
Set Up PostgreSQL Replication Using repmgr - PostgreSQL Failover Tutorial
Learn to set up PostgreSQL replication with repmgr for effective failover management. Covers installation, configuration, user setup, SSH key management, and practical failover testing.
Mastering Software Operators for Data and AI - PostgreSQL, Apache Spark, and Kubeflow
Explore software operators for PostgreSQL, Apache Spark, and Kubeflow. Learn to simplify complex operations, streamline data processing, and navigate MLOps setups for optimal AI workload performance.
Database Guardrails - New Age for Developers and Databases
Discover how to implement database guardrails using OpenTelemetry to enhance SDLC, validate scalability, prevent deployment issues, and automate troubleshooting across the tech stack.