Recent Posts

Delete Duplicate Records in SQL

There are many ways to delete duplicate records/row in SQL. We are going to explain the query to...

How To Setup FTP On AWS EC2 Instance

Most people asking how to the setup of FTP on Amazon web service on EC2 instance for their...

How To Enable Google Safesearch On PfSense Firewall

pfSense is an open source firewall computer software distribution based on FreeBSD. It is offering features often only found in...

How to Reset Root Password On CentOS 7

Retrieving your forgotten passwords for most of the websites is easy but Retrieving passwords of the system is...

How to Check Index Fragmentation in a SQL Server Database

If we run INSERT, UPDATE or DELETE queries frequently than we can see indexes on the particular table...