Relational or Non-Relational? Choosing the Best Database for the Task
Explore strengths and weaknesses of relational and non-relational databases, with real-world examples to guide your choice for specific data storage needs.
Flight of Insights: Navigating Data Turbulence with SQL Modeling and Visualization
Explore data modeling and visualization techniques to identify risks and make informed decisions in project navigation, inspired by Captain Sully's story.
A Low-Cost Serverless Synapse Data Platform in Azure
Explore a cost-effective, metadata-driven Azure data platform using Synapse Analytics and data lake, ideal for SQL enthusiasts seeking efficient solutions.
Data Lakehouse vs Data Warehouse in Microsoft Fabric - Choosing the Right Solution
Compare data lakehouse and data warehouse solutions in Microsoft Fabric to determine the best fit for your data engineering needs and migration goals.
SQL Horror Stories - Cautionary Tales and Coding Tips
Explore hilarious and cringe-worthy SQL coding mishaps with Kevin Kline, learning valuable tips and tricks from these cautionary tales.
Return Ticket from SQL Managed Instance to SQL Server - One-Click Reverse Migration and DR
Explore hybrid link setup, reverse migration, and disaster recovery between SQL Managed Instance and SQL Server 2022. Learn integrated hybrid capabilities for optimal database management.
SQL Horror Stories - Cautionary Tales and Coding Tips
Explore hilarious and cringe-worthy SQL coding mishaps with Kevin Kline, learning valuable tips and tricks from these cautionary tales.
Introduction to Azure Data Studio
Explore Azure Data Studio's features and capabilities for efficient database management and development in this comprehensive introduction.
Azure Infrastructure - What Not to Do
Discover common pitfalls in Azure SQL implementations and learn how to avoid them for a smooth cloud migration experience.
Empowering SQL - Mastering Intelligent Query Processing in 20 Minutes
Optimize database performance with Intelligent Query Processing. Explore key features and real-world impacts in SQL Server and Azure SQL for accelerated query efficiency.
Operationalizing Pluralsight's Data with Materialize
Discover how Pluralsight leverages Materialize to replace complex streaming systems, enabling real-time analytics and applications through SQL-based materialized views for faster, cost-effective data operations.
How to Use Streaming Joins with Apache Flink
Explore streaming joins in Apache Flink®, covering stateless, materializing, and temporal operations. Learn through demos on updating, appending, and versioned table joins for effective data combination.
Geolocation Explained - Building and Optimizing a Fast IP-based Location System
Develop a fast geolocation system from scratch, exploring IP networking, database operations, and query optimization techniques.
Making .is_a? Fast in Ruby 3.2 - Performance Optimization and Implementation
Optimize Ruby's is_a? method for better performance, exploring its impact on case statements, rescue clauses, and more. Learn about recent improvements and YJIT implementation.
Implementing Native Composite Primary Key Support in Rails 7.1
Explore composite primary keys in Rails 7.1, optimize applications, and enhance database performance with this powerful new feature.
Processing Trillions of Records with Mini Serverless Databases at Okta
Explore serverless DuckDBs for efficient data processing, optimizing batch ETL, streaming, and SQL flexibility while addressing Kafka, latency, and ELT complexities in large-scale environments.
From Silo to Scale - Evolution of Data Infrastructures
Explore the evolution of data infrastructures with tech leaders. Gain insights on open-source strategies, SQL's development, and Python's impact. Learn success principles for thriving in the dynamic tech landscape.
Building a Holistic SQL Chatbot for Tech and Business Problem-Solving
Explore how Sherloq transformed SQL chatbots into a core operational tool, focusing on user interaction, practical applications, and impactful decision-making beyond fancy technology.
SQL IN Clauses Performance Improvement in Postgres 17
Explore Postgres 17's enhanced performance with optimized IN clauses, comparing it to previous versions and SQL Server for faster database operations.
Connecting PostgreSQL Database Using Slick Library with Play Framework
Connect PostgreSQL with Play Framework using Slick library. Learn efficient database integration for modern web applications.
Google Cloud Data Analytics in 10 Minutes
Explore Google Cloud's data analytics solutions through a practical demo, uncovering insights on fleet and fuel inefficiencies using BigQuery and machine learning.