How To Archives

How to Deploy Django Project on AWS EC2 | A Complete Guide

September 22, 2023 / BY Nolan Granger

Generally, Django includes a built-in development server for local project testing. However, if you want to m ake your application accessible globally, you will need a hosting solution from a …

How to Increase Root Volume in AWS EC2 (Steps Guide)

September 22, 2023 / BY Nolan Granger

Generally, each EC2 instance you launch using an AMI has a root volume of 30 GiB during launch. However, you can increase this general-purpose SSD (gp2) space afterward by expanding …

How to Track Database Changes in SQL Server (Proper Guideline)

September 21, 2023 / BY Nolan Granger

You usually get two built-in features to track database changes in your SQL Server. One is the Change Tracing feature, while the other is the Change Data Capture. Once you …

How to Send Email From Oracle Database 12C | Easy Guideline

September 11, 2023 / BY Nolan Granger

Using the UTL_MAIL package can be an ideal choice if you want to send emails from Oracle Database 12c. This package provides an interface to send email messages directly from …

How to Access RDS Database From Local Machine (Easy and Straightforward)

September 11, 2023 / BY Nolan Granger

The first step for accessing the RDS database from your local machine is to launch and configure the EC2 instance. Once you do that, you can configure the security groups …

DB2 SQL Error SQLCODE=-204 SQLSTATE=42704 (How to Fix)

September 11, 2023 / BY Nolan Granger

The DB2 SQL error SQLCODE=-204 SQLSTATE=42704 points to an issue where a queried object is undefined in the DB2 subsystem. This error, applicable to different object types, signifies an undefined …

How to Check Timezone in Oracle Database 19c (Simple Methods)

September 11, 2023 / BY Nolan Granger

Understanding time zones can be helpful for maintaining data integrity and synchronization when data remains scattered across different geographic locations. Oracle Database 19c offers a simple query-based process to manage …

How to Add IAM Role to EC2 Instance (4 Methods)

September 8, 2023 / BY Nolan Granger

You can add an IAM role to an EC2 instance through the EC2 console, AWS CLI, or other options like Terraform and Amazon CloudFormation. Whether you like working with an …

How to Change Availability Zone of EC2 Instance (2 Methods)

September 8, 2023 / BY Nolan Granger

AWS does not provide a direct option to move an existing instance to a new Availability Zone. However, there’s a workaround if you want to change the Availability Zone of …

DB2 SQL Error SQLCODE=-904 (How to Fix)

September 7, 2023 / BY Nolan Granger

The DB2 SQL error SQLCODE = -904 indicates the unavailability of a DB2 resource, in most cases, a tablespace. However, other inaccessible resources like packages, internal workspaces, or buffer pools …

How to Store PII Data in a Database | A Complete Guide

September 7, 2023 / BY Nolan Granger

The best practices to store PII data in a database include identifying which data classifies as PII data and which doesn’t. Once identified, the steps are to create a solid …

DB2 SQL Error SQLCODE=-805 | Fixes You Need to Know

September 6, 2023 / BY Nolan Granger

If you are getting the SQLCODE -805 in DB2, chances are the query you are trying to run is referencing a missing package in the DB. The creation of such …