Database Administration & Monitoring, Database management, Oracle Oracle 21c : Dealing with FastStartFailoverActionOnPreCalloutFailure 14.04.2022 by Oracle Team By Mouhamadou Diaw In a previous blog I talked about the FSFO callout scripts which is a new feature with Oracle 21c with the broker. This feature will allow to execute some tasks before and after a(…)
Database Administration & Monitoring, PostgreSQL PostgreSQL 15: Some new features 12.04.2022 by Open source Team PostgreSQL version 15 is on its way and we get a better and better look, what will be included in the future release. So it's time to have a look at some new future features(…)
Database Administration & Monitoring PostgreSQL 15: More flexibility with setting parameters 12.04.2022 by Daniel Westermann Another nice feature just made it into PostgreSQL 15: You can now control who is allowed to set specific parameters. This gives you a lot more flexibility, especially when you are hosting PostgreSQL instances for your customers. You can delegate(…)
Database Administration & Monitoring, Development & Performance, Operating systems, Oracle Extract all DDL from an Oracle database 11.04.2022 by Jérôme Dubar Introduction Extracting DDL is sometime useful for creating similar objects in another database without data. Basically everything can be extracted from a running Oracle database. The needs My customer asked me to replicate a database without any data. The goal(…)
Cloud, Database management, SQL Server, Technology Survey Striim, real-time data integration 11.04.2022 by Stéphane Savorgnano In my first blog-post about Striim, I showed you how to create an Initial Load from an on-premise database to an Azure SQL DB. In this second blog post I will create an application which will stream Data(…)
Database Administration & Monitoring, Database management, Oracle Active Duplicate from standby database 07.04.2022 by Oracle Team By Mouhamadou Diaw Generally we do active duplicate from primary database, but I think it should be fine to see what happen if we do active duplicate a database from a standby database. So, I do some tests and I(…)
Cloud, Database management, SQL Server, Technology Survey Striim, first step 04.04.2022 by Stéphane Savorgnano In this blog-post I will discuss about my first test with Striim. Striim is a data integration platform which can ingest real-time data from a variety of sources (SQL Server, Oracle, Kafka, Hadoop…) and quickly deliver it to Cloud(…)
Business Intelligence, Development & Performance, SQL Server SSDT offline installation for Visual Studio 2019 25.03.2022 by Christophe Cosme Introduction Before Visual Studio 2019, you were able to install the SSDT with the offline installer. You were able to install it as a standalone Visual Studio for SSDT or for an already installed Visual Studio 2017. It was(…)
Database Administration & Monitoring Upcoming RHEL 9 23.03.2022 by Open source Team This Blog is about a setup of RHEL 9 BETA and changes to RHEL 8 and Fedora 34 which is the base of RHEL 9. Let’s start with the setup. Start the installation. Preview warning:(…)
Oracle Oracle DBs and ransomware attacks 23.03.2022 by Clemens Bleile By Clemens Bleile I had a discussion with a customer recently about the risk of running into an issue with ransomware encrypting data of Oracle databases. Just to quickly recap on what ransomware is: Wikipedia: Ransomware is a type(…)