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

Dennes Torres in Blogs

Infinity Notebook Loop in Fabric using Data Activator

Data Activator allow us to make an interesting workaround for infinity notebook executions. Infinity execution loop is interesting for constant...

20 September 2024 4 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

Lukas Vileikis in Blogs

Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024

This blog outlines why you should be coming to see a talk on MariaDB indexes at the MariaDB Server Fest...

13 September 2024 4 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

Dennes Torres in Blogs

Data Activator: The secrets of monitoring alerts

Data Activator supports email and Teams alerts. These are good options when we would like to monitor some information and...

11 September 2024 2 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

Lukas Vileikis in Blogs

Devising the Perfect Index for Your Use Case – MySQL Edition

This blog will walk you through how to choose the perfect index for your specific use case. It will also...

11 September 2024 7 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 Blogs

What Did AI Ever Do for Me?

Let me start with a simple confession, and I hope it’s not too shocking for anyone; I’m old. When I...

09 September 2024 3 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

Dennes Torres

Microsoft Fabric and PySpark: Coding tricks to improve your solutions

PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked about loops before. Let’s...

04 September 2024 4 min read

Louis Davidson in Blogs

Why don’t you work like this?

No matter how much I love social media, there are some annoying patterns that work better than most sincere ones....

04 September 2024 5 min read

Lee Asher in PostgreSQL

Solving the Overlap Query Problem in PostgreSQL

Range queries are a very common task in SQL: selecting dates, numbers, or even text values that fall within some...

03 September 2024 10 min read

Ben Johnston in Blogs

Choosing Data Types and Column Options

An entire post on choosing the correct data types either seems like overkill or much needed and overdue. The perspective...

31 August 2024 27 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

A person standing next to a cloud computing server Description automatically generated

Dennes Torres in Blogs

The Big IT Outage: Where are we going?

As you all know about, just a few weeks ago we had the big CrowdStrike global IT outage. Some lucky...

28 August 2024 5 min read

Register for Simple Talk

Articles

Boosting Database Development Efficiency Using AI SQL Code Generators

Infinity Notebook Loop in Fabric using Data Activator

How To Use Managed Identities in your Azure Logic Apps

AWS Services Using SQL for Big Data Analysis

Working with Schema Validation in MongoDB

Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024

Database Sharding: Strategies for Seamless Scaling and Performance Optimization

Data Activator: The secrets of monitoring alerts

Making Temporal Databases Work. Part 3: Saving Data

Devising the Perfect Index for Your Use Case – MySQL Edition

Uniqueness, Keys, and Identity

What Did AI Ever Do for Me?

PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant

Storing and Retrieving the Initialization and Configuration Data for Applications

Microsoft Fabric and PySpark: Coding tricks to improve your solutions

Why don’t you work like this?

Solving the Overlap Query Problem in PostgreSQL

Choosing Data Types and Column Options

MySQL Index Overviews: Composite B-Tree Indexes

The Big IT Outage: Where are we going?