Welcome to the World of SQL Copilots - Latest Innovations in AI Companions for SQL Development
Explore AI companions transforming SQL development. Learn about GitHub Copilots for T-SQL and Azure SQL management assistance. Discover the latest innovations in SQL Copilot technology through demos.
SQL Performance Monitoring in the Cloud
Explore innovative monitoring technologies for SQL Server and Azure SQL, enhancing performance and scalability in cloud environments.
Accelerate Your Oracle and Mainframe Modernization Journey to Azure SQL
Discover strategies and solutions for migrating Oracle, Mainframe, and AS400 workloads to Azure SQL. Learn from real-world case studies and expert insights on modernizing mission-critical systems.
Fly at Mach-Speed with Azure SQL Managed Instance
Explore Azure SQL Managed Instance's future, featuring advanced storage tech and new capabilities for unmatched price/performance and scalability.
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.
Data Services for Database Access - DevNation Day India
Discover how OpenShift Database Access simplifies database management, enabling self-service provisioning and access control across providers while enhancing visibility and governance for admins.
Improving Apache Kafka Scalability and Elasticity with Tiered Storage
Explore tiered storage in Apache Kafka for improved scalability and elasticity. Learn implementation, benefits, and impact on performance from a Confluent engineer.
Postgres and JSON - How to Get the Best of Them
Explore PostgreSQL's JSON support, including types, indexing, and performance optimization techniques for powerful and flexible data handling.
Data Security Using Roles, Privileges and Row Level Security - PL/pgSQL Implementation
Explore PostgreSQL data security through roles, privileges, and row-level security. Learn implementation techniques for robust authorization in database applications.
Managing PostgreSQL Changes for the Agile DBA - Exploring Tools and Techniques
Explore tools for managing PostgreSQL schema and code changes efficiently. Learn to streamline database migrations, enhance collaboration, and improve development workflows for Agile teams.
NORM: No ORM Framework - Efficient Data Transfer Between Applications and Databases
Explore NORM: a framework for efficient database-application communication without ORM pitfalls. Learn to build "transport objects" for optimized data transfer.
How PostgreSQL Aggregates Work and How to Create and Use Custom Aggregates
Explore PostgreSQL aggregates' inner workings, create custom aggregates, and optimize their use for enhanced database performance and functionality.
Understanding Jsonb Performance in PostgreSQL
Explore jsonb performance in PostgreSQL, learn optimization techniques, and discover ways to enhance efficiency for modern projects using this popular data type.
Identifying Slow Queries and Fixing Them in PostgreSQL
Optimize PostgreSQL performance by identifying and fixing slow queries through configuration, monitoring, and query analysis techniques.
Row Level Security Explained - Performance and Application in PostgreSQL
Explore PostgreSQL's Row-Level Security: functionality, use cases, and implementation. Learn about leakproof functions and performance optimization techniques.
Advanced Postgres Schema Design for Scalable Application Development
Explore advanced PostgreSQL features for scalable schema design, including functional indexes, exclusion constraints, and array types.
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.
Advanced Data Types in PostgreSQL - Lecture 1
Explore advanced PostgreSQL data types including ENUMs, Arrays, Composite types, and Ranges. Learn to create custom data types for enhanced database functionality.
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.
Advanced Int-Bigint Conversions in PostgreSQL - Preventing Integer Overflow
Explore advanced techniques for handling integer overflow in databases, including prevention strategies and solutions for pending int overflow issues.
Get Your Insecure PostgreSQL Passwords to SCRAM - Secure Authentication Methods
Explore secure PostgreSQL password authentication with SCRAM. Learn its history, advantages over legacy methods, and how to implement it for enhanced database security.