Data - Dan The Engineer

Dan The Engineer

Sign in Subscribe

Data

A collection of 17 posts

The Importance of Encryption for Database Platforms: Protecting Your Data

The Importance of Encryption for Database Platforms: Protecting Your Data

Hello everyone, having worked in the database industry for over 30 years, I know firsthand the importance of protecting your data. One of the most effective ways to do this is through encryption, which transforms sensitive information into a code that only authorised parties can decode. In this blog post,

Optimising Performance and Availability with CockroachDB Monitoring Tools

Optimising Performance and Availability with CockroachDB Monitoring Tools

In my experience as a seasoned Database Administrator and Engineer, monitoring tools play a crucial role in the efficient maintenance of databases. With the aid of these technologies, administrators can enhance the performance of their systems, spot problems early, fix them, and ultimately give users better services. A database that

Synthetic vs Non-Synthetic Benchmarking: Understanding the Difference

Synthetic vs Non-Synthetic Benchmarking: Understanding the Difference

As technology advances, businesses are finding themselves dealing with massive amounts of data. Databases play a significant role in storing and managing this data, and businesses need to ensure their databases perform optimally. Benchmarking is one way to assess the performance of a database, and there are two types of

Qu'est-ce qu'une Forme Normale et devez-vous les respecter ?

Qu'est-ce qu'une Forme Normale et devez-vous les respecter ?

[English version available here] En comparant les SGBD et les bases NoSQL, la partie "schéma" est souvent utilisée. Dans le monde NoSQL, vous voyez les "schema-less" ou "no schema" comme un avantage. Si cela peut être vrai parfois, vos applications s'appuieront sur un schéma de quelque manière que ce soit.

What is Normal Form and do you need to respect them?

What is Normal Form and do you need to respect them?

[Version en Français disponible ici] Comparing RDBMS and NoSQL, the schema part is often used. In NoSQL, you see "schema-less databases" or "no schema" as an advantage. If it could be true sometimes, your applications will rely on a schema in any way. You always end up presenting data to

Database Indexes: Trigram

Database Indexes: Trigram

An introduction to Trigram Indexes

User Defined Functions

User Defined Functions

Understanding User-Defined Functions

Why stored procedures are a bad idea (and what to do instead)

Most people don’t know what stored procedures are, and even fewer people know why they should avoid them like the plague. I’m going to tell you exactly why you should avoid database stored procedures and what to use instead of them. What are database stored procedures? Stored procedures

Why Is Database Isolation Level So Important? You Might Be surprised.

You’ve probably heard the term database isolation level before, but how important is it? In other words, should you let your database admin worry about it, or should you care enough to be familiar with it? And if you should care, what are these different isolation levels anyway? The

The Advantages of OLAP and OLTP Database Separation

When it comes to designing your data strategy, you have several options for where you can store your data and how it will be processed. Two that you’ll likely hear about are the OLAP (online analytical processing) and OLTP (online transactional processing) databases, and whether or not they should

Why Distributed Databases Are Becoming More Popular

We have been hearing about distributed databases for some time now, but what exactly does it mean? Also, why are these databases becoming so popular? Let’s take a look at these questions, as well as some of the real-world applications of distributed databases, to better understand what this technology

Database Isolation Levels and Data Anomalies

Database Isolation Levels and Data Anomalies

Database isolation and data anomalies are important to understand. This Blog Post explains details regarding both and how they are linked