Infrastructure at your Service

 
Stephane Biehler

OpenText Enterprise World Europe 2019 – Partner Day

By | Application integration & Middleware, Cloud, Entreprise content management | No Comments

First day of the #OTEW here at the Austria International Center in Vienna, Guillaume Fuchs and I where invited to assist to the Partner Global sessions. Welcome to OTEW Vienna 2019 Mark J. Barrenechea, the OpenText’s CEO & CTO, started the day with some generic topics concerning the global trends and achievements like: More and More partners and sponsors Cloud integration direction Strong security brought to customers AI & machine learning new trend New customer…

Read More
Stéphane Haby

SQL Server Temporal Table – How to store a history table in another file?

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Few days ago, a customer asks me if it is possible to move the history table to slower but cheaper storage. The question behind this is whether it is possible to create a history table on a separate filegroup and file. Few years ago, I write a serie of blogs about temporal table here. I will take the same example to try to set up a filegroup specific to a history table. In my sample,…

Read More
Jérôme Dubar

How to patch your ODA lite to 18.3.0.0.0

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

Even you don’t need 18c, or you’re not ready for this release, this patch will also update your 11gR2, 12cR1 and 12cR2 databases to the latest PSU available on ODA, it means for example the patchset from last July if you’re using 12cR1. Here is how to apply this latest patch for your ODA lite. In this example, the patch was applied on an X6-2S ODA running on previous release: 12.2.1.4.0. 1) Download the patch…

Read More
Soan Chatelain

SQL Konferenz 2019 – Day 1

By | SQL Server | No Comments

For my first “dbi visit”, I went to Darmstadt, in Germany, to attend SQL Konferenz 2019. There were more than 50 sessions over two days (20 & 21.02.2019) in several areas as SQL Administration, BI, DevOps, Azure & BigData. I decided to write a short glimpse of the most appreciated sessions. Keynote To start this event, they introduced the German SQL Server community (PASS.de) and the upcoming meetings this year, the well-known people are present…

Read More
Michael Hein

How to extract sql statements with awk

By | Database Administration & Monitoring | No Comments

A common problem is to extract sql statements out of a sql file e.g. produced by full metadata impdp. Often these files are too big to be edited with vi. Following statement extracts all sql statements with “CREATE MATERIALIZED VIEW” at the beginning with awk: cat impdp_full_metadata.sql | awk ‘BEGIN{ FLAG = 0 } { if( $0 ~ /CREATE MATERIALIZED VIEW/ ) FLAG=1; if(FLAG != 0) print $0; if ($0 ~ /;/ ) FLAG=0; }’…

Read More
Diawo Mayaki

How To Create A Recovery Services Vault In Azure

By | Cloud | No Comments

Creating A Recovery Services Vault In Azure To create a recovery services vault, we first need to create a resource group by using either the CLI or the Azure interface. Creating a resource group using the command line interface $resourceGroup = “recovvault” $location = “westeurope” az group create -n $resourceGroup -l $location The resource recovvault has been created successfully. Now we need to setup  the recovery services vault. From Azure portal, select the resource group…

Read More
Mouhamadou Diaw

PostgreSQL 12: New option –exclude-database for pg_dumpall

By | Database Administration & Monitoring, Postgres | No Comments

Up to PostgreSQL 11 pg_dump all was used to dump all PostgreSQL databases of a cluster into one script file. The script file then contains SQL commands that can be used as input to psql to restore the databases. It does this by calling pg_dump for each database in the cluster. PostgreSQL 12 is under development but we can test new features which will be implemented. Now with PostgreSQL 12 there is a new option…

Read More
Michael Hein

How to disable ACLs in Oracle 12c

By | Database Administration & Monitoring | No Comments

A common problem in Oracle 12c is, that ACLs are often not wanted to limit connections from database to other hosts. To disable ACLs is not that easy, so the best way is to enable connections and resolutions to all hosts for all users like following example: BEGIN DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( host => ‘*’, ace => xs$ace_type(privilege_list => xs$name_list(‘resolve’), principal_name => ‘PUBLIC’, principal_type => xs_acl.ptype_db)); DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( host => ‘*’, ace => xs$ace_type(privilege_list => xs$name_list(‘connect’), principal_name => ‘PUBLIC’,…

Read More
Marc Wagner

How workload policies is making your life easy

By | Database Administration & Monitoring | No Comments

Working as a control-M administrator, we are often requested to hold jobs or stop jobs during a period of time. Holding jobs and updating the job configuration might not be the most efficient way to do this. Workload policies is making your life really easier, giving you the possibility to configure such modification in advance and to let the system act independently whether the NDP (New Day Processing) is in the middle of the period…

Read More
Daniel Westermann

Working with files on the filesystem in PostgreSQL

By | Database Administration & Monitoring | No Comments

PostgreSQL comes with various helper functions that support you with working with files on the filesystem on the host PostgreSQL is running on. You might ask yourself why that is important but there are use cases for that. Maybe you want to list the contents of a directory because new files that showed up since the last check do trigger something. Maybe you want to load a file into the database (which you also can…

Read More