Tag: Databases

Published on 05 June

Distributed Database Architecture: What Is It?

By Alexander FO , In Backend, DevOps, Software Architecture

Databases power all modern applications. They’re behind your Angry Birds mobile game as much they’re behind the space shuttle. In the beginning, databases were hosted on a signal physical machine. Basically, it was a computer running only one program: the database. Then we moved to running databases on virtual machines, where resources are shared among multiple operating systems and applications. In recent years we moved to running databases in the cloud. And we no longer use a single database instance to store the data. Modern database systems are spread across multiple computers …

# ,
Read More

Published on 11 May

The Most Effective SQL Server Activity Monitor Strategy

By Alexander FO , In DevOps, Software Architecture

Databases power all modern applications, from banking and ATM software to space shuttle systems and your Angry Birds game. Wherever you go, you will find databases. The most common databases used today are relational or SQL databases, where data is stored in interconnected tables. In turn, you can query those tables using a query language that resembles plain English, Standard Query Language (SQL). To get the most value of the SQL databases you use as a developer, system administrator, or database administrator, it’s vital that you have visibility into what’s going on. …

# , ,
Read More

Published on 11 May

Server Management Software: 5 Tools to Check Out

By Alexander FO , In DevOps

Introduction Around 30 years ago, a server was usually a standalone PC or mainframe that provided only one service. Think of a dedicated mainframe for emails, for instance. Things evolved from this to single standalone hardware that provides multiple services (email, http, ftp combined, for example) through virtual machines that can host multiple operating systems running dozens of services, and up to today, where servers are software defined and can run on anything from your washing machine to a drone. What Is Server Management Software? Even in the scenario of a single …

# , ,
Read More

Published on 03 February

RDS Instance Types Explained & How to Choose and Size Yours

By Alexander FO , In Backend, DevOps

Introduction Cloud computing provides us with the ability to deploy infrastructure as code. Not so long ago, to deploy a new database server you had to buy physical hardware: a hard disk, CPU, RAM, power supply, etc. Afterward, you had to install the database server, make it run once the machine starts, provision replicas, set up a backup policy and allocate space for it, handle errors, and routinely update it with security patches and new versions. Wow, it took a while even to write what’s required if you manage databases yourself. Just …

# , ,
Read More

Published on 12 July

SQL vs NoSQL Performance: Where One Outperforms the Other

By Alexander FO , In Backend, DevOps

NoSQL databases have taken the world by storm in recent years. What started as a niche phenomenon grew to rival the popularity of the “old” SQL relational databases. However, relational databases still have their use cases and are not going to disappear anytime soon. In this post, I’ll discuss the differences between SQL and NoSQL databases and do an analysis of their respective performance. Lastly, I’ll give a list of use cases for which one is better than the other and vice versa. What Are SQL Databases? SQL databases, or relational databases, …

# , ,
Read More