Since SQL Server 2005 version, there is an excellent tool to manage SQL Server instances, that tool is “SQL Server Management Studio” (SSMS)
It is the regular tool to deal with SQL Server instances, but it is not the only way to do it. Continue reading “SQL Server database restore with sqlcmd”
Database size of a PostgreSQL server instance
How to obtain the database size of a PostgreSQL Server instance? Continue reading “Database size of a PostgreSQL server instance”
SQL Server Error: 15023
When we are restoring a database in a different SQL Server instance, it could happen that there is a Login with the same name of an existing user in the database. Continue reading “SQL Server Error: 15023”
MySQL database table creation
Do you need to create a table in MySQL? We show you how to do it with a small example. Continue reading “MySQL database table creation”
The Oracle DECODE function
The Oracle DECODE function can be considered an IF/ELSE variation. It compares the very same expression with other or others. Continue reading “The Oracle DECODE function”
Listing all columns from an Oracle database
In this short post, we are going to learn how to list all columns of every table in an Oracle 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 an Oracle database”