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.

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
David Barbarin

sp_cursor_fetch and performance considerations

By | Development & Performance | No Comments
 

 A couple of weeks ago, I performed a SQL Server audit and my customer talked me about a performance issue he faced only during the login phase of its application. After various exchange of information between my customer and the software editor, they noticed that this problem doesn’t occur when the application and the SQL Server instance are on the same server (less than one second with the software editor configuration against more than 10…

Read More
Franck Pachot

Oracle Cloud Services DBaaS and dbi services best practices

By | Database Administration & Monitoring | No Comments
 

  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