If you are going to run AI models locally on Ubuntu 22.04, 24.04 or 26.04, the first step is making sure the system detects the NVIDIA card correctly.
Continue reading “Prepare Ubuntu 22.04, 24.04 and 26.04 with NVIDIA for local AI”
Add a static route with netplan in Ubuntu 18.04, 20.04, 22.04 and 24.04
How to add a temporary static route with ip route and a persistent route with netplan in Ubuntu 18.04, 20.04, 22.04 and 24.04.
In this post we see how to add a static route in Ubuntu using ip route and netplan.
The ip route command is useful for adding a temporary route. To keep the route configured persistently in Ubuntu 18.04, 20.04, 22.04 and 24.04, we will use netplan.
Listing all columns from a MySQL database
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”
Database size of a MySQL server instance
How to obtain the database size of a MySQL Server instance? Continue reading “Database size of a MySQL server instance”
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 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”
Listing all columns from a SQL Server 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”