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...
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...
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...
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...
A Simple Use Case for Indexes on Primary Keys
Introduction Recently we encountered an interesting performance problem on one of our SQL Server databases that process transactions at a...
Connecting a Bastion Server to a PostgreSQL Server via SSH Tunnel
PostgreSQL is a well-known relational database management system that boasts a secure environment...
FLOAT Data Type in SQL Server: A Practical Guide to Prevent Unexpected Mathematical Errors
Have you ever thought that SQL can be wrong in math? It sounds crazy. But if you’ve used the SQL FLOAT data type, you may have come...
Storing Binary Data Types in SQL Server
Introduction Daily work rarely requires storing binary data directly to database columns. However, it is very useful in some cases....
How to Protect MySQL Databases from Ransomware Campaigns
MySQL is known for being easy to use and highly secure. That’s why it is the number one choice...
