Server-side scripting with ASP and SQL databases

Harness the power of your web server! By taking control over the way your web-server responds to requests for pages and files, and integrating a database into this process, a web freelancer like myself can turn your web site into something far more than just a nice-looking design sitting on the page. The possibilities are practically endless, but the more common uses of this type of programming include:

eCommerce

Shopping cart systems and credit-card payment provider integrations, where your entire catalogue is stored in a back-end database and your web site is able to take orders, track your stock levels, process secure online payments and even communicate directly with your suppliers and couriers.

Content Management systems

Control your website's content with zero HTML knowledge, by commissioning a CMS (such as the one custom-built for this very web site) that stores your pages in a database and dynamically generates the pages, menus, URLs and meta-tags, and provides an advanced search functionality right at your user's finger tips.

Sophisticated email/order form processing systems

Enabling your users to get in touch, and ensuring that the information they submit is formatted to allow you maximum efficiency in your response.

Online contact databases with targeted mailshot features

Create elegant HTML newsletters and maintain a database of of customers, with targeted bulk emailing of opt-in members and full monitoring of which customers have received which emails and who has responded.

Site-wide search functionality

...such as that built into this web site.

Managed download services

For when you need to control who is able to download what, how often it can be downloaded etc e.g. sale of electronic documents & music files, and in Document Management Systems.

'Search engine friendly' URLs

ASP.NET has built-in functionality for "URL rewriting", where the publically advertised "friendly" URL doesn't actually exist. Instead, requests for that URL are translated by the web application into a call to the appropriate page-building script. This allows for massive flexibility in your site naming structure and search-engine optimization strategy. This technique is adopted by many major web sites including eBay, Amazon etc, and is quite possibly one of the reasons why you're reading this very page.

http://www.Zend.com
http://www.vbulletin.com
http://webcentre.lycos.co.uk