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”
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”