Database Administration & Monitoring, Oracle Oracle Standard Edition Two 02.09.2015 by Oracle Team By Franck Pachot . Look at the Oracle Download page: Standard Edition is there in 12.1.0.2 - more than one year after the release of the patchset for Enterprise Edition. It's a new name - SE2(…)
Database Administration & Monitoring SQL Server AlwaysOn and availability groups : how to isolate the replication traffic from other networks? 01.09.2015 by Microsoft Team A couple of days ago, I was involved in a project about implementing availability groups with SQL Server 2014. My customer wanted to isolate the replication traffic from the public network. The idea behind was to get a better control(…)
Database Administration & Monitoring Setting up a sample replication with GoldenGate 01.09.2015 by Daniel Westermann 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(…)
Database Administration & Monitoring Installing and patching Oracle GoldenGate 12c to the latest release 31.08.2015 by Daniel Westermann 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 Administration & Monitoring, Oracle DataBase Cloud Service performance – CPU 30.08.2015 by Oracle Team 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(…)
Database Administration & Monitoring Row level security is coming to PostgreSQL 29.08.2015 by Daniel Westermann 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(…)
Development & Performance, Oracle DataBase Cloud Service performance – IOPS 28.08.2015 by Oracle Team 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.
Database Administration & Monitoring, Oracle SLOB in the Cloud: how to check Cloud Services performance 28.08.2015 by Oracle Team 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(…)
Technology Survey SQL Server 2016: the Time Travel with temporal table – Part IV 28.08.2015 by Stéphane Haby 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:(…)
Technology Survey SQL Server 2016: the Time Travel with temporal table – Part III 28.08.2015 by Stéphane Haby 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 &(…)