Sometimes you need to perform some complex SQL queries depending on some aggregate operations or functions. In most cases, these complex operations could be achieved by series of queries with joins and groupings, but, sometimes it is almost impossible to achieve this by the basic queries and functions natively supported by SQL. In this case, you need to create your SQL custom user-defined aggregate functions. If you want to know more, you can rea...
Application development is not just about writing some code to do what the user wants. It is about writing a clean code which can be read, maintained and extended. Many software companies failed to deliver products which such quality which eventually caused these companies to close. Why? because the development life cycle needs such quality regulations. This article shows an example of how to follow a methodology to achieve this target.
When working with jQuery, you may face some problems related to loading jQuery more than once or even not loadiing it at all. This article provides some valuable info regarding this topic and also provides some code to avoid many jQuery-related problems.
Have you ever had a SQL database .bak file on a server and you needed to restore this .bak file on another SQL server? Some may say that you can just copy the .bak file to the SQL server machine then start restoring the database. Ok, this will work but sometimes due to some restrictions you may not be able to copy the .bak file due to not enough disk size or access issues or other issues. Then, you will not be able to restore the database because...
Have you ever needed to search the whole database code (stored procedures, views, functions & triggers) for a certain word or a pattern? If yes, then you need to read this article to find out how you can achieve this the easiest way.
"Interfaces" is a very important component in .NET which provides the ability to write beautiful code with all means. If you really want to be an outstanding developer you will for sure need to know and understand the main concept behind "Interfaces" and learn to use it wisely. This article provides a glimpse of what you may need to know about "Interfaces".
If you can't explain it simply, you don't understand it well enough
During my career days and day after day I got more confident that it's all about sharing not the title you have. I believe that everyone has something to share whatever small he thinks of it. Sometimes a great idea comes out of just a tiny idea and the same for knowledge. I always try to gain knowledge and learn new skills and I found that the best way to learn is to try to teach what you already know. This makes you think of the best simplest way to explain complex logic which makes you spot some points may be even yourself didn't recognize in the first time.
The greatest thing in the human mind is that it carries out too complicated operations and finally presents it into a simple form, so why do we always try to re-complicate things? This is what encouraged me to start my blog -Development Simply Put (http://developmentsimplyput.blogspot.com)- trying to do my best to simplify main concepts in IT development and share my humble knowledge in this field.