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...
Entity Framework – Just a Few Clicks Away
Entity Framework is an open-source object-relational mapping (ORM) framework for .NET applications. It let the developers work with data on...
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,...
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 for many organizations, including the...
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...
Learn to Use Time Intelligence in Power BI
Time intelligence is a smart way of analyzing time period-based data, such as sales according to...
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 values, dates, etc. However, storing and...
Introduction to Synonyms in SQL Server
A synonyms in SQL Server are database objects that give an alternative name to the database objects...
