Goodness Woke in Web Frappe vs. Laravel: REST API Integration Techniques REST APIs are fundamental in enabling communication between applications. Frappe and Laravel offer large frameworks to build and consume REST... 24 April 2025 17 min read
Koen Verbeeck in General Analytics How to Load a Date Dimension in Microsoft Fabric using Macros in dbt? With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal... 23 April 2025 7 min read
Dennes Torres in Blogs Azure Function & API Rate Limits: How NAT Gateway Helps You Stay Under the Radar Rate limit is common when consuming API’s: They control how many calls you can make in an interval of time.... 23 April 2025 4 min read
Bravin Wasike in DevOps Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security Strengthening Deployments and Runtime Protection In Part 1 of this series, we explored the foundational aspects of securing a DevOps... 22 April 2025 16 min read
Simple Talk Editor in Conferences Sponsoring PGDay Chicago this week On Friday, April 25, Simple Talk is excited to be a sponsor of PGDay Chicago 2025. This will be the... 22 April 2025 1 min read
Louis Davidson in T-SQL Programming Exploring the SQL Server CHOOSE Function I preface a lot of what I write with whether or not it is for a “practical” use. One of... 21 April 2025 39 min read
Louis Davidson in Conferences SQL Saturday Richmond Roundup On the weekend of April 5, 2025, I attended (and Redgate sponsored) SQL Saturday Richmond. Having lived for 5 years... 19 April 2025 5 min read
Kathi Kellenberger in DevOps Introduction to GitHub Actions Part 2: GitHub-hosted runners In the first article of this series, you learned how to set up a GitHub Actions Workflow in a GitHub... 18 April 2025 7 min read
Boris Novikov in PostgreSQL A Method for Managing Hierarchies in PostgreSQL The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational rather than just... 17 April 2025 22 min read
Louis Davidson in Blogs LLM Technical Editor Test – ChatGPT with a VERY wrong article As started in part 1 of this series, I have set out to test an LLMs ability to technical edit.... 16 April 2025 17 min read
Lukas Vileikis in Blogs Announcing Database Frontiers: a Database Conference You Haven’t Yet Heard About Database Frontiers is a new database conference hitting the spotlight come October 15th, 2025. Here’s everything you need to know.… 15 April 2025 3 min read
Kellyn Pot'Vin-Gorman in Oracle Oracle’s Limited Cloud Vendor Licensing It’s nothing new for vendors to find ways to lock in customers to their products and cloud services. Oracle recently... 15 April 2025 3 min read
Louis Davidson in Blogs New Series – Testing LLMs as Technical Editors I spend a lot of editing articles from various authors about a wide variety of topics. I do my best... 14 April 2025 6 min read
Robert Sheldon in MongoDB Working with MongoDB Shell Throughout this series, I’ve provided a number of examples of how to run commands in MongoDB Shell (mongosh). However, the... 10 April 2025 18 min read
Dennes Torres in Blogs Query Performance Analysis in Lakehouses You may have already discovered the 4 special views the lakehouse has in the queryinsights schema to track query performance.... 09 April 2025 4 min read
Joe Celko in Theory and design Data Elements on a Nominal Scale “On a scale from 1 to 10, what color is your favorite letter of the alphabet?” –Slogan on a T-shirt... 08 April 2025 10 min read
Louis Davidson in Editorials Having no idea where to start I think this is my favorite idea for a blog post, because the idea for this blog came about when... 07 April 2025 4 min read
Ganesh Gopal Masti Jayaram in Databases Data Quality: The Foundation for Business Agility and Growth We live in a world awash with vast amounts of data. Today’s modern enterprises generate and rely on vast amounts... 04 April 2025 14 min read
Grant Fritchey in PostgreSQL Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping... 02 April 2025 15 min read
Dennes Torres in Blogs Fabric Database: Advanced Vector Search Features A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. Let’s talk about... 02 April 2025 6 min read