Database Operations

Home » Database Operations
Image
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 …

Read More
Image
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 …

Read More
Image
Azure Cosmos DB vs Azure SQL Database | Comparison Between them

September 7, 2023 / BY Nolan Granger

Azure Cosmos DB has the upper hand over Azure SQL Database with its low latency, high throughput, high availability, and multi-model support. It provides the best results for applications where …

Read More
Image
Creating a GUI for SQL Database | Everything You Need to Know

August 19, 2023 / BY Nolan Granger

Creating a GUI for your SQL database can be intricate if you go the coding route. Building a GUI app from the ground up isn’t easy unless you’re familiar with …

Read More
Image
How to Create a Database in Oracle [Step-by-Step Guide]

August 19, 2023 / BY Nolan Granger

Creating a database in Oracle includes several steps. Oracle software installation and establishing a Database Administration Authentication Method are the first steps. The creation process is then started, options for …

Read More
Image
How to Check the Oracle Database Version? 3 Methods to Do It

August 17, 2023 / BY Nolan Granger

Oracle Database is a widely-used relational database management system. Understanding the database version is crucial for users and administrators, as it helps understand functionality, assess upgrades, and ensure compatibility. This …

Read More
Image
What is Database Mirroring in SQL Server? Everything You Need to Know

August 17, 2023 / BY Nolan Granger

Two SQL Server instances may be running on the same server or on different ones in SQL Server database mirroring, a disaster recovery and high availability solution. One SQL Server …

Read More
Image
How to Check Database Encryption in SQL Server? Step-by-Step Guide

August 17, 2023 / BY Nolan Granger

Database encryption in SQL Server refers to encrypting data stored in a SQL Server database to protect it from unauthorized access. Encryption gives an extra layer of assurance by changing …

Read More
Image
DB2 SQL Error SQLCODE 803 SQLSTATE 23505

August 17, 2023 / BY Nolan Granger

DB2 SQL Error SQLCODE 803 SQLSTATE 23505 means that an Insert or Update operation is violating a uniqueness constraint that is already in place. It occurs either after performing Load …

Read More
Image
How To Setup An Amazon EKS Demo With Terraform

August 17, 2023 / BY Nolan Granger

Since EKS is pretty new, there aren’t a lot of howtos on it yet. I wanted to follow along with Amazon’s Getting started with EKS & Kubernetes Guide. However, I didn’t …

Read More
Image
5 Great Things About Markus Winand’s Book: SQL Performance Explained

August 16, 2023 / BY Nolan Granger

In the realm of database management and development, optimizing SQL performance is a perennial challenge. If you’re looking to up your SQL performance tuning game, Markus Winand’s book “SQL Performance …

Read More
Image
How to Troubleshoot MySQL? 7 Best Ways

August 16, 2023 / BY Nolan Granger

MySQL databases are great workhorses of the internet. They back tons of modern websites, from blogs and checkout carts to huge sites like Facebook. But these technologies don’t run themselves. When you’re …

Read More
1 2