Category: Others

How To backup MySQL DB on Windows severs

Backing up database is essential to eliminate the risk of losing data whenever there is a hardware failure or software issues. In this post, I’ll be showing the possible ways to create backups for MySQL databases. In fact, There are several ways to Backup MySQL databases, you need to evaluate each one and select the Read More …

LastIndexOf in TSQL

I came a cross a case where I need to parse a string and get a everything after specific character. Unfortunately there is no a function that is being shipped out of the box with MS SQL Server that is doing the needed job. So we had to use 3 built-in functions in SQL in order to Read More …

SQL Server Build Versions

I was working on maintaining SQL Server DB backups on a new server of mine, but I faced an error message that telling me my backup file created on database engine 10.50.4042 version while my current database engine version is 10.00.5500. I believe you already faced such an error message. Once I got that error Read More …