Tag: RDMS

How to Install and Configure ClickHouse on Ubuntu 20.04

Posted on January 15, 2021 by Margaret Fitzgerald | Updated: August 24, 2023

Category: Tutorials | Tags: Alter, Analytics, Big Data, ClickHouse, ClickHouse-Client, ClickHouse-Server, Columns, Create, Data Management, Data Structure, Database, Database Structure, DBMS, drop, Firewall, index, indexing, Insert, MariaDB, MergeTree, MySQL, OLAP, optimization, Performance, PHPMyAdmin, Ports, Queries, Query, RDMS, Select, Show Databases, SQL, Structure, Table, Ubuntu, Ubuntu 20.04

Reading Time: 13 minutes

What is ClickHouse?

ClickHouse is an open-source column-oriented DBMS (or database management system) primarily used for OLAP (or the Online Analytical Processing of queries). It is capable of blazing fast generation of real-time analytical data and reporting utilizing SQL queries. It is fault tolerant, scalable, highly reliable and contains a feature rich tool set.

Continue reading →

How to Install Microsoft SQL on Linux

Posted on October 25, 2019 by Justin Palmer | Updated: March 8, 2021

Category: Tutorials | Tags: CentOS, CentOS 7, Database, Linux, Microsoft, MSSQL, RDBMS, RDMS, Ubuntu, Ubuntu 18.04

Reading Time: 6 minutes

In this article, we will be discussing how to install Microsoft SQL or MSSQL on Linux. Microsoft SQL, colloquially referred to as MSSQL, is a relational database management system created by Microsoft. Open-source MySQL and PostgreSQL are typically synonymous with Linux distributions, but working with MSSQL on Linux is also supported. MSSQL offers some features that its open-source counterparts don’t, and depending on application requirements, it might be the right choice for an RDBMS. In this tutorial, we are going to walk through how to install MSSQL on CentOS 7 and Ubuntu 16.04.

Continue reading →