Crontab is a job scheduling tool included with the Linux system pack. The first five elements relate to the execution date and time and are
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Store AWS RDS Database in S3 Bucket
A MySQL database backup can be stored in an S3 bucket in a number of different ways. The S3 bucket can be mounted as a
AWS – EC2 Instance – Commands
You will learn the frequently used commands in this article for EC2 instances running the Linux/CentOS operating system. Sl Command Description 1 ls This command
MySQL Generated Column with CASE Expression
The generated column feature, which has been available since MySQL 5.7, enables the generation of some columns’ data based on predefined phrases. This is comparable
When to use Pig Latin and HiveQL?
Pig and Hive are two major components of the Hadoop ecosystem that make it easier to write complicated Java MapReduce processes. However, most Hive developers
UNIQUE KEY in SQL Server
This article’s goal is to add to “SQL Server All in One.” The use of a unique constraint makes sure that no duplicate values are
Big Data & SQL 