PHP Development with VS Code and Docker Dev Containers
Nowadays it is a must-have skill to use docker for your development. To start the development with docker here are some prerequisites: If you're on Windows you have WSL installed on your system. It will also be required for Docker. You have D ...
Why database should be taught before programming in universities?
Learn Database before Coding 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 fi ...
Laravel: Specified key was too long error on migration
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. SQLSTATE: Syntax error or access violation: 1071 Spe ...
How to Find a Stored Procedure in all the Databases?
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 remember in which database it was. All ...
Searching Lowercase data in MS SQL Server
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 a case-sensitive search. ...
How to change expired password in Oracle?
In Oracle when the password is expired you will get the following error: ORA-28001: the password has expired This is because the password has reached 180 Default limit for a Password lifetime. Solutions: 1. Connect to the database using sys user ...
INSERT new rows from a result of SELECT query
There were numerous times when I needed to insert records in the table from a result of another SELECT query, or copy data from one table to another. And every time I forgot the syntax of insert...select query. So I thought I should write it somewher ...
MySQL Installation and Configuration
A step by step guide on how to install and configure MySQL on the Windows Operating System.
MySQL Query Cache
MySQL query cache is good to cache select queries and their results and improve some performance of your database applications. So, enable query cache in just one step.
Multiple MySQL on single host
Sometimes we need to run multiple MySQL servers on single machine. That is mostly required in testing environments to test different aspects with different configurations. In this way one can test server without affecting others. So, if you want to r ...
Breaking problem into code
Improve the performance of your application by implementing correct logic for a particular problem.
Database indexes and locks
It is important to create good indexes so that your queries do not unnecessarily need to scan many rows, that can result in lock on those rows and due to which deadlocks can occur, performance can be degraded, or anything bad can happen.
Many-to-many relationship
When designing an application or database, also consider other scenarios and pros and cons of the approach being adopted, not only one scenario. In other words if one approach is solving your problem then also consider what other problems we can face due to it, and prepare for those as well.
Referential Integrity
Always use referential integrity constraints. There is no reason for not using it.