A technical guide on configuring Workload Classifiers in Azure Synapse Analytics to map users and queries to specific workload groups for resource management.
Extending a SQL database in Go to support indexes, focusing on PRIMARY KEY constraints and SELECT optimizations using tree structures.
Extending a SQL database implementation in Go to support binary expressions and WHERE clause filtering.
Explains how to use EF Core 5.0's ToQueryString() method to translate LINQ queries to SQL without executing them against the database.
A tutorial on building a basic SQL database from scratch in Go, covering parsing, an in-memory backend, and a REPL for CREATE, INSERT, and SELECT.
A technical guide comparing Django ORM GROUP BY queries with their SQL equivalents, aimed at developers comfortable with SQL.
A technical guide on creating and managing Materialized Views in Azure SQL Data Warehouse, focusing on practical implementation and limitations.
A guide to common SQL mistakes and optimization opportunities for developers and data professionals, covering integer division, UNION vs UNION ALL, and query performance.
Explains the internal workings of SQL databases, covering data structures like tables, indexes, rows, and pages for both storage and querying.
A curated list of free resources for data mining, analysis, and visualization, including books, tools, libraries, and tutorials.
Announcement and review of 'The Art of PostgreSQL', a book teaching how to replace complex application code with efficient SQL queries.
Announcement for SQLSaturday Lisbon 2019 and Porto 2019, including dates, call for speakers, and workshop topics.
A technical guide on using SQL GROUP BY with window functions to retrieve the first or last value in a group, using a PostgreSQL event table example.
Explains how to correctly use Dapper's IN clause with collection parameters to avoid SQL syntax errors from double parentheses.
A technical guide covering PostgreSQL basics, including schemas, user/role management, and SQL commands for permissions.
A workaround technique for exploding arrays in ksqlDB using manual indexing, simulating EXPLODE/UNNEST functionality.
A developer explores Transposit, a platform providing a SQL interface to interact with multiple APIs, and attempts to rebuild a complex GitHub bot using it.
A technical guide exploring stream-stream joins in KSQL using orders and shipments data, covering setup, aggregations, and join implementation.
A guide to optimizing Django dashboard performance using SQL grouping sets for advanced aggregation, including a cautionary note.
An article arguing that SQL is one of the most valuable and enduring technical skills across various roles like engineering and product management.
