Categorie: tips+tricks

Particletree » Ranked Searches with SQL

A handy trick to add some sort of ranking to SQL search results:

Creating some sort of search functionality is something we all have to do at one point or another. For the good cases, we have fulltext search or an external program available to us. But sometimes, getting down and dirty with plain SQL is the only option.

SELECT
SUM(((LENGTH(Body) - LENGTH(REPLACE(Body, 'term', '')))/4))
AS Occurrences

Particletree: Ranked Searches with SQL

10 SEO tips for your ASP.NET website – The Code Project – ASP.NET

10 Tips on SEO for your ASP.NET website. I´m sorry, that some of the screenshots contain german language, but I hope you´ll get my point despite that 🙂

The Code Project – ASP.NET: 10 SEO tips for your ASP.NET website

Helping your client maintain markup quality | 456 Berea Street

One thing that is particularly frustrating with caring about Web standards and accessibility is what often happens after your work is done and a site is handed over to the client.
I’m sure most of you have been there. Despite your hard work to educate the client’s editor(s), regardless of the style guide you wrote, and no matter how much time you spent patching the CMS they use, there will be problems.

456 Berea Street: Helping your client maintain markup quality