You can find detailed information about Contained Database in the article “What is Contained Database” We can create a new Contained Database and create …
Read More »ORA-01722 error received during upgrade process
When the catupgrd.sql is run during the manual upgrade process, it ends with “ORA-01722: invalid number” error due to the Database Vault configuration in …
Read More »Difference Between Login and User in SQL Server
I would like to write this article because it is a topic that some friends who are interested in SQL Server are usually curious …
Read More »Database-Based Memory Usage Rates in SQL Server
In some cases, we may need to determine the memory rates used by databases. Because some databases using extra memory may be degrading the performance …
Read More »How To Configure postgresql.conf Using pgtune
PostgreSQL is a database management system that is bare when it is first installed. Therefore, you should make some configurations according to your system resorce. To …
Read More »How To Grant Permission On Foreign Data Wrapper
We can read data from Oracle or MSSQL with the help of PostgreSQL Foreign Data Wrapper. Please read the following articles for installation and detailed …
Read More »How To Install Docker On Centos
Docker, which is becoming increasingly popular, is in the logic of virtualization. But unlike conventional known virtualization tools(Virtualbox, Vmvare ,kvm vb.. ), it does not …
Read More »OUTPUT Clause in SQL Server(TSQL)
OUTPUT Clause transfers the records affected by the currently executed INSERT, UPDATE, or DELETE operations to the specified table. So we can easily capture …
Read More »enq: TX – row lock contention wait event
enq: TX – row lock contention can be regarded as a row lock conflict wait event in operations. This event indicates that a session is …
Read More »How To Create SQL User Without Login
We can create a user without login since SQL Server 2005 version. This feature was introduced instead of Application Role. You may want to read …
Read More »