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...
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 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...
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 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...
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 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...
