Stored Procedure to Delete Duplicate Records in SQL Table
Sometimes during our run as DBAs, we come up across at least one table that is loaded with...
SQL VARCHAR Data Type Do’s and Don’ts for Faster Databases
This post has “strings attached: for a good reason. We are going to explore deep into SQL VARCHAR, the data type that deals with...
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 someone to take over your database. Plus,...
Troubleshooting SQL Server Transactional Replication Issues
SQL Server Transactional Replication is one of the most common Replication techniques used to copy...
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 copy or distribute data across multiple...
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...
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 Servers. The current article will focus...
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...
