At last, we can install one of the best databases on our Linux servers: SQL Server 2017 supports Linux!
In this article, we will go through the step-by-step installation of SQL Server 2017 on Ubuntu 16.04. Continue reading “Install SQL Server 2017 on Ubuntu 16.04”
MySQL is a popular database engine in LAMP environments. This guide shows how to install MySQL Server 5.7 on Ubuntu 16.04 and manage its service with systemctl.
MySQL is probably the most popular database engine and, together with Apache and PHP on Linux, forms what is commonly called a LAMP server.
In this post we will see how to set up a MySQL Server 5.7 database server on Ubuntu 16.04. Continue reading “Install MySQL 5.7 on Ubuntu 16.04 and derivatives”
In this short post, we are going to learn how to list all columns of every table in a MySQL database.
We want to get the name of the column, the name of the table it belongs to and the type of date for that column. Continue reading “Listing all columns from a MySQL database”
How to obtain the database size of a MySQL Server instance? Continue reading “Database size of a MySQL server instance”
In this short post, we are going to learn how to list all columns of every table in a PostgreSQL database.
We want to get the table schema, the name of the table, the name of the column and the data type defined for that column. Continue reading “Listing all columns from a PostgreSQL database”
In this short post, we are going to learn how to list all columns of every table in a SQL Server database.
We want to get the schema, the name of the table, the name of the column and the data type. Continue reading “Listing all columns from a SQL Server database”
