Queries

Debugging LINQ Queries

Practical techniques for stepping through, inspecting, and diagnosing bugs in LINQ query chains, including deferred execution pitfalls.

Raw SQL Queries with FromSqlRaw

When and how to drop down to raw SQL in EF Core with FromSqlRaw and FromSqlInterpolated, and how to do it without opening a SQL injection hole.

Tracking vs No-Tracking Queries

When to let EF Core track query results for later updates versus opting out with AsNoTracking for faster, read-only workloads.

Running SQL Queries on DataFrames

Learn how to register DataFrames as temporary views and query them with standard SQL syntax, and how SQL and the DataFrame API interoperate under the hood.

SOQL Queries

Learn Salesforce Object Query Language (SOQL) syntax for retrieving records, including relationship queries, aggregate functions, and governor-limit-aware quer…

Queries and the Prolog Interpreter

An introduction to how Prolog queries work: typing goals at the ?- prompt, reading bound variables and backtracking with ;, and understanding how the interpret…

Bool Queries

How the bool compound query combines must, should, must_not, and filter clauses to express complex search logic in Elasticsearch.

Match and Term Queries

How Elasticsearch's two most fundamental leaf queries differ: match for analyzed full-text search and term for exact, unanalyzed matching.

Schema Design in MongoDB

Learn how to design MongoDB document schemas around your application's access patterns rather than around abstract normalized tables.

Writing Queries

Learn how to construct GraphQL queries that ask a single endpoint for exactly the fields you need, nested through the schema graph.

Responsive Design and Media Queries

Techniques and CSS media queries used to adapt layouts across different screen sizes and devices.

SQL Cheat Sheet

Common SQL queries, joins, clauses, and database operations.

Prolog Cheat Sheet

Core Prolog concepts covering facts, rules, queries, list operations, and built-in predicates for logic programming.

Secure Coding Practices Cheat Sheet

Language-agnostic patterns for input validation, output encoding, secrets handling, and common vulnerability prevention.