If you are using SQL Server Availability Group and you have multiple availability groups and instances; if you want to list Availability Group Names, Database Names, …
Read More »What is dead.letter?
When you search for different files while working, you can see the file named dead.letter. Why does dead.letter occur? The cause of dead.letter is to …
Read More »How To Change TimeZone on PostgreSQL
If you notice that there is an error in the PostgreSQL time when you make time-dependent queries in PostgreSQL, you can change it by following …
Read More »How To Change TimeZone on Centos 7
If your Linux server does not match the local time, you may experience problems when making date-based configurations. You can make mistakes due to these …
Read More »How To Create NFS Share and Mount Shared Directory on a Client On Centos
NFS is the abbreviation of the Network File System. NFS is a useful technology for file sharing. It works as a server and client …
Read More »Displaying Execution Plans With sqlplus
We can also display the execution plan with sqlplus. For this we can use the explain plan tool with sqlplus. To use the Explain …
Read More »How To Encrypt SQL Server Stored Procedures, Views and Functions
Stored procedures, functions, and views are objects that each application uses at the database tier. In some cases, it may be necessary to encrypt …
Read More »HAVING Clause in SQL Server and Difference Between WHERE Clause(TSQL)
HAVING Clause is used for filtering like WHERE Clause. The difference is that while WHERE Clause is filtering on ungrouped data, HAVING Clause filters on …
Read More »ORA-01426 numeric overflow Error When Trying to get backup with Expdp
When you try to get a backup with Expdp, if the process ends with error ORA-01426: numeric overflow, there are some alternative solutions. During …
Read More »How To Change Default Paths of the Data and Log Files
I explained in detail how to create a database in the article “How to Create a Database on SQL Server“. If you do not …
Read More »