Dear Readers, In this article, we will see the following Connect to Amazon EC2 Instance Using Putty. Steps to Follow : Logging to AWS Account Launch Linux Server Download putty and puttygen tools Convert pem file to ppk file by using puttygen Connect to Linux… Read More
Dear Readers, In this article, we will see the following Connect to Amazon EC2 Instance Using Putty. What is AWS CLI? The AWS CLI is a unified tool to manage your AWS services from a terminal session on your own client. With just one tool… Read More
Dear Readers, In this article, we will see the following Realtime Usecase. Realtime Usecase : My Client wants to launch their Websites publicly along with its Database Servers at the back end. Establish network connectivity between Web Servers & Database Servers. Note: No need of… Read More
Dear Readers, In this article, we will see the following Realtime Usecase. Realtime Usecase : My Client wants to launch their Websites publicly along with its Database Servers at the back end. Establish network connectivity between Web Servers & Database Servers. Note: No need of… Read More
Hi Dears, In this article, we will see Register Free New Domain from Freenom Website. Steps to Follow: Logging to Freenom Account Register a new domain Verify your Domain As first, we need to go inside the freenom website by using below link. https://www.freenom.com/ 1.… Read More
Dear Readers, In this article, we will see the Prevent Deletion of Amazon S3 Bucket. Realtime Usecase: My Client need Common File Repository, everyone can access that File Repository. But no one should delete that file repositoy,even storage Admins also. Hint: Use Inline policy. Steps… Read More
Hi Dears, In this article, we will see Create IIS Web Server On Windows EC2 Instance By Using Bootstrap Script. Steps to Follow: Logging to AWS Account Create Web Server By Using Bootstrap Commands Verify content of Web Server in Browser 1. Logging to AWS… Read More
Hi Dears, In this article,we will see Create Web Server On Linux EC2 Instance By Using Bootstrap Script. Steps to Follow: Logging to AWS Account Create Web Server By Using Bootstrap Commands Go inside the Web Server through Putty & Verify Bootstrap Commands Verify content… Read More
ORACLE:PL/SQL script to rebuild Table(s) and it’s corresponding indexes. Note : Please implement in lower environments before proceeding to Production. Pre requisites : Please download and check below file for pre-requisites. Table creation scripts The below script will be used for 1.Rebuild table(s) 2.Rebuild… Read More
Cloning a Standalone database using RMAN Backup pieces I am making this article to create copy of current PROD database in another server using RMAN backup pieces for testing and development purposes. i have used a simple method to perform clone database. Server details :… Read More
Hi Dears, In this article,we will see Create Web Server On IIS Windows EC2 Instance. Steps to Follow : Logging to AWS Account. Launch Windows Server. Connect to Windows Server through Remote Desktop Connection. Configure IIS Web Server through Server Manager. Take Public DNS (IPv4)… Read More
Dear Readers, In this article, we will discuss Roles (L1,L2,L3) in SQL Server DBA. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a SQL Server Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/roles L1 Roles: ➼Check to… Read More
Dear Readers, In this article, we will discuss Tools for Administering the SQL Server. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a SQL Server Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/sqlserver SQL Server Supported Platforms… Read More
Dear Readers, In this article, we will see the Level of work. L1 Level Jobs Installation Postgres software as per standard document. Space monitoring for Table space, File system on Postgres db system etc. Logs monitoring for Backup, Index rebuilding and other maintenance jobs. Checking… Read More
Dear Readers, In this article, we will discuss Tools for Administering the Cassandra. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/cassandra Cassandra Flavors : Open source Apache… Read More
Shell script to rebuild indexes for index fragmentation Dear Readers, In this article , we wrote a automation job for rebuild indexes for index fragmentation. Note : 1) Please test the Shell script in Non-Prod before implementing it in Production. 2) Make sure you implement… Read More
Dear Readers, In this article, we will discuss Tools for Administering the mangoDB. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/mongodb mongoDB Flavors: mongoDB community version mongoDB… Read More
QUERY LOGGING Dear Readers, In this article, we will discuss QUERY LOGGING What is query logging in teradata database and how it is implemented? Database Query Logging (DBQL) is a feature in Teradata that logs data in the predefined tables created under … Read More
DIFFERENT SPACE ERRORS Dear Readers, In this article, we will discuss DIFFERENT SPACE ERRORS There are various Errorcodes that can be returned due to insufficient space. Some of them are 2507 2646 2644 Every errorcode has a different meaning and so is their cause and… Read More
Dear Readers, In this article, we will discuss Tools for Administering the MySQL Database Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/mysql MySQL Flavours Oracle Mysql MariaDB… Read More
