Unattended Installation of Ubuntu 26.04 with autoinstall
The following are the steps for an unattended installation of Ubuntu 26.04 on VirtualBox using autoinstall and cloud-init. The host system in my case is Windows 11.
PostgreSQL Cheat Sheet
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.
SQL Server Cheat Sheet
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.
Unattended Installation of RedHat Enterprise Linux 10.1 on VirtualBox
The following steps describe an unattended installation of RedHat Enterprise Linux 10.1 on VirtualBox. The host system in my case is Windows 10.
Unattended Installation of RedHat Enterprise Linux 9.7 on VirtualBox
The following steps describe an unattended installation of RedHat Enterprise Linux 9.7 on VirtualBox. The host system in my case is Windows 10.
Exporting Data in Parallel
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.
PL/SQL script: Check a Oracle View
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.
PL/SQL script: Empty schema
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.