A database professional's travelogue of speaking at SQL Server and tech conferences across Asia, Europe, and America in late 2015.
A tutorial on using R's dbWriteTable function to efficiently write a data frame to a temporary SQL table for database queries.
Part 7 of a Docker tutorial series: creating a custom MongoDB container image for a website's persistence layer.
A first look at the new UPSERT feature in PostgreSQL 9.5, explaining its syntax and practical use cases for developers.
A developer's wishlist for upcoming features in PostgreSQL 9.5, including upsert, foreign data wrapper improvements, and better replication.
A tutorial on using Julia's string interpolation for automating repetitive data engineering tasks like querying multiple database tables.
A patch fixes a bug in daloRADIUS's user refill feature, correcting a database column name in the billing history table.
Author announces receiving the Microsoft MVP Award for SQL Server, highlighting their community contributions and speaking engagements.
A retrospective on the first year of the Postgres Weekly newsletter, highlighting key articles, extensions, and community insights about PostgreSQL.
Overview of new PostgreSQL 9.4 features, focusing on the performance benefits of JSONB for document storage and the introduction of logical decoding.
A technical tutorial on implementing ASP.NET Identity with Entity Framework for database-backed user authentication in an MVC application.
A historical account of Oracle's poor performance in a 1983 database benchmark and their alleged attempt to have the professor behind it fired.
A developer's perspective on missing features in PostgreSQL 9.4, focusing on upsert, JSON performance, and extension management.
A first look at PostgreSQL 9.4's new features, including pg_prewarm, concurrent materialized view refresh, and ordered set aggregates.
Explains how to use JOIN operations in JPA finder queries within the Play Framework to filter tasks by a related user's name.
A guide to using PostgreSQL Foreign Data Wrappers (FDWs) to access remote data as if it were local tables, including setup and performance tips.
A guide to using SQLite and Python's sqlite3 module to efficiently manage and query large datasets from text files.
A technical guide on using SQLite and Python's sqlite3 module to efficiently manage and query large datasets, replacing slow text file processing.
A guide to using JSON operators and functions in PostgreSQL 9.3, covering data extraction and manipulation from stored JSON.
An analysis of PostgreSQL's documentation strengths and gaps, proposing improvements for onboarding, tutorials, and developer guides.
