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 ...
List of FREE services & tools Startups should be using
I have curated a list of free tools, services, and apps that startups could and in fact should use to grow at the initial stage. Free doesn't mean they lack quality, instead, these free tools are from top-notch companies like RedHat, Google, Asana, a ...
Deploy your first ASP.Net MVC App to AppHarbor
Our focus is to deploy our ASP.Net MVC app built using new Visual Studio 2015 MVC template to AppHarbor via GitHub.
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. ...
Converting Oracle DATE types and PHP/Unix Timestamps
If you need to convert between Oracle date and PHP/Unix timestamp then you might need to implement two functions in Oracle. The following two Oracle functions implement this for DATE types. To convert a UNIX timestamp into an Oracle DATE type: CREA ...
Working with Dates and Times in Oracle and PHP
Both PHP and Oracle provide functionality manipulating dates and times. Which to use and when? If you're new to PHP or Oracle, working out how to handle dates efficiently can be tricky. You may have strategies, which you've applied successfully on o ...
Change password in Oracle SQL Developer
To change password in Oracle SQL Developer you can just right click on connection and click the Reset Password option. Alternatively, you can run the following query to update your password: alter user <username> identified by <newpassword& ...