Difference between Group by and Partition by
In below articles I have used both group by and also partition by
* Difference between rank, dense_rank and row_number function in Oracle * Total Scenario of Callerlog Table...
Read more...
Load Balancing with HAProxy
HAProxy stands for High Availability Proxy, is an open-source TCP/HTTP load balancer. In case you are new to the idea of a load balancer, the work of a load balancer is to distribute incoming requests to an array of upstream servers so as no single upstream server is overworked/overloaded by...
Read more...
MSVCRT hook
An interesting example where it is intercepted, as a test, the function STRLWR. I will take no credit out of the hook, since it is about a simple patch that I googled in like 5 seconds. What I will show is a pair of pictures at the respect. How the executable was compiled, so it will be MSVCRT DLL...
Read more...
How to Handle RGBA Color Format in OpenGL
I did a sample program that shows how you can handle colors in RGBA format with the purpose of using them in an Opengl32 program, by the way, the sample program is itself the Opengl32 program and it'll show the results of managing different colors.
First, you would like to read this manual -...
Read more...
Add Spell Check in PHP With PSpell
Most applications like browsers, text editors, etc. come built in with spelling suggestions, they highlight a possible incorrect English word (any language for that matter) and offers a list of suggestions when clicked or selected. Even, search engines provide spelling suggestions.
Even you...
Read more...
Create A Super Fast Search with Sphinx
Sphinx (acronym for SQL Phrase Index) is a full-text search engine, it runs as a daemon and serves to requests of client applications. Client applications need to access Sphinx daemon via the native SphinxAPI, for which libraries are available in almost all popular languages like PHP, Perl, Ruby,...
Read more...
Difference between Views and Materialized Views
Materialized Views
* Stores results not queries
* Requires Physical memory
* No auto updates
* Execution time is less Views
Views
* Stores queries not data
* No physical memory required
* Auto Updates
Read more...
The Pros and Cons of Marketing
Marketing is something all businesses today swear by creating interest among potential customers for a product or service is important in today’s fast-paced world. There are several marketing mediums available. However, what is important to know is that there are both advantages and disadvantages...
Read more...
How to Stop vBulletin Spam Registration
Captcha, reCaptcha as well as Question and Answer does not stop vBulletin Spam registrations and so I have come up with yet another solution to stop vBulletin Spam for Registration. This works with any kind of site and is based on Cookies for Comments...
Read more...
Dll Wrapper: Making our own psapi.dll with .DEF
*Level: Beginner, Test environment: WinXP SP3*
This tutorial is going to teach you how to make a 'DLL wrapper'. Wrappers are own versions of known DLL's. In this case we're going to make a wrapper of a very known DLL known as PSAPI.DLL. If you don't know it then find the information somewhere...
Read more...
|
 Subscribe via RSS
Get live updates in your web browser window. |
 Follow us on Twitter
Are you on Twitter? Follow us and get updated. |
 Like us on facebook
Share Go4Expert with your buddies on facebook. |
 Find us on Google+
Add Go4Expert to your Circle at Google+. |
 Unsubscribe
If you no longer wish to receive this newsletter or want to edit your preferences you can do it here. | |
