This PostgreSQL Cheat Sheet provides a compact overview of commonly used SQL statements, functions and administration commands for developers and DBAs. Whether for quick lookup, troubleshooting or learning purposes, this reference guide is designed to make working with PostgreSQL faster and more efficient.
This SQL Server Cheat Sheet provides a compact overview of commonly used SQL statements, functions and administration commands for developers and DBAs. Whether for quick lookup, troubleshooting or learning purposes, this reference guide is designed to make working with SQL Server faster and more efficient.
The following steps describe an unattended installation of RedHat Enterprise Linux 10.1 on VirtualBox. The host system in my case is Windows 10.
The following steps describe an unattended installation of RedHat Enterprise Linux 9.7 on VirtualBox. The host system in my case is Windows 10.
I recently had a customer that needed to export data from a huge table to a different machine in csv format very fast. The Database was Standard Edition 2 (SE2) so there was no Parallel Query Option to use.
This PL/SQL script can be used to find issues with Oracle Views. For example it shows data type conversions being done that could result in an sub optimal plan.
This PL/SQL script can be used to remove all objects of one ore more schemas. This might be used in preparation of an DataPump import.
This PL/SQL script can be used to resize Oracle Redo Logfiles. All existing logfile members of all groups will be resized to a specific size.