Infrastructure at your Service

dbi services BLOG

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

David Barbarin

SQL Server AlwaysOn and availability groups : how to isolate the replication traffic from other networks?

By | Database Administration & Monitoring | No Comments
 

 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 of the network bandwidth as well as to be sure that the replication can be done without any latency issues in case of heavily network traffic issued by other applications or backup activities for instance….

Read More
Daniel Westermann

Setting up a sample replication with GoldenGate

By | Database Administration & Monitoring | No Comments
 

 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 prepare the databases and how to setup GoldenGate for a first sample replication between two Oracle 12.1.0.2 databases. My test setup is as follows: Hostname Database Type oelgg1 DB1 Source oelgg2 DB2 Target   The idea is that…

Read More
Daniel Westermann

Installing and patching Oracle GoldenGate 12c to the latest release

By | Database Administration & Monitoring | No Comments
 

 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 7.1 x64. The installation sources (as always) can be downloaded from otn.oracle.com. For the latest patchset you’ll need access to mos. At the time of writing the latest patchset is 12.1.2.1.9 and can be downloaded…

Read More
Daniel Westermann

Row level security is coming to PostgreSQL

By | Database Administration & Monitoring | No Comments
 

 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 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit (1 row) create table t ( id int primary key, name varchar(50), salary bigint ); insert into t ( id, name, salary ) values (…

Read More
Franck Pachot

DataBase Cloud Service performance – IOPS

By | Development & Performance | No Comments
 

  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. But do you have the performance you expect? I’ve tested I/O in the Cloud that just opened for Europe, so that I get an image of performance when nobody’s there. SLOB If you want to test IOPS, the tool…

Read More
Franck Pachot

SLOB in the Cloud: how to check Cloud Services performance

By | Database Administration & Monitoring | No Comments
 

 You buy resources on the Cloud, but they are mutualized, thanks to virtualization. Are you sure ou have the resources you paid for? When it comes to Oracle databases there are 3 ways to test performances: Run an application, or a simulation of an application, such as the excellent SwingBench from Dominic Giles Run low-level calibration tools, such as Orion that simulate database, good when you have no database yet Or run something in the…

Read More
Stéphane Haby

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

By | Technology Survey | No Comments
 

  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: Part I – Principle & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part IV – Maintenance & Metadata SQL Server version/built used for this serie of articles is CTP 2.2/13.0.407.1 Backup & Restore Before my Backup,…

Read More
Stéphane Haby

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

By | Technology Survey | No Comments
 

  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 & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part IV – Maintenance & Metadata SQL Server version/built used for this serie of articles is CTP 2.2/13.0.407.1 SELECT Command In my sample, I search information of the number of…

Read More
Stéphane Haby

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

By | Technology Survey | No Comments
 

  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 read: Part I – Principle & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part IV – Maintenance & Metadata SQL Server version/built used for this serie of articles…

Read More
Stéphane Haby

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

By | Technology Survey | No Comments
 

  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 divide my article into 4 parts to be clearer and easier to read: Part I – Principle & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part IV – Maintenance & Metadata To…

Read More