Exploring Scalar Solutions to Complex Data Math

There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity. A...

12 February 2025 17 min read

Kellyn Pot'Vin-Gorman

What is Oracle RAC and Why Use it for Scaling Workloads?

Oracle Real Application Clusters (RAC) is a database clustering solution that enables multiple servers to operate as a single, unified...

10 February 2025 6 min read

Bravin Wasike in Containers and Virtualization

Kubernetes vs. Serverless: When to Choose Which?

As a DevOps engineer working with software development teams, the debate between Kubernetes and serverless computing often arises when the...

06 February 2025 14 min read

Laerte Junior in PowerShell

Fun with PowerShell Asynchronous

Imagine a candle that is lit and takes 1 hour to burn out. Now imagine one hundred candles. How many...

03 February 2025 7 min read

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

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

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

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

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

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

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

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

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

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

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

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

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