Nowadays it is a must-have skill to use docker for your development. To start the development with docker here are some prerequisites: Now let’s start a sample PHP project to develop with docker. sudo chmod a+x “$(pwd)” && sudo rm…
Often students from the initial semester ask me how do we store our data in our programming projects? When students join university to learn about computer science and technology they are usually taught programming first in courses like introduction to…
When you install a new Laravel project with ‘laravel new’ and run the migration that comes with it you might get the following error: #php artisan migrate Migration table created successfully. [Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified…
When working with MS SQL Server sometimes you need to find a stored procedure in the databases and all that you know is the name of the stored procedure that your teammate told you that he had used but couldn’t…
A few days back I came across a requirement to fetch the records from the table having all lowercase letters. This was an interesting scenario. The SQL Server database by default is set for case-insensitive. But, I need to do…