Database Administration & Monitoring

Red Hat 8 Server in 9 minutes into the Google Cloud

Do you have 9 minutes to learn how to quick start with the Google Cloud? Here is a simple copy/past procedure to successfully deploy a Red Hat 8 compute server into the Cloud. Installation of the Google command client(…)

dbvisit 9: Automatic Failover

By Mouhamadou Diaw dbvisit 9 is released since a few months. And one new feature I tested is the Automatic Failover. In this blog I suppose that dbvisit 9 is already installed and that the standby database is already created.

Deploying SQL Server 2019 container on RHEL 8 with podman

Having a fresh install of RHEL8 on my lab environment, I was curious to take a look at new containerization stuff from Red Hat in the context of SQL Server 2019. Good chances are the future version of SQL Server(…)

Kubernetes – How to install a single master cluster with kubeadm?

To bootstrap a minimal K8S cluster for testing purpose, kubeadm is a very interesting tool. The goal of this blog is not to explain to you the K8S architecture or the components but only the deployment part. using kubeadm. The(…)

SQL Server 2019 availability group R/W connection redirection, routing mesh and load balancing

SQL Server 2019 availability group feature will provide secondary to primary replica read/write connection redirection. I wrote about it in a previous blog post here. It consists(…)

ORA-01000 and agent13c

Recently I received errors messages from OEM13c saying too many cursors were opened in a database: instance_throughput:ORA-01000: maximum open cursors exceeded My database had currently this open_cursors value: SQL> show parameter open_cursors NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ open_cursors integer(…)

Microsoft Inspire Partner Event 2019 / Day 3

dbi services at Microsoft Inspire Conference Core Note Satya Nadella – Day 3 The day started with the Core Note from Satya Nadella. Being alone at the conference allowed me to find one of the very last well-located seat to(…)

Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption

From time to time you might require to reboot your AWS instances. Maye you applied some patches or for whatever reason. Rebooting an AWS instance can be done in several ways: You can of course do that directly from the(…)

Microsoft Inspire Partner Event 2019 / Day 2

dbi services at Microsoft Inspire Conference SQL Server 2019 is in “public preview” stage, live from Microsoft Inspire 2019 – Day 2 Anshul Rampal (SQL Server product marketing team) and Rony Chatterjee (SQL Server Core team / Product Manager) presented(…)

Microsoft Inspire Partner Event 2019 / Day 1

dbi services at Microsoft Inspire Conference Summary of my first participation – Day 1 After 20 years in the business of IT Infrastructure, time has come to open my mind 😉 and Microsoft Inspire is the perfect opportunity. It is(…)