Choosing Your Cloud Computing Service: IaaS vs PaaS vs SaaS (Pros and Cons)

The cloud native infrastructure has a central role in the current era of application development. With the right design and cloud native security best practices, this technology minimizes the chaos in your environment, allowing the company to streamline its efforts to what matters the most: building quality applications, while also focusing on application security.   … Read more

Host gets stuck at certain percentage while entering maintenance mode in Full Data Migration (VMware, vSAN)

Host gets stuck at certain percentage while entering maintenance mode in Full Data Migration (VMware, vSAN)

Problem Statement:  Host stuck at a 68% (certain percentage) while entering vSAN Maintenance Mode. When you enter a vSAN Maintenance mode with option “Full data migration”, its bound to take long time depending upon the size of the diskgroups. “Full data migration” mode will ensure evacuation of all components to other hosts in the cluster. … Read more

what is the difference between sub-query and co-related sub-query?

Sub-query The inner query execute first, the outer query deprnds on inner query output. Correlated sub-query The outer query execute first, the inner query deprnds on outer query result. A correlated sub-query is where the sub-query part makes reference to values from the outer query. —————————————————————————————————————————— SELECT emp1.emp_id, emp1.last_name, emp1.job_id, emp1.department_id from employee emp1 WHERE … Read more

How to Remove Duplicate Rows from a Table

Use rowid pseudo column. All you have to do is to keep the latest data (i.e. highest ROWID) and remove other duplicated rows. SELECT * FROM table1 a WHERE rowid < (SELECT max(rowid) FROM table1 b WHERE a.column1 = b.column1 AND etc…); OR create table testtt (num number); insert into testtt values(111); insert into testtt … Read more