Infrastructure at your Service

 
Stéphane Haby

SQL Server Tips: Path of the default trace file is null

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

In addition of my precedent blog about this subject “SQL Server Tips: Default trace enabled but no file is active…”, I add a new case where the default path of the trace file was empty. The first step was to verify if the default trace is enabled with the command: SELECT * FROM sys.configurations WHERE name=’default trace enable’ It is enabled, then I check the current running trace with the view sys.traces SELECT * FROM…

Read More
Saïd Mendi

PostgreSQL Meetup at CERN, Geneva, January 17, 2020

By | Database Administration & Monitoring, Postgres | No Comments

Registration Last Friday (17/01/20) I had the opportunity to go to Geneva at CERN to attend a PostgreSQL meetup. I’m really happy to write a blog about for a lot of reasons. First of all, it was about PostgreSQL (essential these days), also for the contributors as Oleg Bartunov and finally because of the organizers: Franck Pachot (old & soon new colleague by dbi-services) & Laeticia Avrot I met at the SOUG Day in Lausane.

Read More
Daniel Westermann

Adding PostgreSQL extensions without being super user?

By | Database Administration & Monitoring | 2 Comments

Usually, when you need to install a PostgreSQL extension you do this as superuser (or at least I am doing it like this). The downside of that is, of course, that a super user must be available once a new extension is required or that all the extensions are installed by default (e.g. in template1). Recently the question popped up internally if you can install extensions without being super user. The answer is: yes and…

Read More
Jérôme Dubar

Make Oracle database simple again!

By | Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Operation systems, Oracle | 6 Comments

Introduction Let’s have a look at how to make Oracle database as simple as it was before. Oracle database is a great piece of software, yes it’s quite expensive, but it’s still the reference and most of the companies can find a configuration that fits their needs according to a budget. Another complain about Oracle is the complexity: nothing is really simple, and you’ll need skillful DBA(s) to deploy, manage, upgrade, troubleshoot your databases. But…

Read More
Stéphane Haby

One day training @ Microsoft Azure Cloud Workshop

By | Big Data, Cloud, Database Administration & Monitoring, Database management, SQL Server, Technology Survey | No Comments

Today, with my colleague Christophe, we follow the Microsoft Azure Training Day: Data and Analytics @ Microsoft Zürich (Wallisellen to be exact). After a presentation of SQL Server 2019, we begin with the First Lab about SQL Server 2019 and new features and we going through intelligent query processing, Data Discovery and Classification for personally identifiable information (PII) and General Data Protection Regulation (GDPR) and secure enclave. One of my favorites part of the lab…

Read More
Stéphane Haby

SQL Server Tips: Orphan database user but not so orphan…

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

Beginning of this year, it is good to clean up orphan users in SQL Server databases. Even if this practice must be done regularly throughout the year of course. 😉 During my cleaning day, a new case appears that I never had before and enjoy to share it with you. To find orphan database-users, I use this query: SELECT *FROM sys.database_principals a LEFT OUTER JOIN sys.server_principals b ON a.sid = b.sid WHERE b.sid IS NULL…

Read More
Daniel Westermann

PostgreSQL 13: parallel vacuum for indexes

By | Database Administration & Monitoring | No Comments

Because of its implementation of MVCC PostgreSQL needs a way to cleanup old/dead rows and this is the responsibility of vacuum. Up to PostgreSQL 12 this is done table per table and index per index. There are a lot of parameters to fine tune auto vacuum but none of those allowed vacuum to run in parallel against a relation. The only option you had to allow auto vacuum to do more work in parallel was…

Read More
Daniel Westermann

Deploying your own PostgreSQL image on Nutanix Era – 2 – Deploying a new PostgreSQL VM

By | Database Administration & Monitoring | One Comment

In the last post I described how you can create your own PostgreSQL image in Nutanix Era. In Nutanix wording this is a “Software profile”. This profile can now be used to deploy PostgreSQL VMs with just a few clicks or by using the API. In this post we’ll look at how this can be done and if it is really as easy as Nutanix promises. We’ll be doing it by using the graphical console…

Read More
Mouhamadou Diaw

Dbvisit 9: Adding datafiles and or tempfiles

By | Database Administration & Monitoring, Oracle | No Comments

One question I was asking is if the standby_file_management parameter is relevant in a Dbvisit environment with Oracle Standard Edition. I did some tests and I show here what I did. We suppose that the Dbvisit is already set and that the replication is fine [[email protected] trace]$ /u01/app/dbvisit/standby/dbvctl -d dbstd -i ============================================================= Dbvisit Standby Database Technology (9.0.08_0_g99a272b) (pid 19567) dbvctl started on dbvisit1: Fri Jan 17 16:48:16 2020 ============================================================= Dbvisit Standby log gap report for…

Read More
Daniel Westermann

Deploying your own PostgreSQL image on Nutanix Era

By | Database Administration & Monitoring | No Comments

Some days ago we had a very good training on Nutanix. Nutanix is a Hyper-converged infrastructure and that means that all is software driven and the system can be deployed on many hardware configurations. I will not go into the details of the system itself but rather look at one component/module which is called Era. Era promises to simplify database deployments by providing a clean and simple user interface (and an API) that provides deployment…

Read More
Mouhamadou Diaw

Dbvisit Standby 9 : Do you know the new snapshot feature?

By | Database Administration & Monitoring, Oracle | No Comments

Dbvisit snapshot option is a new feature available starting from version 9.0.06. I have tested this option and in this blog I am describing the tasks I have done. The configuration I am using is following dbvist1 : primary server dbvist 2 : standby server orcl : oracle 19c database We suppose that the dbvisit environment is already set and the replication is going fine. See previous blog for setting up dbvisit standby First there…

Read More
Clemens Bleile

ARRAYSIZE or ROWPREFETCH in sqlplus?

By | Database Administration & Monitoring | No Comments

ARRAYSIZE or ROWPREFETCH in sqlplus? What is the difference between the well known sqlplus-setting arraysize and the new sqlplus-12.2.-feature rowprefetch? In Blog https://blog.dbi-services.com/oracle-fasttrue-in-sqlplus-some-thoughts-about-rowprefetch/ I showed a case, which helps to reduce the logical IOs when using rowprefetch. Here the definition of arraysize and rowprefetch according the documentation: arraysize: SET System Variable Summary: Sets the number of rows, called a batch, that SQL*Plus will fetch from the database at one time. Valid values are 1 to…

Read More