Database Administration & Monitoring Deploying your own PostgreSQL image on Nutanix Era 17.01.2020 by Daniel Westermann Some days ago we had a very good training on Nutanix. Nutanix is a Hyper-converged infrastructure and that means that all is software driven and the system can be deployed on many(…)
Database Administration & Monitoring, Oracle Dbvisit Standby 9 : Do you know the new snapshot feature? 16.01.2020 by Oracle Team By Mouhamadou Diaw Dbvisit snapshot option is a new feature available starting from version 9.0.06. I have tested this option and in this blog I am describing the tasks I have done. The configuration I am using is following(…)
Database Administration & Monitoring, Oracle ARRAYSIZE or ROWPREFETCH in sqlplus? 08.01.2020 by Clemens Bleile ARRAYSIZE or ROWPREFETCH in sqlplus? What is the difference between the well known sqlplus-setting arraysize and the new sqlplus-12.2.-feature rowprefetch? In Blog https://www.dbi-services.com/blog/oracle-fasttrue-in-sqlplus-some-thoughts-about-rowprefetch/ I showed a case, which helps to reduce the logical IOs when(…)
Database Administration & Monitoring, Oracle Oracle FAST=TRUE in sqlplus? Some thoughts about rowprefetch 05.01.2020 by Clemens Bleile During my time as a Consultant working on Tuning Tasks I had the feeling that many people think that there is an Oracle-parameter “FAST=TRUE” to speed up the performance and throughput of the database calls. Unfortunately such a parameter is(…)
Database Administration & Monitoring One Host, multiple PostgreSQL Clusters – Monitoring using EDB PEM 24.12.2019 by Open source Team At a customer we implemented the EDB Postgres Enterprise Manager. As they run multiple PostgreSQL cluster on one server, they wanted, for sure, to monitor all the cluster using PEM. This blog should give you a short guidance on(…)
Database Administration & Monitoring, DevOps, Docker, Kubernetes Jenkins X ecosystem: Kaniko as image builder 18.12.2019 by DevOps For a few months now, we started a huge project at a customer; build a complete CI/CD platform for Documentum. The final goal is to create a CI/CD process for platform and software delivery to reduce as possible the delivery(…)
Database Administration & Monitoring Power BI Report Server – Kerberos Advanced configuration 16.12.2019 by Christophe Cosme Introduction Following the basic configuration explained in a previous blog (Link), I describe here how to make more advanced configurations in some specific cases but often met by customers. It is only complementing what has being described in the(…)
Database Administration & Monitoring Documentum – MigrationUtil – 5 – Change Installation Owner 12.12.2019 by David Diab The Documentum installation owner is the operating system user that owns the server executable and other related files along with the OS process when the server is running. It is originally determined when the server is installed, in fact, it(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server – Collecting last backup information in an AlwaysOn environment 12.12.2019 by Christophe Cosme Introduction Sometimes you face interesting challenges with unusual environment. One of my customer needed a automated and flexible backup solution. Said like that nothing very complex you will say. But if I mention that some databases were 60TB big with(…)
Database Administration & Monitoring Upgrade your Power BI Report Server 11.12.2019 by Christophe Cosme Introduction Even if upgrading your Power BI Report Server is straight forward, I have been asked many times where to find the installation files and how to run it that I thought a blog is worth it. Before you start(…)