When you are new to Cassandra many people wonder what is that keyspace. In order to start exploring the Cassandra, we must have a basic …
Read More »MongoDB GridFS explained
Many people are aware of the data type called BLOB in the database system that can store huge amount of data.Similarly in MongoDB we have …
Read More »How To Start and Stop Exadata Cell Services
Cell services automatically start when the cell is started. You can follow the following procedures to start and stop manually. “CELLSRV, MS and RS” services …
Read More »Replica placement strategies in Apache Cassandra
Being a DBA we have many hands-on experience and knowledge about replication. But replication is quite a bit different in case of Cassandra because it …
Read More »Why you need to choose mongodb over other databases?
In the recent times i have come across various perople asking why do we need to adopt MongoDB as a database …
Read More »How To Calcutale Database Transaction Count in SQL Server
Transaction count shows that how heavily the database is used. Some third-party applications can show the transaction count graphs of the databases. But each …
Read More »Exception Handling(TRY-CATCH) in SQL Server(TSQL)
We can use try-catch blocks in TSQL since SQL Server 2005. In the try block; We write the TSQL code that we want to catch …
Read More »How To Reset Rman Configurations
It is possible to reset Rman configurations to default values. You can see “#default” at the end of the unmodified configurations. It is possible …
Read More »How To Create a Server Level Role in SQL Server
Before reading this article, I suggest you read my article “Fixed Server Level Role in SQL Server“. Apart from the default roles on Instance, …
Read More »ORA-39014, ORA-39029, ORA-31671 and ORA-00600 errors in 12c expdp/impdp operations
In the 12c databases, ORA-39014 ORA-39029 ORA-31671 and ORA-00600 errors can be received during expdp or impdp operation. In such a case, existing processes …
Read More »