Confidential Development with Always Encrypted Using Enclaves
Explore Always Encrypted with secure enclaves for Azure SQL, learning best practices for developing applications with parameterized queries and collations.
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.
Sensitivity Labels Across Multiple Platforms - What Do They Look Like
Explore setting up and implementing sensitivity labels across Power BI, Microsoft Fabric, Azure SQL, and Azure Purview for enhanced data protection.
Star Schema ALL the Things! But Why? - Practical Design Decisions in Data Modeling
Explore practical star schema design, from source to model to report. Learn best practices, test methodologies, and assess performance impacts in data modeling.
SQL Modernization Journey to Azure SQL - Tools, Assets, and Migration Best Practices
Explore SQL modernization to Azure SQL using migration tools, custom solutions, and best practices for a seamless transition to cloud-based database management.
A Deep Dive into DevOps Practices with Azure SQL
Explore DevOps practices for Azure SQL, covering version control, infrastructure, schema management, testing, and CI/CD. Learn to use command-line tools and integrate with GitHub, Codespaces, and Terraform.
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.
DAX Visual Calculations - What You Need to Know
Explore DAX visual calculations, understanding their advantages over regular DAX for running sums and moving averages in data analysis.
Flink SQL: The Challenges to Build a Streaming SQL Engine
Explore challenges in building a streaming SQL engine like Flink SQL. Learn about late data handling, change data processing, event ordering, nondeterminism, and state storage in stream processing.
5-Minute Practical Streaming Techniques That Can Save You Millions
Learn cost-effective streaming optimization techniques to drastically reduce infrastructure expenses. Discover simple SQL methods and advanced strategies for distributed storage and compute stacks.
Tutorial DuckDB: La Base de Datos Rápida y Ligera para Analítica, ETL, Scripting y Microservicios
Explora DuckDB, una base de datos veloz y liviana para análisis, ETL, scripting y microservicios. Aprende sus ventajas y aplicaciones prácticas.
Pandas and Dask DataFrame 2.0 - Comparison to Spark, DuckDB and Polars
Explore Dask DataFrame 2.0's improvements and performance compared to Spark, DuckDB, and Polars. Learn about new features, benchmarks, and future developments in distributed computing with Python.
Python and SQL: Better Together, Powered by DuckDB
Explore DuckDB's integration with Python for efficient data processing, combining SQL and dataframe capabilities to handle large datasets with ease and speed.
War Stories: Fighting the PostgreSQL Support Trenches
Dive into 20+ years of PostgreSQL support experiences, learning valuable lessons through entertaining anecdotes from the trenches.
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.
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 improved system performance.
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.
Identifying Slow Queries and Fixing Them in PostgreSQL
Optimize PostgreSQL performance by identifying and fixing slow queries through configuration, monitoring, and query analysis techniques.