10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL
Do you know how powerful a tool like dynamic SQL can be? Use it the wrong way, and you can allow...
Troubleshooting SQL Server Transactional Replication Issues
SQL Server Transactional Replication is one of the most common Replication techniques used to copy or distribute data across multiple...
Query JSON Data with SQL/JSON Functions & Autonomous Database
In the previous article, we worked on the Twitter Activity dataset in JSON format with the SQL Developer Web tool in Autonomous Database....
SQL Server Transactional Replication Configuration
Transactional Replication in SQL Server is one of the most commonly used Replication techniques to...
What is a Materialized View and Why Should you Use It?
As data volumes continue to increase, more developers look towards materialized views to process queries. This approach has a lot of...
Create an Upload & Download Application with Oracle Application Express (APEX) and Autonomous Database
Oracle APEX (Oracle Application Express) is a web-based software development system that runs on an Oracle Database. It comes as standard...
Configure SQL Server Always ON Availability Groups between Two Synchronous Replicas. Part 2
We already covered some theory about configuring Always ON Availability Groups for Linux-based SQL...
Understanding Always ON Availability Group between Linux-Based SQL Server Instances. Part 1
SQL Server Always ON Availability Group is a solution meant to achieve high availability and disaster recovery for SQL Server databases. We...
How to Write Complex Queries in SQL
Typical queries in the SELECT * FROM table format are sometimes not enough. When the data for a query is not in one table, but in several,...
How to Install SQL Server Tools on Ubuntu 18.04 Linux System – Step by Step
In the previous articles, we covered sequential steps necessary to build a virtual machine, install...