SQLServerPedia is a wiki that is concentrated on SQL Server that is edited & administered by SQL Server professionals.
There is a serious amount of content that is well-categorized & easy to reach. Some of the categories are:
- Architecture & configuration
- Monitoring SQL Servers
- Performance tuning & more..
There are also various podcasts which are great for watching & learning the details from professionals.
And, besides the editors, there are bloggers & other contributors who help the content get wider.
For any developer who is into SQL Server, SQLServerPedia is a must-bookmark.
IP Location Tools is a free web service that helps you detect the country/city of an IP number.
It can be used in 2 ways:
- with API (no installs required)
- by downloading the geolocation database
Although downloading the SQL database & running it on our own database servers is much more flexible, keep in mind that there are 1.4 million records in it.
The geolocation database is updated regularly (once a month)
IP Location Tools offers another nice service: fraud detection. Again with an API request, with the zip code you submit, system compares the location of the IP and the area where zipcode belongs to. Can be very helpful, specially for e-commerce websites.
This is an Ajax star rating script that uses cookies, SQL & PHP.
In general star rating scripts have 5 stars & users need to choose one of them. This one has again 5 stars but the selection is percentage based which enables users to select from 1% to 100%.
The website presenting the script, Nomadic Functions, has also some other free scipts that you may want to check, like:
- Color conversion library
- DHTML color picker
- Drag & drop & more..
Requirements: No Requirements
Compatibility: All Major Browsers
WIPmania provides IP to country database and API which is free to use for both personal & commercial projects.
The database comes in SQL, CIDR & text formats & updated in every 2 months.
If you don’t want to use the database and use the API, a simple query like:
http://api.wipmania.com/123.45.67.89?google.com
returns you a 2 digit country code (google.com is the URL where the query is made from). API usage is free until 10,000 queries/day.
Scrawlr is a free software for scanning SQL injection vulnerabilities on your web applications.
It is developed by HP Web Security Research Group in coordination with Microsoft Security Response Center.
Scrawlr crawls a website while simultaneously analyzing the parameters of each individual web page for SQL Injection vulnerabilities.
After the scanning process, if it can find, it even shows your database table names as a proof of the possible SQL injection vulnerabilities.
Most of the membership forms include a country list.
Urbano Alvarez is presenting ready to use country list data in several languages.
The lists are in the HTML format as:
<select id="countrySelect" >
<option value="AF">Afghanistan</option>
<option value="AL">Albania</option>
<option value="DZ">Algeria</option>
<option value="AS">American Samoa</option>
</select>
For country lists in SQL format, you can also use the files at:
htmlSQL is a PHP class for querying HTML using a SQL-like query.
It saves you from writing complex regular expressions to extract values.
htmlSQL example:
This query returns an array with all links that contain the attribute class="list".
Isn’t it great?
How to use?
You simply insert the PHP files from th download package and that’s all.
