Guide on connecting Vertica analytics database to Dremio Cloud for data federation, cost reduction, and modern analytics workflows.
Guide on connecting MySQL to Dremio Cloud for federated analytics, eliminating ETL pipelines and improving query performance.
Guide on connecting Microsoft SQL Server to Dremio Cloud for federated analytics, avoiding ETL and reducing license costs.
Guide on connecting SAP HANA to Dremio Cloud for federated analytics, enabling queries across SAP and non-SAP data sources without data movement.
Seven common data modeling mistakes that cause reporting errors and slow analytics, with practical solutions to avoid them.
Explains why transactional data models are inefficient for analytics and how to design denormalized, query-optimized models for better performance.
A developer reflects on 20 years of blogging about tech topics like Columnstore Indexes, Vector Indexes, AI, and Product Management.
A developer reflects on the first year of their tech-focused newsletter, sharing growth stats, key lessons learned, and strategies for consistent content creation.
Explores implementing a data mesh architecture using dbt, outlining how dbt Mesh projects can align with data mesh principles for large-scale organizations.
Demonstrates a 6x speedup for analytics queries using EDB Postgres Distributed's new analytics engine compared to the standard Postgres engine.
Discusses the risks of running analytics on operational databases and offers solutions to separate workloads.
A developer built stats.store, a free, open-source, privacy-first analytics backend for Sparkle-based Mac apps, avoiding invasive tracking.
A tool for calculating SaaS churn rate, revenue leakage, and annual loss, with suggestions for improving customer retention.
A data-driven analysis of the AWS News Feed's performance and user engagement during AWS re:Invent 2024, highlighting traffic, features, and release volume.
A developer reflects on reaching 1 million blog page views, discussing their blogging journey, static site tooling, and evolution of technical content.
Explores the differences between event and entity data modeling, when to use each approach, and practical design considerations for structuring data effectively.
Explains the data lakehouse architecture, its layers (storage, table format, catalog, processing), and its advantages over traditional data warehouses.
A data engineer reflects on their 2-year career journey at the City of Boston, sharing lessons learned in data warehousing, ETL, and civic tech.
A developer shares their setup for tracking analytics with Posthog and running ads via Facebook, focusing on key events for a project.
An introduction to analytical data warehouses, explaining their purpose, differences from transactional databases, and their role in team-based analytics.
