Considerations for Deploying Azure SQL Database Managed Instances

• 
• 

PrevNext

Microsoft provides a number of different deployment options for its Azure SQL Database offerings. While most of them share the same characteristics, one in particular warrants special attention from the standpoint of its infrastructure dependencies. That exception is Azure SQL Database Managed Instance, which will be the topic...

Continue reading

Oracle Database 19c Installation On Oracle Linux 8 (OL8)

This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 8 (OL8) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux set to permissive. ◉ Download Software Download the Oracle software from OTN or MOS depending...

Continue reading

Oracle Database 19c Installation On Oracle Linux 7 (OL7)

This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux set to permissive. ◉ Download Software Download the Oracle software from OTN or MOS depending...

Continue reading

Oracle Cloud Infrastructure (OCI): Create a Database VM

• 
• 
• 
• 
• 
• 
• 

PrevNext

This article shows how to create a database virtual machine under Oracle Cloud Infrastructure (OCI). The screens change a little with each quarterly release of Oracle Cloud. Even so, the screen shots in this article will give you a good idea of what is involved. ◉ Assumptions This...

Continue reading

Oracle 1Z0-071 Exam: Pave Your Way Towards a Successful Score

• 
• 

PrevNext

IT certifications are considered an excellent source to launch and advance your professional career. If you compare to the past, now professionals have more options in choosing IT certifications available in the IT industry. The Oracle 1Z0-071 is one of the top IT certifications and considers a very...

Continue reading

Blockchain tables in Oracle Database 20c

• 
• 
• 
• 

PrevNext

Blockchain tables are insert-only tables that organize rows into a number of chains and is a new concept starting with Oracle 20c. Each row in a chain, except the first row, is chained to the previous row in the chain by using a cryptographic hash. For each Oracle...

Continue reading

Working with SQL Cursors

• 
• 

PrevNext

In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. This article quickly explores the concept behind and show how to declare cursors, open, retrieve data from them, and then close them. SQL Cursors The data...

Continue reading

Oracle Database 18c Installation On Fedora 31 (F31)

This article describes the installation of Oracle Database 18c 64-bit on Fedora 31 (F31) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux set to permissive. ◉ Download Software Download the Oracle software from OTN or MOS depending on...

Continue reading