Category - Database

access_timeMonday, 7 May, 2018

We can write a single query to fetch all the tables in a Database which don't have the identity column.

access_timeFriday, 4 May, 2018

CREATE KEYSPACE <identifier> WITH <properties> ;

access_timeSunday, 29 April, 2018
NoSQL databases and management systems are relation-less (or schema-less). They are not based on a single model (e.g. relational model of RDBMSs) and each 
the database, depending on their target-functionality, adopt a different one.

access_timeWednesday, 25 April, 2018

In this article, we will learn how to Upload/Import/Insert data on Cassandra Database through "Copy" command.

access_timeSunday, 22 April, 2018

Transactional database backup is very important because through the transactional Database backup we will minimize the data loss probability because of the ideal condition transactional database backup schedule on every 10-15 min. That’s why transactional log backup must important in any disaster recovery condition to recover the data.

access_timeSunday, 22 April, 2018

We will schedule differential database backup when the database size is too large then our backup strategy should be to take the full backup on a span of time periods like 1 week or 2 weeks as per your requirement and between those two full backups, we will schedule the differential backup every day.

access_timeFriday, 20 April, 2018

As we all know the future is data and the Database is the heart of any application & no one is afforded to any type of data loss. That's why the DB backup is very important part of any live application as well as every DBA or Database Developer Jobs.