by S-Square | Aug 1, 2019 | Blogs
Introduction: To ensure data protection, high availability and disaster recovery for enterprise data, Oracle introduced Oracle Data Guard. Oracle Active Data Guard is super set of Oracle Data Guard. Oracle Data Guard technology used to create, maintain, manage, and...
by S-Square | Jul 31, 2019 | Blogs
Introduction: Subversion (SVN) is a centralized SCM (Software Configuration Management) implementation. It allows to track changes and concurrent development on the same files. Subversion is centralized version Control system, meaning that it uses central server to...
by S-Square | Jul 31, 2019 | Blogs
1. Backup Plan before license Update Before going ahead for license update activity, we need to take the backup for QlikView Server and documents. Basically, two types of backup will be taken. 1: QlikView server files backup. 2: QlikView Document’s shared files and...
by S-Square | Jul 30, 2019 | Blogs
Rank (): RANK function is used to rank the repeating values in a manner such that similar values are ranked the same. In other words, rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks...
by S-Square | Jul 30, 2019 | Blogs
Redshift query basics: The maximum size for a single Amazon Redshift SQL statement is 16 MB Some Amazon Redshift queries are distributed and executed on the compute nodes, and other queries execute exclusively on the leader node The leader node distributes SQL to the...