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”
Tag: DBA
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”
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”
Tablespace size of an Oracle Database
How can I know the size of my Oracle Database? What is the size of the Tablespaces in an Oracle Database?
An Oracle database stores the data in logical units called Tablespaces. Therefore, to know the size of the whole instance you need to know the size of each tablespace. Continue reading “Tablespace size of an Oracle Database”