Louis Davidson in Editorials Art and Science and of course AI There is a classic argument that goes like this, “is programming art or a science?” In its purest form, science... 03 February 2025 5 min read 21
Phil Factor in Editorials Accessibility, and the Need for Ingenious Simplicity in Computer Scripts, Languages and Programs I’m very keen on accessibility in computer systems. Nowadays we tend to take a rather superior attitude to this problem,... 30 January 2025 12 min read 11
Robert Sheldon in MongoDB Creating Time Series Collections in MongoDB Throughout this series, I’ve introduced you to different features in MongoDB and provided examples to help demonstrate how the database... 27 January 2025 15 min read 2
Joe Celko in Theory and design Temporary Tables There is a feature of SQL I have not seen used much and probably with good reason. It’s the use... 24 January 2025 9 min read 311
Koen Verbeeck in General Analytics Loading Models from Source Data with dbt The data transformation tool dbt (data build tool) has become more and more popular over the past years. It focuses... 20 January 2025 8 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 2 – Memory and CPU) In the first part of the series article, we introduced MySQL Shell as a tool for managing and optimizing MySQL... 17 January 2025 17 min read 1
Joe Celko in Theory and design VIEW Objects A view is a virtual table, created when it’s invoked by the < view name>. The goal we had in... 13 January 2025 7 min read 1
Edward Pollack in SQL Server Customizing the Export and import of Parquet Files in SQL Server Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an ideal format for... 10 January 2025 10 min read 21
Kellyn Pot'Vin-Gorman in Oracle Oracle Architecture Overview I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways are best, but... 02 January 2025 24 min read 331
Aaron Bertrand in T-SQL Programming Five changes to SQL Server I’d love to see I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my... 01 January 2025 5 min read 64
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 1 – Introduction) The database is an important part of any application and setting it up correctly is key to ensuring smooth performance.... 27 December 2024 23 min read
Goodness Woke in Other Development Frappe’s Configuration vs Laravel’s Code-Centric Customisation This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database management, and API... 23 December 2024 23 min read 1
John Kerski in Data Science Comparing Groups for Similarities in Power Query – Using Cosine Similarity I’ll admit upfront—I am not a data scientist by trade. Instead, I’ve picked up my data science skills over time,... 17 December 2024 7 min read 21
Anil Kumar Moka in Snowflake When Should You Employ Snowflake Materialized Views? I’ve used both Snowflake views and materialized views with varying degrees of success. Both have their place and it’s on... 16 December 2024 16 min read 221
Phil Factor in Other Development Data Documents and Common Sense What can be so difficult in creating a sensible standard for Structured Data Documents? To understand why they tend to... 13 December 2024 5 min read
Koen Verbeeck in General Analytics A gentle introduction to dbt In a typical data warehouse project, data is loaded, transformed and stored into a data store using an ETL (extract... 10 December 2024 12 min read 11
Kellyn Pot'Vin-Gorman in Oracle Introduction to Oracle Database for Database Professionals Oracle Database, often referred to simply as Oracle, is one of the most powerful and widely used relational database management... 05 December 2024 12 min read 11
Lukas Vileikis in MySQL MySQL Index Overviews: Clustered B-Tree Indexes If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered indexes in database... 03 December 2024 10 min read
Lee Asher in PostgreSQL Overlapping Ranges in Subsets in PostgreSQL In Part I of this series, we explored overlap queries and the problems that accompany them, along with ways to... 29 November 2024 10 min read 22
Robert Sheldon in MongoDB Working with MongoDB Indexes Throughout this series, I’ve covered a number of topics about working with MongoDB collections and their data. One topic I... 26 November 2024 20 min read 1
