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...
SQL Data Types: 5 Worst Choices You Need to Stop Today
Do your choices of SQL server data types and their sizes matter? The answer lies in the result you got. Did your database balloon in a...
Troubleshooting Issues when Working with Date and Time in SQL Server
The Microsoft SQL Server database stores the date and time information in a variety of formats. The most common of them are DateTime,...
Converting DateTime to YYYY-MM-DD Format in SQL Server
An SQL Server database can store a variety of data types, such as numbers, text strings, Boolean...
