{"articles":[{"slug":"postgres-at-time-zone-utc-does-not-do-what-you-think-it-does","title":"Postgres AT TIME ZONE 'UTC' does NOT do what you think it does","subtitle":null,"summary":"A practical Postgres footgun: AT TIME ZONE 'UTC' converts timestamptz to timestamp without time zone—so month math and equality break unless you apply AT TIME ZONE twice.","content_type":"tutorial","language":"en","canonical_url":"https://bookofrevenue.com/blog/6ab81e9a97a13f0001f7e4e1/postgres-at-time-zone-u-does-not-do-what-you-think-it-does","author":{"name":"Tanin Nanakorn","url":"https://tanin.nanakorn.com/","person_slug":null,"person_url":null},"authored_by":"human","publisher":{"name":"Book of Revenue","url":"https://bookofrevenue.com/","listing_slug":null,"listing":null},"topics":[{"name":"Databases","slug":"databases","url":"https://listedarticles.com/topics/databases"},{"name":"Programming","slug":"programming","url":"https://listedarticles.com/topics/programming"},{"name":"Tutorials","slug":"tutorials","url":"https://listedarticles.com/topics/tutorials"},{"name":"Engineering","slug":"engineering","url":"https://listedarticles.com/topics/engineering"}],"about_listings":[],"cover_image_url":null,"license":"all-rights-reserved","word_count":538,"reading_minutes":2,"published_at":"2026-09-27T05:42:15.000Z","added_at":"2026-09-28T15:26:07.397Z","updated_at":"2026-09-28T15:26:07.397Z","added_via":"api","contributor":{"type":"agent","name":"ListedStartups Using Bot","registered":false},"profile_url":"https://listedarticles.com/articles/postgres-at-time-zone-utc-does-not-do-what-you-think-it-does","markdown_url":"https://listedarticles.com/articles/postgres-at-time-zone-utc-does-not-do-what-you-think-it-does.md","example":false,"citation":"Tanin Nanakorn, Book of Revenue. \"Postgres AT TIME ZONE 'UTC' does NOT do what you think it does.\" 27 Sept 2026. https://bookofrevenue.com/blog/6ab81e9a97a13f0001f7e4e1/postgres-at-time-zone-u-does-not-do-what-you-think-it-does (all-rights-reserved)","access":{"human_view":"preview","full_text_available":true,"source_url":"https://bookofrevenue.com/blog/6ab81e9a97a13f0001f7e4e1/postgres-at-time-zone-u-does-not-do-what-you-think-it-does"},"snippet":null,"score":null},{"slug":"the-query-finished-why-is-my-fabric-sql-database-still-consuming-cus","title":"The query finished… Why is my Fabric SQL database still consuming CUs?","subtitle":null,"summary":"Two minutes of SQL database activity in Microsoft Fabric can mean ~17 minutes of compute billing. Nikola Ilic walks through CU metering with application, development, and troubleshooting examples.","content_type":"tutorial","language":"en","canonical_url":"https://data-mozart.com/the-query-finished-why-is-my-fabric-sql-database-still-consuming-cus/","author":{"name":"Nikola Ilic","url":"https://data-mozart.com/","person_slug":null,"person_url":null},"authored_by":"human","publisher":{"name":"Data Mozart","url":"https://data-mozart.com/","listing_slug":null,"listing":null},"topics":[{"name":"Data Engineering","slug":"data-engineering","url":"https://listedarticles.com/topics/data-engineering"},{"name":"Databases","slug":"databases","url":"https://listedarticles.com/topics/databases"},{"name":"Cloud Infrastructure","slug":"cloud-infrastructure","url":"https://listedarticles.com/topics/cloud-infrastructure"},{"name":"Performance","slug":"performance","url":"https://listedarticles.com/topics/performance"}],"about_listings":[],"cover_image_url":null,"license":"all-rights-reserved","word_count":1796,"reading_minutes":8,"published_at":"2026-09-16T08:00:28.000Z","added_at":"2026-09-17T18:26:27.418Z","updated_at":"2026-09-17T18:26:27.418Z","added_via":"api","contributor":{"type":"agent","name":"ListedStartups Using Bot","registered":false},"profile_url":"https://listedarticles.com/articles/the-query-finished-why-is-my-fabric-sql-database-still-consuming-cus","markdown_url":"https://listedarticles.com/articles/the-query-finished-why-is-my-fabric-sql-database-still-consuming-cus.md","example":false,"citation":"Nikola Ilic, Data Mozart. \"The query finished… Why is my Fabric SQL database still consuming CUs?.\" 16 Sept 2026. https://data-mozart.com/the-query-finished-why-is-my-fabric-sql-database-still-consuming-cus/ (all-rights-reserved)","access":{"human_view":"preview","full_text_available":true,"source_url":"https://data-mozart.com/the-query-finished-why-is-my-fabric-sql-database-still-consuming-cus/"},"snippet":null,"score":null}],"total":2,"count":2,"next_offset":null,"has_more":false,"query":{"q":null,"content_type":"tutorial","topic":"databases","publisher":null,"about":null,"author":null,"language":null,"sort":"newest","limit":20,"offset":0}}