All articles

Setting up a sample replication with GoldenGate

The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release: Installing and patching Oracle GoldenGate 12c to the latest release In this post I’ll look in how to(…)

Installing and patching Oracle GoldenGate 12c to the latest release

As more and more customers ask for expertise in Oracle GoldenGate this blog post is the first in a series and outlines how to install Oracle GoldenGate 12c and how to patch it to the latest release on Oracle Linux(…)

DataBase Cloud Service performance – CPU

By Franck Pachot . In the previous blog post I've measured the physical i/o performance, with SLOB. We can run the same with a small size of data and a large buffer cache(…)

Row level security is coming to PostgreSQL

Before PostgreSQL 9.5 (which is in alpha2 currently) you could grant access to individual columns of a table to users or roles. A little test script to demonstrate this: (postgres@[local]:5432) [postgres] > select version(); version -------------------------------------------------------------------------------------------------------------- PostgreSQL(…)

DataBase Cloud Service performance – IOPS

By Franck Pachot . Having a database in the cloud is very nice. You add storage with a few clicks. You don’t have to think about the storage type (DAS, SAN, NAS), size of disks, stripe size, SSD, etc.

SLOB in the Cloud: how to check Cloud Services performance

By Franck Pachot . You buy resources on the Cloud, but they are mutualized, thanks to virtualization. Are you sure you have the resources you paid for? When it comes to Oracle databases there are 3 ways to test(…)

SQL Server 2016: the Time Travel with temporal table – Part IV

Maintenance & Metadata My last chapter is about the maintenance backup/restore, index rebuild/reorg., etc. and the Metadata. I divide my article into 4 parts to be clearer and easier to read:(…)

SQL Server 2016: the Time Travel with temporal table – Part III

SELECT command In this article, I present the last command SELECT. I divide my article into 4 parts to be clearer and easier to read: Part I – Principle &(…)

SQL Server 2016: the Time Travel with temporal table – Part II

INSERT, UPDATE & DELETE commands After the introduction and the table creation, in this second part, I present the 3 important commands INSERT, UPDATE & DELETE. I divide my article into 4 parts to be clearer and easier to(…)

SQL Server 2016: the Time Travel with temporal table – Part I

Principle & Creation Microsoft create in SQL server 2016 a new feature temporal table, based on the latest edition of the SQL standard: SQL:2011. If you want read more about this standard, click here. I(…)