Daniel Holt - Dan The Engineer (Page 2)

Unlocking the power of data in your business: How to make the right decisions

Why using a data-driven approach to making business decisions is critical to the success of a business

Understanding Database Indexes

Although it can be challenging to choose which type to use, database indexes are necessary for enhancing query efficiency. We'll discuss the various database index types, their benefits and drawbacks, and when to utilise each one in this blog post. Read on to discover more about database indexing and how

Cloud

Multi-Cloud Database Deep Dive

A Deep Dive into the benefits and considerations of Multi-Cloud Database

CockroachDB

User Defined Functions

Understanding User-Defined Functions

CockroachDB

CockroachDB and Google Data Studio

Connecting CockroachDB and Data Studio

CockroachDB

Auto-Scaling Your Distributed Database: A Bad Idea?

In the past few years, software engineers have become increasingly aware of the importance of scaling data-intensive applications to meet the needs of its users. As with most things, though, there are both good and bad ways to go about it. One particularly bad approach that deserves a closer look

Database

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

CockroachDB

Why running your own database can be more costly than you think

Running your own database or the other extreme of using Database as a Service? That sounds like an easy choice, right? There are many factors you need to consider before making that choice. Read our article to find out why we believe running your own database can be more costly

Data

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

CockroachDB

CockroachDB: Dedicated Security - Authentication

CockroachDB Dedicated has 2 Levels of Authentication * CockroachDB Cloud Console * SQL Users In this Blog, we will discuss how both of these should be used to secure your Cockroach Cloud Organization account. Website Link for further Details - https://www.cockroachlabs.com/docs/cockroachcloud/console-access-management.html CockroachDB Cloud Console Within

Database

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

Distributed SQL

5 Reasons Why Distributed SQL databases are optimised for the Cloud

In this article, we’re going to explore why SQL databases are fast becoming the database of choice for enterprises looking to store their data in the Cloud. The reasons are many and varied, but there are five key reasons why distributed SQL databases are optimised for the Cloud and

CockroachDB

Bank of England Worried About Concentration of Risk in the Cloud

In the Bank of England’s semi-annual Financial Stability Report, the central bank expressed its concern about risks associated with cloud computing data centres, and how that could affect financial stability in the UK. The report identified three reasons for this issue: concentration of data centres; concentration of financial services

CockroachDB

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

CockroachDB

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

CockroachDB

Streaming Data from CockroachDB to Redpanda

CockroachDB

Active Passive vs Multi-Active Database Topologies

A Comparison of Active Passive vs Multi-Active Database Deployments

Cockroach Labs

DevOps culture: The need of the day.

DevOps Culture is the Future

CockroachDB

CockroachDB vs AWS Aurora

This article is all about comparing the feature sets of CockroachDB and Amazon Aurora. These are two of the most popular SQL and databases of the cloud era

CockroachDB

CockroachDB vs SQL Server

A quick comparison of cockroachdb and SQL Server.

CockroachDB Featured

Top 5 Useful Commands with CockroachDB

The Top 5 Commands used to help you become more proficient in administering and using CockroachDB

CockroachDB

Schema Design Considerations with CockroachDB. What is a Hotspot Not?

Want to know what considerations to make when selecting primary keys in cockroachDB? Want to know how CockroachDB diversifies and replicates it data?

CockroachDB Featured

CockroachDB - Fun with Encryption

In this post, Dan shows you how to create multiple store directories for CockroachDB nodes and encrypt them using different encryption keys. Different tables can then be stored and encrypted using different keys.

CockroachDB Featured

How to get started with CockroachDB - Binary, Docker or Kubernetes

Want to get started with CockroachDB. This is the perfect blog post for you. Today I am going to show you how to get started with distributed sql databases so you can start developing your application locally on your laptop.