Rename an existing PostgreSQL Database

Renaming a PostgreSQL is one of the activities that could be necessary during a normal database lifecycle, sometimes due to testing or development related activities linked to a pre-existing database. Let’s see which PL/pgSQL statement we can use to rename a database. Read More …

SQL Server – Temporary Tables

SQL Server temp tables are very useful for temporary modifications or transformations to data that we do not need to keep rather than manipulate or work with permanent tables. Let’s say you want full DDL or DML access to a table, but don’t have it. You can use your existing read access to pull the data into a SQL Server temporary table and make adjustments from there. Read More …