Implement semantic search using text embeddings for more relevant results than keyword matching.
Category: Emerging Technologies
Emerging technologies include a variety of technologies such as educational technology, information technology, nanotechnology, biotechnology, cognitive science, psychotechnology, robotics, and artificial intelligence.
Tips and Tricks #124: Use dbt for Maintainable Data Transformations
Build modular, tested, documented data transformations with dbt.
Tips and Tricks #123: Partition Large Tables for Query Performance
Use table partitioning to dramatically speed up queries on large datasets.
Azure Traffic Manager: A Solutions Architect’s Guide to Global DNS-Based Load Balancing
In the world of globally distributed applications, ensuring users connect to the optimal endpoint is crucial for performance and reliability. Azure Traffic Manager stands as Microsoft’s DNS-based traffic load balancer, enabling you to distribute traffic across global Azure regions and external endpoints. After architecting numerous multi-region deployments, I’ve come to appreciate Traffic Manager as an… Continue reading
Tips and Tricks #122: Implement Idempotent ETL with Merge Statements
Use MERGE (upsert) for safe, rerunnable data pipelines that handle duplicates gracefully.
Tips and Tricks #121: Use Window Functions for Running Calculations
Calculate running totals, rankings, and moving averages efficiently with SQL window functions.