A tutorial on creating a custom Django management command to populate a database from an external API, using a beer data example.
A guide on setting up and running PostgreSQL and pgAdmin using Docker Compose for local development.
A step-by-step guide to installing and configuring MongoDB on macOS, including specific instructions for Catalina and newer versions.
A guide to Amazon DynamoDB Transactions, covering use cases, differences from batch operations, and idempotency handling.
A concise guide to using Laravel's HasManyThrough relationship with a practical database schema and code example.
Summary of key new features in SQL Server 2019 Standard Edition, including Transparent Data Encryption (TDE) and performance enhancements.
A developer's wish list for new DynamoDB features, including filtered streams and Redis-like operations.
A post-mortem analysis of a production outage caused by a broken Django migration, and the introduction of django-test-migrations for safer database changes.
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.
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.
![The Road to Firebase [Book]](https://alldevblogs.blob.core.windows.net/thumbs/article-1f013048c9dc-full-8ab1d390.webp)
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.
