Infrastructure at your Service

Category

Database Administration & Monitoring

David Barbarin

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

By | Database Administration & Monitoring | 12 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 | 8 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 | 8 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: ([email protected][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
Oracle Team

SLOB in the Cloud: how to check Cloud Services performance

By | Database Administration & Monitoring, Oracle | No Comments

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 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…

Read More
Oracle Team

Oracle Cloud Services DBaaS and dbi services best practices

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . When we give our trainings (dbi services workshops) we signal our best practices with this logo. It’s our know-how, acquired through experience, consulting, service desk, exchange at events, beta testing, etc. that we share with our customers. Let’s have a look at a few points that we recommend to change if you provision a database with DBaaS on the Cloud.

Read More
Stéphane Haby

SQL Server, Integration Services and Package Versions

By | Database Administration & Monitoring | No Comments

A lot of people ask me about the different versions of SQL Server Integration Services and packages. I create rapidly this little table to summarize it: With SQL Server 2008 and 2008 R2, the SSIS version is the same than SQL Server Integration Services 10.0. With SQL Server 2005, the SSIS version is not contained in the service name. To get this information, you must check directly in the MsDtsSrvr.exe file. How to know your…

Read More