Execute Dynamic Query in SQL Server
Dynamic SQL is a statement constructed and executed at runtime, usually containing dynamically...
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 for developers and users. But as remote...
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...
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 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...
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 dates, using built-in time intelligence...
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...
