Koen Verbeeck in BI Quick Tricks to Make Your Power BI Model Smaller, More Efficient and Almost Certainly Faster Power BI has been a leading data visualization tool in the market for years. It can be used as a... 11 October 2024 13 min read
Goodness Woke in Other Development Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part I) In business operations and management, the integration of large Enterprise Resource Planning (ERP) systems has become paramount. As I covered... 08 October 2024 13 min read
Bravin Wasike in CI/CD Demystifying Continuous Integration vs. Continuous Delivery: Part 1 Continuous Integration (CI) and Continuous Delivery (CD) are fundamental to DevOps and agile methodologies. They ensure that software is developed,... 04 October 2024 16 min read
Mercy Bassey in Containers and Virtualization A Unified Approach to Managing Deployments in Kubernetes with Kluctl Applications built today pass through different phases before going live; most organizations use development, testing, and production, while others employ... 30 September 2024 10 min read
Joe Celko in Theory and design Rounding Numbers I would hope by now everybody has figured out when you see a price like $39.99 that it might as... 23 September 2024 12 min read
Boemo Mmopelwa in Tools Boosting Database Development Efficiency Using AI SQL Code Generators Database development has become more complex over the years due to the introduction of new data and storage formats by... 20 September 2024 11 min read
Koen Verbeeck in Azure How To Use Managed Identities in your Azure Logic Apps Azure Logic Apps are a cloud-based service where you can create low code workflows to automate your business processes or... 18 September 2024 10 min read
Chandra Rawat in AWS AWS Services Using SQL for Big Data Analysis SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can create specific and... 16 September 2024 17 min read
Robert Sheldon in MongoDB Working with Schema Validation in MongoDB In the previous article in this series, I introduced you to schema validation in MongoDB. I described how you can... 13 September 2024 18 min read
Adrien Payong in Theory and design Database Sharding: Strategies for Seamless Scaling and Performance Optimization Companies of all sizes and across industries are struggling to cope with an explosion of data never before seen in... 13 September 2024 21 min read
Boris Novikov in PostgreSQL Making Temporal Databases Work. Part 3: Saving Data The temporal database is a database that can keep information on time when the facts represented in the database were,... 11 September 2024 19 min read
Joe Celko in Theory and design Uniqueness, Keys, and Identity If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as the founding principle... 09 September 2024 16 min read
Grant Fritchey in PostgreSQL PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after... 07 September 2024 12 min read
Phil Factor in General Storing and Retrieving the Initialization and Configuration Data for Applications All developers hit the problem of how and where to store and set their configuration, profile, or initial data. A... 05 September 2024 14 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Composite B-Tree Indexes Indexes in MySQL are one of the primary ways to enhance query performance and they are especially useful when the... 30 August 2024 16 min read
Joe Celko in Theory and design Bad Data and Dirty Databases Many years ago, my wife and I wrote an article for Datamation, a major trade publication at the time, under... 28 August 2024 10 min read
Chisom Kanu in Development EsProc SPL and SQL: Complementary, But Different, Technologies Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your every desire? Have... 26 August 2024 23 min read
Edward Pollack in T-SQL Programming Effective Strategies for Storing and Parsing JSON in SQL Server Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because... 23 August 2024 26 min read
Robert Sheldon in NoSQL Introducing Schema Validation in MongoDB Similar to other NoSQL database systems, MongoDB is known for its flexible and variable schema models, unlike relational database systems... 21 August 2024 21 min read
Joe Celko in Theory and design LIKE Constraints In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of... 19 August 2024 10 min read
