My DynamoDB Wish List
A developer's wish list for new DynamoDB features, including filtered streams and Redis-like operations.
A developer's wish list for new DynamoDB features, including filtered streams and Redis-like operations.
Announcement for SQLSaturday Lisbon 2019 and Porto 2019, including dates, call for speakers, and workshop topics.
Explores SQL Server 2019's new 'Feature Restrictions' security feature, designed to help prevent SQL injection attacks.
Author shares excitement about presenting two technical sessions on SQL Server Columnstore Indexes and Batch Execution Mode at the PASS Summit 2019 data platform conference.
Explains SQL Server 2019's Froid feature for inlining Scalar T-SQL UDFs to improve performance, with caveats and function type context.
A technical guide comparing Python methods for efficiently loading and transforming large, messy datasets into a PostgreSQL database.
Explains SQL injection risks in Laravel's query builder, focusing on unsafe functions like addSelect and JSON shorthand, with a fixed vulnerability example.
An article arguing that SQL is one of the most valuable and enduring technical skills across various roles like engineering and product management.
Announcing a free book that teaches how to build a full-stack application using React and Firebase, from setup to deployment.
A technical overview of the new .NET Cosmos DB SDK v3, covering setup, queries, and common pitfalls.
Author offers 12 free hours of expert consultation on Columnstore Indexes and Batch Execution Mode in SQL Server throughout 2019.
A preview of PostgreSQL 11's key new features, including usability improvements, safer column additions, and performance enhancements like JIT compilation.
A preview of the top talks at PostgresOpen 2018, covering topics like debugging the Postgres planner, indexes, extensions, and connection pooling.
Microsoft's new Azure Postgres offering goes GA, bringing high availability, compliance, and competition to the managed PostgreSQL market.
A tutorial demonstrating Redis sorted sets using the command line interface, Python, and Go programming languages.
Practical tips for optimizing Django database interactions, covering aggregation filters, namedtuples, and custom functions.
A technical guide on enabling and locating MySQL query logs for debugging and monitoring database activity.
A guide to automating development database setup using Docker, including scripts to import production dumps into a MariaDB image for faster local deployment.
Announcement of the Spanish translation of 'SQL Performance Explained' with updates for latest database releases and a refreshed SQL indexing quiz.