Infrastructure at your Service

Category Archives: Database Administration & Monitoring

David Barbarin

SQL Server on Linux and logging

By | Database Administration & Monitoring | No Comments

On Windows world, SQL Server logs information both into the SQL Server error log and the Application log. Both automatically timestamp all recorded events. Unlike the SQL Server error log, the Windows application log provides an overall picture of events that occur globally on the Windows operating system. Thus, regarding the encountered issues taking a look at such event logs – by using either the Windows event viewer or the Get-EventLog PowerShell cmdlet – may be very helpful to figure…

 
Read More
Nicolas Penot

Oracle Application Container: a Swiss Use case

By | Database Administration & Monitoring | No Comments

Here we want to start a business in Switzerland in 3 different areas and make it easy to start a new market area as soon as required by that business. We are going to use the Application Container feature in order to: Have a dedicated PDB for each marker with shared and local metadata and data Roll out frequently data model and code to add features in a central manner with one command We have…

 
Read More
David Barbarin

Moving tables ONLINE on filegroup with constraints and LOB data

By | Database Administration & Monitoring | No Comments

Let’s start this new week by going back to a discussion with one of my customers a couple of days ago about moving several tables into different filegroups. Let’s say that some of them contained LOB data. Let’s add to the game another customer requirement: moving all of them ONLINE to avoid impacting the data availability during the migration process. The concerned tables had schema constraints as primary key and foreign keys and non-clustered indexes as well. So a pretty common schema we may deal with daily at…

 
Read More
Mouhamadou Diaw

Automatic Data Optimization Part II : StorageTiering

By | Database Administration & Monitoring | No Comments

In first a previous blog, we saw how Automatic Data Optimization can be used to compress data under predefined conditions. In this blog we will see that another possible action with ADO is to move data to another storage. Indeed we will demonstrate how it is possible to move a table to another tablespace based on predefined conditions. We are using oracle a 12.1.0.2 non-CDB database. Let’s considerer following table ARTICLE in the tablespace USERS…

 
Read More
Mouhamadou Diaw

Automatic Data Optimization Part I : Compression Tiering

By | Database Administration & Monitoring | No Comments

Nowadays data are increasing more and more. And some challenges we can face can be how to reduce storage costs and how to improve performance. With Oracle 12c, the feature Automatic Data Optimization (ADO) can help us. In this first blog we will see how we can use ADO to compress data under predefined conditions. ADO is part of Information Lifecycle Management (ILM). Note that ADO requires Advanced Compression Option. In this article we are…

 
Read More
Clemens Bleile

Running the Oracle Client on a Raspberry Pi

By | Database Administration & Monitoring, Database management, Development & Performance, Oracle | No Comments

What are the possibilities to use a Raspberry Pi computer as an Oracle client? Besides other things I’ll show a possibility in this Blog to run the fat/thick Oracle Client on a Raspberry Pi! REMARK: All examples below were made with an Rasperry Pi 3 and the OS Raspbian, which can be downloaded from https://www.raspberrypi.org/downloads First of all what’s possible with Java and Thin Clients? Running the Java-Programs sqldeveloper or its counterpart in command line…

 
Read More
Grégory Steulet

GDPR compliant by installing software editors tools?

By | Database Administration & Monitoring, Technology Survey | No Comments

GDPR goals and scope In few months (25 May 2018) the EU General Data Protection Regulation (GDPR) will be in force and will replace the Data Protection Directive 95/46/EC. His goals are to harmonize data privacy laws across Europe, to protect and empower all EU citizens’ data privacy and to reshape the way organizations across the region approach data privacy. You can find all information related to GDPR on https://www.eugdpr.org and the official PDF of…

 
Read More
Stéphane Haby

SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM

By | Database Administration & Monitoring, Development & Performance, Technology Survey | 4 Comments

Last month, I present in the IT-Tage 2017 in Frankfurt am Main, a session about SQL Server 2017 overview. During my session I made a demo on one of the new string T-SQL Commands: TRIM. My demo was very simple but I have also 2 very good questions. Before, I write about these question, I will show you what is TRIM. This function is a replacement of RTRIM and LTRIM to delete all space character…

 
Read More
Nicolas Penot

GoldenGate 12.2.0.2 installation in a Grid infrastructure12cR2

By | Database Administration & Monitoring | No Comments

This post is a demonstration on how to deploy a fully supported Oracle GoldenGate as cluster resources. We are going to use the Oracle Grid Infrastructure Agents, called XAG to integrate the GoldenGate instance within our cluster as a cluster managed resource. This tool is provided by Oracle in the binaries with the release 12c and later but it is recommended to download and use the last version out of the box (available here). This…

 
Read More
David Barbarin

Experiencing update statistics on a big table with circuitous ways

By | Database Administration & Monitoring | No Comments

This is my first blog of this new year and since a while by the way. Indeed, last year, I put all my energy to realign my Linux skills with the new Microsoft’s strategy that opens SQL Server to Open Source world. But at the same time, I did a lot of interesting stuff at customers shops and I decided to write about one  of them to begin this new year 2018. In this blog…

 
Read More