#sql

dbt is good – but it has blind spots If you’re working in analytics engineering, dbt is...

If you've ever needed to find consecutive streaks in data — days a user logged in back to back,...

Developer productivity is not just about writing code faster, it is about removing the friction...

Someone in finance asks your text-to-SQL agent what the compensation band is for a role they're...

テーブルのインデックスを眺めていて、こんな2本が並んでいるのを見つけたことはないだろうか。 KEY `idx_logs_on_import_id` ...

If a data agent returns €18.6M, production observability should tell you exactly how that answer...

Railsのプロジェクトを触っていると、db/structure.sql...

Background Data lineage can significantly enhance the capabilities of data governance and problem...

Azure SQL administration is not simply about writing T-SQL or managing databases. The deeper...

At one interview I was asked about VIEWs. I answered honestly: in real projects I had barely run into...

I used pg_advisory_lock as a one-worker gate and got a lock that dies with the connection, no-ops behind a transaction pooler, and has no fencing token. Here's what to use instead.

Relational databases often store related information across multiple tables. To answer real-world...