Infrastructure at your Service

Category

Database Administration & Monitoring

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
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
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
Franck Pachot

A Serverless Standby Database called Oracle Autonomous Data Guard

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

By Franck Pachot . Announced by Larry Ellison last week, here it is: the Autonomous Data Guard. You can try it, unfortunately not on the Free Tier. First you create an Autonomous Database (ATP or ADW) and then you enable Autonomous Data Guard. You know that “Autonomous” is the marketing brand for the services that automate a lot of things, sometimes based on features that are in Oracle Database for a long time. So let’s…

Read More
Ali Asghari

Create and configure an Oracle linked server in SQL Server Instance

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

What is Linked server ? Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit hard. For exemple moving some data from an Oracle database to a SQL Server database is not easy. A linked servers is configured to enable the Database Engine to execute a Transact-SQL statement that includes…

Read More
Franck Pachot

DBPod – le podcast Bases de Données

By | AWS, Cloud, Database Administration & Monitoring, Database management, Development & Performance, DevOps, NoSQL, Oracle, Postgres, SQL Server | No Comments

By Franck Pachot . J’essaie quelque chose de nouveau. Je publie beaucoup en anglais (blog, articles, présentations) mais cette fois quelque chose de 100% francophone. En sortant du confinement, on reprend les transports (train, voiture,…) et c’est l’occasion de se détendre en musique mais aussi de s’informer avec des podcasts. J’ai l’impression que c’est un format qui a de l’avenir: moins contraignant que regarder une video ou ou lire un article ou une newsletter. Alors…

Read More