A technical benchmark of the Hydrolix analytics platform on AWS, testing its performance on a 1.1 billion row NYC taxi dataset.
A technical guide on adding LIMIT and OFFSET clause support to the gosql SQL database engine built in Go.
A data scientist's 2020 review, focusing on machine learning projects for healthcare, including mining COVID-19 EHR data and brain signal analysis.
A guide to implementing a simple anomaly detection system using only SQL and basic statistics, aimed at developers.
A guide to translating NHibernate LINQ queries to SQL without executing them, using a custom ToSql() extension method for debugging.
A technical guide on configuring NHibernate to log generated SQL statements to ASP.NET Core's built-in logging system using interceptors.
A former Application DBA shares advanced SQL and database optimization techniques for developers, focusing on performance and efficiency.
Explains how to use Django models, managers, and QuerySets to interact with a database, covering creation, filtering, and deletion.
A guide on using PostgreSQL's FOR loop to generate test data for development and UI testing.
A brief introduction to using Dapper, a popular micro-ORM, for database operations in ASP.NET Core applications.
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.
