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.

Stéphane Haby

SQL Server 2016: Does Dynamic Data Masking works with INSERT INTO and SELECT INTO commands?

By | Database Administration & Monitoring | No Comments
 

 I wonder how works Dynamic Data Masking (DDM) with these two commands INSERT INTO  and SELECT INTO. First, I create a table and add some “sensitive data”: USE [DDM_TEST] GO CREATE TABLE [dbo].[Confidential]( [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED, [Name] [nvarchar](70)NULL, [CreditCard] [nvarchar](16)NULL, [Salary] [int] NULL, [Email] [nvarchar](60)NULL) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Stephane’,N’3546748598467584′,113459,N’sts@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’David’,N’3546746598450989′,143576,’dab@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Nathan’,N’3890098321457893′,118900,’nac@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Olivier’,N’3564890234785612′,98000,’olt@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Alain’,N’9897436900989342′,85900,’ala@dbi-services.com’)…

Read More
Daniel Westermann

Vertically scale your PostgreSQL infrastructure with pgpool – 1 – Basic setup and watchdog configuration

By | Database Administration & Monitoring | No Comments
 

 I have written some posts on how you can make your PostgreSQL deployment high available by using PostgreSQL’s streaming replication feature in the past ( 1, 2 ). The main issue you’ll have to resolve with such a setup is how the application can be made aware of a new master when a fail over happened. You could use EDB Failover Manager (1, 2, 3, 4) for that because it provides the functionality to move…

Read More
Pascal Brand

Apache JMeter and Cross-Site Request Forgery (CSRF) token management

By | Application integration & Middleware | No Comments
 

 Introduction In Nowadays web technologies a common defensive mechanism against Cross-Site Request Forgery (CSRF) attacks is to use a synchronizer token. This token might be unique for each request and thus it blocks us from using the recorded JMeter test session off the shelf. This blog will describe how this CSRF feature can be handled in JMeter. How to implement this feature The solution is to identify and extract the CSRF token from the response…

Read More
William Sescu

10th CH Exadata Community Meeting

By | Database Administration & Monitoring | One Comment
 

 Yesterday (15th of March), the 10th Switzerland Exadata Community Meeting took place. It was not a meeting only about Exadata, but also about the Oracle Database Appliances which became more and more popular. It is interesting, how many companies in Switzerland already use Exadata’s or ODA’s. A big topic was the Exadata 12.2.1.1.0 software release which includes over 30 unique software features and enhancements, like better analytics, better transaction processing, better consolidation, more secure and…

Read More
Pierre Sicot

Postgres Barman and DMK

By | Database Administration & Monitoring | No Comments
 

 As PostgreSQL is more and more present in our client’s infrastructure, I wanted to describe you the barman installation and configuration. Barman is the backup and recovery tool for PostgreSQL, I configured it using DMK out tool for infrastructure administrators on Oracle, MySQL, and PostgreSQL. I used two virtual severs running under RedHat Enterprise Libux 7.1, one for PostgreSQL database server (pg1) ands the second for barman (pg2). At first I install PostgreSQL 9.6 on…

Read More
Pierre Sicot

Oracle 12.2 and Transparent Data Encryption

By | Database Administration & Monitoring | No Comments
 

 Since the new Oracle 12.2.0 version is released, I decided to test the Transparent Data Encryption as new features are available. The following tests have been made in a multitenant environment, DB1 and two pluggable databases DB1PDB1 and DB1PDB2. The first step consists in creating a software keystore. A software keystore is a container that stores the Transparent Data Encryption key. We define its location in the sqlnet.ora file if we need to use it…

Read More
Stéphane Haby

SQL Server 2016: Does Dynamic Data Masking work with Temporal Table?

By | Database Administration & Monitoring | No Comments
 

 In the last IT Tagen 2016, I presented the Dynamic Data Masking (DDM) and how it worked. To add a little fun, I applied the DDM to a temporal table to see if the history table inherits also from DDM’s rules. In this blog, I explain all the different steps to reproduce my last demo. Step 1: Create the table and the temporal table in the database DDM_TEST USE [DDM_TEST] GO CREATE TABLE [dbo].[Confidential]( [ID]…

Read More
Daniel Westermann

EDB BART 2.0 – How to upgrade and block level incremental backups

By | Database Administration & Monitoring | No Comments
 

 We already have some posts on how you can use EDB BART to backup and restore your PostgreSQL instances from one central server (EnterpriseDB Backup and Recovery Tool (BART), getting started with postgres plus advanced server (2) – setting up a backup and recovery server). The current version you can download from the EnterpriseDB website is 1.1 but version 2.0 is in beta and can be tested already. The main new feature is that BART…

Read More
Franck Pachot

Google Cloud Platform instances and Oracle Database

By | Cloud, Database Administration & Monitoring | No Comments
 

 When it comes to choose a cloud instance to run Oracle Database, you want to be able to run your workload on the minimum CPU cores. This is why in a previous post I measured how many logical reads per seconds can be achieved with a SLOB workload, on AWS which is often the first considered, and will probably do it on Azure in the future. I did the same on the Oracle Cloud which…

Read More