Entity Framework – Just a Few Clicks Away
Entity Framework is an open-source object-relational mapping (ORM) framework for .NET applications....
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...
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...
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 existing locally or on the remote...
How to Auto-trigger AWS Lambda Functions
When we think about a cloud solution provider, we often consider the most popular ones, i.e. Amazon...