A technical analysis of a SQL interview question about detecting suspicious account logins from multiple countries within a short timeframe.
A technical guide on using the Obsidian Dataview plugin to query and organize notes, with practical examples for newsletters and dashboards.
Explains how to compare dates by ignoring the time component in PostgreSQL queries, using the DATE() function.
Explains the subtle but important difference between using combined and separate where.not clauses in Ruby on Rails ActiveRecord queries.
A guide for developers on when to use the jOOQ API versus writing native SQL, comparing pros and cons for each approach.
A guide to creating ASCII bar charts directly in PostgreSQL using SQL queries, eliminating the need for external visualization tools.
Explains how to use SQL's NATURAL FULL JOIN to concatenate data from unrelated tables, like actor, customer, and staff, into a single result set.
A Kusto query snippet for Azure Log Analytics to filter records from the last 7 days, showing only entries between 9am and 5pm in local time.
A technical guide on implementing pagination and querying for all items in a DynamoDB partition using .NET, comparing the Object Persistence and Document Model APIs.
A guide to creating an Ebean-like finder utility for JPA/Hibernate in a Play Framework project, with code examples.
Explains how to use Tags in TFS to add metadata and filter work items, overcoming limitations in customizing work item templates.
SQL Azure requires a clustered index on every table. This article provides a query to identify tables missing one.
Django 1.1 introduces F() expressions for database queries, enabling field comparisons and arithmetic in filter() and update() methods.
