How to obtain the database size of a MySQL Server instance? Continue reading “Database size of a MySQL server instance”
Tag: DBA
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”
Listing all the documents of a MongoDB database
In this short post, we are going to learn how to list all columns of every table in a MongoDB database.
We want to get all documents in a database. Continue reading “Listing all the documents of a MongoDB database”
SQL Server Database size
How can I know the size of my SQL Server databases?
In a SQL Server instance we might have several databases and each one of them have at least one file for data and another one for the transaction log, so we need to sum up data and log to know the size of each database. Continue reading “SQL Server Database size”
SQL Server database restore with sqlcmd
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”