First, we connect to the node where the database is located with ssh. After loading the database’s profile, we connect to RMAN with the …
Read More »Sp(Stored Procedure) On SQL Server
You can keep the database-level code that you need to use every time in the application through “stored procedures” in the database. You can …
Read More »How To List Active Queries On PostgreSQL
In this article I will explain you to list active queries in postgresql. First you must connect to postgresql. You may want to read …
Read More »SQL Server Account Lockout Policy
Account Lockout Policy is a security mechanism used by SQL Server. For example, consider someone who is trying to log in with a user …
Read More »How To Check If There Is a Dictionary-Managed Tablespace On Oracle Database(Extent Management Control)
Extent Management Control can be LOCAL or Dictionary Based. If local, the information in the bitmaps in the datafile is used. If Dictionary Based, …
Read More »SQL Server Maintenance
I find OLA HALLENGREN’s maintenance script very successful and practical. In this article I will tell you where to download and install the script that …
Read More »How To Move The Temp Tablespace to Another Diskgroup On Oracle
In some cases, you may need to move the TEMP tablespace to another diskgroup if there is no space left in the ASM or because …
Read More »How To Create a Restore Point On Oracle
With the flashback database we can use the restore point to return the database to a time in the past. For more detailed information …
Read More »sp_configure(Server-Level Configurations in SQL Server)
You can configure SQL Server with sp_configure at instance level. In this article I want to explain most important configurations in sp_configure. First we …
Read More »How to List PostgreSQL Users and Permission
In this article I will share a few scripts in postgres databases that I think will help you manage your users. The easiest way to …
Read More »