Infrastructure at your Service

Stéphane Haby

SQL Server Tips: How many different datetime are in my column and what the delta?

By | Database management, Development & Performance, SQL Server | No Comments
 

 Few months ago, a customer asks me for finding in a column, how many rows exist with the same date & time and the delta between them. The column default value  is based on the function CURRENT_TIMESTAMP and used as key as well. This is obviously a very bad idea but let’s go ahead… This anti pattern may lead to a lot of duplicate keys and the customer wanted to get a picture of the…

Read More
Mouhamadou Diaw

Dbvisit 8 Standby Daemon on Windows

By | Database Administration & Monitoring, Database management | No Comments
 

 In this previous blog, we have installed Dbvisit standby for Windows on both servers. We suppose that the database is created and that the standby is configured (see this blog). The steps are the same that on Linux except that the command is launched on a traditional DOS terminal or a PowerShell. We will not describe these steps (see here for more details). Dbvisit by default will neither send nor apply the archived log files….

Read More
Mouhamadou Diaw

Install Dbvisit 8 on Windows

By | Database Administration & Monitoring, Database management | No Comments
 

 In a previous blog we described how to install dbvisit standby in a Linux box. In this article I am going to describe the installation on a Windows machine. We are using dbvisit 8 and windows server 2016. The name of my servers are winserver1 and winserver2. The first thing you will have to do is to download dbvisit standby package here . A trial key will be sent to you. Before starting the installation…

Read More
Stéphane Haby

SQL Server Tips: Drop a database-user attached to a service…

By | Database Administration & Monitoring, Database management, SQL Server | No Comments
 

 Few weeks ago, I have a little issue when I try to drop a database-user without login Unfortunately, I do a little mistake at the beginning… I receive like every morning a report if all AD logins (computers, groups, users) registered on SQL server instances are in the AD with the useful command sp_validatelogins This report indicates that a computer name dbi\server_name$ was no more in the AD. I drop the login without problem and…

Read More
Oracle Team

COMMIT

By | Oracle | 4 Comments
 

 By Franck Pachot . COMMIT is the SQL statement that ends a transaction, with two goals: persistence (changes are durable) and sharing (changes are visible to others). That’s a weird title and introduction for the 499th blog post I write on the dbi-services blog. 499 posts in nearly 5 years- roughly two blog posts per week. This activity was mainly motivated by the will to persist and share what I learn every day.

Read More
Pierre Sicot

RMAN PITR recover table Oracle 12c

By | Database Administration & Monitoring | No Comments
 

 At one client’s site, I had to restore a table someone had partially deleted one week before. Before Oracle 12c, we had to duplicate the target database to another server, and then to export and import data to the target database. But depending on the database size, it could cost a lot of time, and as nobody knew when the delete action happened, it was more practical to use the rman recover table command in…

Read More
Pascal Brand

Deploy WebLogic docker images using Docker Toolbox and Virtual Box on Windows

By | Application integration & Middleware | No Comments
 

 I was interested to run Docker on my Windows machine and found out the Docker Toolbox for Windows that configure itself with the already installed VirtualBox at installation time. Once installed, You can start the Docker QuickStart shell preconfigured for a Docker command-line environment. At startup time it will start a VM named default and will be ready to work with Docker. Starting “default”… (default) Check network to re-create if needed… (default) Waiting for an IP……

Read More
David Barbarin

Deploying SQL Server on MiniShift / RedHat OpenShift

By | Database Administration & Monitoring | No Comments
 

 Currently we begin to see customer adopting containerization for SQL Server databases (mainly driven by CI/CD and DevOps trends). A lot of them are using RedHat OpenShift as container management platform. From my side, I didn’t want to setup a complete OpenShift infrastructure on my lab to test only my SQL Server pod deployment on such infrastructure. I rather installed MiniShift that comes with one OpenShift node cluster which perfectly meets my requirements.    …

Read More
Mouhamadou Diaw

Oracle 18c DataGuard with Nologging Mode

By | Database Administration & Monitoring | 3 Comments
 

 With Oracle 18c database nologging has been extended with two new modes: Standby Nologging for Load Performance and Standby Nologging for Data Availability. These modes provide better support for use in an Oracle Active Data Guard environment without significantly increasing the amount of redo generated. In the documentation we can find following definitions: FORCE LOGGING mode prevents any load operation from being performed in a nonlogged manner. This can slow down the load process because…

Read More
Marc Wagner

RMAN catalog upgrade, why, when and how

By | Database Administration & Monitoring | No Comments
 

 One of our customer has been initially creating a RMAN catalog on an Oracle database release 12.1.0.2.0 and was now intending to register new Oracle 12.2.0.1.0 databases. Registering the databases will be failing with errors : PL/SQL package RCAT.DBMS_RCVCAT version 12.01.00.02 in RCVCAT database is too old RMAN-06429: RCVCAT database is not compatible with this version of RMAN

Read More
Oracle Team

The size of Oracle Home: from 9GB to 600MB – What about SQL Server?

By | Database Administration & Monitoring | No Comments
 

 Holidays is over and let’s start working with a funny write-up. I was reading interesting stuff done by my colleagues Franck Pachot and Daniel Westermann about reducing the size of Oracle / PostgreSQL binaries at the minimum in the context of a Docker images. I was curious what can be done on SQL Server side on Linux environment but just keep in mind that some operations performed in this post are probably not supported in…

Read More
Jérôme Dubar

Restoring a database without having any controlfile backup

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

 It should never happen but sometimes it happens. You just lost your datafiles as well as your fast recovery area (probably because most of the time these areas are on the same disks despite the recommendations). Normal restore operations with RMAN are quite easy and secure as far as you have backupsets for database, archivelogs, and spfile/controlfile: Step 1 – restore the spfile and start the instance Step 2 – restore the controlfile and mount…

Read More