Oracle, PostgreSQL Postgres vs. Oracle access paths VI – Index Scan 09.08.2017 by Oracle Team By Franck Pachot . In the previous post my queries were still reading the indexed column only, from a table which had no modifications since the last vacuum, and then didn't need to read table pages:(…)
Database Administration & Monitoring, SQL Server SQL Server on Linux: Introduction to DBFS experimental tool 09.08.2017 by Microsoft Team A couple of months ago, Microsoft announced two additional command line tools for SQL Server that are mssql-scripter and DBFS. The latter has drawn my attention because it exposes live data from SQL Server DMVs as(…)
Database Administration & Monitoring MariaDB – How to migrate quickly MySQL to MariaDB over different hosts with mydumper/myloader and ncat 09.08.2017 by DevOps A lot of possibilities exist to migrate MySQL to MariaDB. In this blog I would like to show a scenario where I migrate MySQL 5.7.19 with a lot of databases to MariaDB 10.2.7, which is on a different host. The(…)
PostgreSQL Postgres vs. Oracle access paths V – FIRST ROWS and MIN/MAX 08.08.2017 by Oracle Team By Franck Pachot . We have seen how an index can help to avoid a sorting operation in the previous post. This avoids a blocking operation: the startup cost is minimal and the first rows can(…)
SQL Server, Technology Survey 24 HOP French edition 2017 – Session videos are available 07.08.2017 by Microsoft Team The 2nd edition of 24HOP French Edition 2017 is over and we had great sessions about SQL Server and various topics ( SQL Server 2017 new features, Azure, PowerBI, High Availability , Linux, Hyper-convergence , Modeling …) If(…)
Database Administration & Monitoring MariaDB – Speed up your logical MariaDB backups with mydumper 07.08.2017 by Oracle Team By William Sescu Per default, MariaDB is shipped with a utility called mysqldump for logical backups. For more information, please take a look at the following link. https://mariadb.com/kb/en/mariadb/mysqldump/ The mysqldump has advantages, e.g. it is easy to use and(…)
Oracle, PostgreSQL Postgres vs. Oracle access paths IV – Order By and Index 05.08.2017 by Oracle Team By Franck Pachot . I realize that I'm talking about indexes in Oracle and Postgres, and didn't mention yet the best website you can find about indexes, with concepts and examples for all RDBMS: http://use-the-index-luke.com. You(…)
Application integration & Middleware Encryption of shell scripts 05.08.2017 by Morgan Patou In this blog, I will talk about the encryption of files and in particular the encryption of a shell script because that was my use case. Before starting, some people may say/think that you shouldn’t encrypt any scripts and I(…)
Enterprise content management Documentum – Unable to install xCP 2.3 on a CS 7.3 05.08.2017 by Morgan Patou Beginning of this year, we were doing our first silent installations of the new Documentum stack. I already created a few blogs to talk about some issues with CS 7.3 and xPlore 1.6. This time, I will talk about xCP(…)
Enterprise content management Documentum – Using DA with Self-Signed SSL Certificate 05.08.2017 by Morgan Patou A few years ago, I was working on a Documentum project and one of the tasks was to setup all components in SSL. I already published a lot of blogs on this subject but there is one I wanted to(…)