How To Setup FTP On AWS EC2 Instance

How To Setup FTP On AWS EC2 Instance

Most people asking how to setup of FTP on Amazon web service on EC2 instance for their website to upload and download files or data. In today’s world FTP is best way to transfer data between client and server. Hare i am going to explain how to configure FTP server on Amazon Web Service EC2 instance. I’m assuming that you already have an EC2 Ubuntu instance created and instance is up and running....

Read More
How to Check Index Fragmentation in a SQL Server Database

How to Check Index Fragmentation in a SQL Server Database

When on a database's table frequently running INSERT, UPDATE or DELETE queries than we can see indexes on the particular table are fragmented and the SQL query may run slower as they may choose non-optimal execution plan. The below script can be used for checking how much percentages of an indexes gets fragmented on a database. so that we can rebuild or reorganize the indexes....

Read More
How to Reset Root Password On CentOS 7

How to Reset Root Password On CentOS 7

Retrieving your forgotten passwords for most of the websites is easy but Retrieving passwords of system is almost impossible to reset. We must have RHEL/CentOS machine serial terminal access with boot menu options to reset the password. We can’t reset the root password if we’re connected with remote machine....

Read More
Delete Duplicate Records in SQL

Delete Duplicate Records in SQL

There are many way to delete duplicate records/row in SQL. We are going to explain the query to delete the duplicate record in table. Hare we use Common table expression method So in this way we can maintain consistency and accuracy of data in database....

Read More