Infrastructure at your Service

 

RDBMS (vs. NoSQL) scales the algorithm before the hardware

By | AWS, NoSQL | No Comments

By Franck Pachot . In The myth of NoSQL (vs. RDBMS) “joins dont scale” I explained that joins actually scale very well with an O(logN) on the input tables size, thanks to B*Tree index access, and can even be bounded by hash partitioning with local index, like in DynamoDB single-table design. Jonathan Lewis added a comment that, given the name of the tables (USERS and ORDERS). we should expect an increasing number of rows returned…

Read More
Franck Pachot

A lesson from NoSQL (vs. RDBMS): listen to your users

By | Database Administration & Monitoring, NoSQL | No Comments

By Franck Pachot . I have written a few blog posts about some NoSQL (vs. RDBMS) myths (“joins dont scale”, “agility: adding attributes” and “simpler API to bound resources”). And I’ll continue on other points that are claimed by some NoSQL vendors and are, in my opinion, misleading by lack of knowledge and facts about RDBMS databases. But here I’m sharing an opposite opinion: SQL being user-friendly is now a myth. Yes, that was the…

Read More
Steven Naudet

SQL Server Installation Wizard error : Failed to retrieve data for this request

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

Today I faced a strange issue when I tried to install a new SQL Server instance : Failed to retrieve data for this request This error occurred just after clicking on “New SQL Server stand-alone installation…” The error message is not helpful at all. So, the first step to troubleshoot an issue is to look at the error logs. The location by default is : C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log There is a summary.txt file…

Read More
Jérôme Dubar

ODA: odacli now supports Data Guard in 19.8

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | 2 Comments

Introduction I’ve been dreaming of this kind of feature: just because most of the ODA configurations now include Disaster Recovery capabilities, through Data Guard or Dbvisit standy. If Dbvisit will obviously never be integrated to odacli, the lack of Data Guard features is now solved by the very latest 19.8 ODA software appliance kit. How Data Guard was implemented before 19.8? Those who have been using ODA and Data Guard for a while know that…

Read More
Steven Naudet

SQL Server: Change Availability Group Endpoint Ownership

By | Database Administration & Monitoring | No Comments

I’m doing some cleaning on my customer’s instances. I want to delete the login of a previous DBA for 2 reasons; this person does not work anymore in my customer’s company and all DBA are members of a group that is given permission on the instances. I don’t want to see any DBA’s personal login on SQL Server instances. When I try to delete the login I receive the following error; Msg 15173, Level 16,…

Read More
Nicolas Penot

Git collaboration: quick start

By | Development & Performance | No Comments

Git collaboration: quick start If you want to keep the git repository of your project clean and predictive (which is highly recommendable), here is a simple workflow to follow. For the sake of this article, we are going to join the MongoDB project. First step: work safely on your branch When joining the project, the first step to get a local copy in your laptop: $ cd my_working_directory $ git clone [email protected]:nico/mongo.git Once you do…

Read More
Nabil Saoual

Control-M/EM sending alert to SNMP

By | Control-M | 4 Comments

Hello everybody, today we will see how to send Control-M alerts to a central monitoring software Introduction The aim is to send alerts and logs from Control-M to an event manager system such as Patrol/ BMC Truesight or Nagios. We will see together how to link Control-M to a central monitoring tool,and for that,Control-M admin and monitoring admin must work hand in hand 😊.So let’s start! Copy the Control-M/EM MIB file to your SNMP server:…

Read More
Stephane Biehler

Java and InfluxDB http api

By | Database Administration & Monitoring | No Comments

InfluxDB InfluxDB is a powerfull open source time series database (TSDB) developped by InfluxData. It’s a database optimized for time-stamped or time series data. Time series data are simply measurements or events that are tracked. It is particully interresting for metric tracking like server cpu, ram, application performances and so on. It is similar to SQL databases but different in many ways. The key here is the time. The database engine is optimized for high…

Read More
Franck Pachot

The myth of NoSQL (vs. RDBMS) “a simpler API to bound resources”

By | NoSQL, Oracle | No Comments

By Franck Pachot . NoSQL provides an API that is much simpler than SQL. And one advantage of it is that users cannot exceed a defined amount of resources in one call. You can read this in Alex DeBrie article https://www.alexdebrie.com/posts/dynamodb-no-bad-queries/#relational-queries-are-unbounded which I take as a base for some of my “Myth of NoSQL vs RDBMS” posts because he explains very well how SQL and NoSQL are perceived by the users. But this idea of…

Read More
Clemens Bleile

Oracle ASH SQL_PLAN_LINE_ID in adaptive plans

By | Oracle | No Comments

There are several methods to find out where time is spent in an execution plan of a query running in an Oracle database. Classical methods like SQL Trace and running a formatter tool like tkprof on the raw trace, or newer methods like SQL Monitor (when the Tuning Pack has been licensed) or running a query with the GATHER_PLAN_STATISTICS-hint (or with statistics_level=all set in the session) and then using DBMS_XPLAN.DISPLAY_CURSOR(format=>’ALLSTATS LAST’). However, what I often…

Read More
Nabil Saoual

Control-M/EM : How to manage a workflow with ecaqrtab utility

By | Database Administration & Monitoring | No Comments

Introduction Before the freshly come “workload manager”  feature on latest Control-M versions, the Control-M users used a lot of workarounds to manage the workload execution. Using Quantitative resources was one of the most used. Request We need to trigger a workflow on demand without having to hold the jobs or release them manually. For example, launch it and stop it at specifics time (on demand). Or preventing side effect if an operation that can impact…

Read More