seo web site optimization

http://www.websiteoptimization.com/

CSS font generator

web 2.0 - font generation tool

CSS generation tools

List-o-matic

another list generation tool

sleeping less

I'd like to try this one day, but I don't think I have a schedule with the required flexibility.

sleeping less

book about Software Engineering for Internet Applications

Software Engineering for Internet Applications
link to book

photo recognition search tool

riya.com

PHP Function Index for Mac OS X

http://www.artissoftware.com/phpfi/

Amazon Web Services

Amazon Web Services




Amazon S3 - Simple Storage Service

Pricing

* Pay only for what you use. There is no minimum fee, and no start-up cost.
* $0.15 per GB-Month of storage used.
* $0.20 per GB of data transferred.

Useful SQL Server DBCC Commands

http://www.sql-server-performance.com/dbcc_commands.asp
good dba tips on how to optimize queries


to clean the cache in sql query analyzer:
CHECKPOINT
DBCC DROPCLEANBUFFERS

make search engines better!

If you have a computer that could surf the web when you're not using it (like at night or when you're at work), please visit http://www.majestic12.co.uk/ and install the search engine tool. The software is building a MASSIVE search engine based on thousands of users contributing their computing power.

basic site design with php html css

http://www.latenightrabbit.com/simple-organism/index.php
a basic php , html , css web page ...good bare bones

how to do rounded corners

http://pro.html.it/niftycube/
rounded corners on a web page with css and html

XP on Mac

Install Windows XP on a Mac Intel machine...
http://wiki.onmac.net/index.php/HOWTO

photoshop tutorials

http://www.greycobra.com/tutorials/photoshop/

Round-up of 30 AJAX Tutorials

Round-up of 30 AJAX Tutorials

Google Maps API tutorial

http://www.econym.demon.co.uk/googlemaps/index.htm

locate cheap gas stations

find cheap gass

car insurance buying guide

http://moneycentral.msn.com/content/Insurance/Insureyourcar/P145324.asp

web hosting company

http://www.micfo.com/cheap-affordable-web-site-hosting.html

10% off - Coupon ID: 34338

seo items

Blog about SEO activities

how to get free links to your web site

Web 2.0 api directory

http://www.programmableweb.com/apis

php script code repository

http://www.sitescripts.com/PHP/

MySQL backup script

http://sourceforge.net/projects/automysqlbackup/
open source script to do a mysql backup dump

here is an explanation / tutorial on how to use the sql backup script:
http://www.debianhelp.co.uk/mysqlscript.htm

some nice ajax tutorials

30 ajax tutorials

Web 2.0 style / design

http://www.vipedio.com/roman/blog/20culture_full.html

seo research tool

http://www.wmtoolkit.net/seo-tools/domain-info/
find out your site's pr
count backlink information
count indexed pages

mac iphoto - setting the library location

from http://www.macosxhints.com/article.php?story=20020107231049966

iPhoto has a default that can be used to change the location of the photo library in a fashion similar to the way iTunes can change the location of the music library.

For iPhoto, this is of critical importance in that any image added to iPhoto is copied into the library (unlike iTunes, which simply stores a pointer to the original file). Considering what can be done with an image in the library, this makes a lot of sense -- it will make more sense once Apple supports multiple libraries in a more traditional multi-document application approach.

To change the default file store location, go to terminal and type:

  defaults write com.apple.iPhoto RootDirectory /path/to/desired/location

To remove the change default:

  defaults remove com.apple.iPhoto RootDirectory

ajax news and information

http://ajaxian.com/

DHTML / AJAX script samples

DHTML / AJAX script samples
http://www.dhtmlgoodies.com/

web typography

http://webtypography.net/toc/

lists of lists

a neat little site that lists Lists

free icons, and neat javascript trick

A nice list of free icons.

It also has some javascript that provides a really nice fade interface that shows icons on the same screen.

links of Social Linking sites

Web Design from Scratch .com

I may have already listed this site, but I wanted to be sure that it's in here. This is a good site on web design. It has an over view of design, colors, typography, and a bunch of other things.

http://www.webdesignfromscratch.com/

Photoshop tutorials

http://www.good-tutorials.com/

some curious urls

some curious urls
http://www.fourio.com/web20map/todo.html

SQL web site

http://www.sqlteam.com/default.asp

T-SQL Group by Week query

SQL Server


Group by Week

SELECT Week = DateAdd(day, -1 * datepart(dw, ReviewDate), ReviewDate ),
Avg_Score = Avg(convert(float, ReviewScore))
FROM Articles
GROUP BY DateAdd(day, -1 * datepart(dw, ReviewDate), ReviewDate )


to group by week and have the week start on Saturday:
DateAdd(day, ( -1 * datepart(dw, @startDate)) % 7 , @startDate )

Cast () and Convert () reference

SQL Server

Cast() and Convert() reference
http://doc.ddart.net/mssql/sql70/ca-co_1.htm

useful sql server t-sql date scripts

got code here

First Day of Month
select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)

Monday of the Current Week
select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)

First Day of the Year
select DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)

First Day of the Quarter
select DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)

Last Day of Prior Month
select dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate() ), 0))

Last Day of Prior Year
select dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate() ), 0))

Last Day of Current Month
select dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1, 0))

Last Day of Current Year
select dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate() )+1, 0))

First Monday of the Month
select DATEADD(wk, DATEDIFF(wk,0,
dateadd(dd,6-datepart(day,getdate()),getdate())
), 0)

Last Day of Prior Month
select dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate() ), 0))

SQL Server blog

SQL Server Blog

T-SQL - technique for get date ranges without a loop, simple select process

PHP script directory

http://www.comscripts.com/scripts-php-mysql.html
directory of php scripts
(note: the site is in French)

list of mac software

http://www.pure-mac.com/

php architecture e-zine

http://www.phparch.com/

easy url rewriting techniques

http://www.sitepoint.com/article/guide-url-rewriting

PHP code for SEO urls

http://www.zend.com/zend/spotlight/searchengine.php

watch your credit report for cheap price

http://www.truecredit.com/services/creditMonitor/monitoringSample.jsp
credit watch / monitoring service

programmmer e-zine

http://www.developer.com/
has articles about: database, SOA, architecture, programming, and more.

self-publishing service

http://www.lulu.com/

from the web site:

Founded in 2002, Lulu is the web's premier independent publishing marketplace for digital do-it-yourselfers. It's the only place on the web where you can publish, sell and buy any and all things digital — books, music, comics, photographs, movies and well, you get the idea. We simply provide the tools that leave control of content in the hands of the people who created the content. You see, Lulu is a technology company, not a publisher. So you can use Lulu to publish and sell any kind of digital content, and no one here is going to ask you to change anything. Ever. Your vision is entirely YOURS.

There is no set-up fee and no minimum order to publish and sell on Lulu. We manage the online business, including printing, delivery and customer service. You set your own royalty for each piece of content, and at the end of each quarter, we'll mail you a check for the royalties your content generates. Lulu makes a small percentage from each transaction, which means that we only make money if you succeed in selling your work.

Lulu was founded by Bob Young, who was also the co-founder of Red Hat, the world's leading open source company. We mention this only because, like Lulu, open source software is based on putting users in control of technology. In much the same way, Lulu believes in putting authors and independent publishers in control of their digital content, from content creation to pricing to royalties. Lulu simply brings creative content to the world and gives our talented publishers and web visitors the venue to buy and sell independent works. Publishing through Lulu leaves control of content in the hands of the people who created it. Pretty revolutionary, really.

What's In a Name?
For goodness sake, what is a lulu? Well it's not your grandmother's kitty, that's for sure. Ever hear the phrase "Boy, that's a real lulu"? Well, even if you haven't, we think of the word lulu as an old-fashioned term for a remarkable person, object or idea. And quite frankly, that's exactly what Lulu, the company, is. Think of us as an open marketplace for digital content. The web's version of a fresh air market. An on-demand publishing tool for books, e-books, music, images, movies and calendars. A remarkable idea, person or place. Most importantly, Lulu is you.

house buying steps and tips

steps to plan for buying a house

free credit report

At last, everyone in the entire United States -- territories, possessions and all -- can click or call for three free credit reports a year at Annualcreditreport.com.

[note: some fake web sites try to steal your information. be sure that you're submitting your request to the REAL web site, and not a scammer site]

MSN article: getting good credit

tips for getting good credit

MSN car insurance article

Article about car insurance research

some interesting web sites...

MIT physics online
http://phischkneghtx.blogspot.com/2006/02/wikipedia-doesnt-know-what-roof-is.html
offers physics courses via online video

Web 2.0 Directory : Top Web 2.0 Sites ( web2.0 )
http://www.econsultant.com/web2/index.html

37 Signals secret to success ($19 pdf file)
https://gettingreal.37signals.com/
instructional business book on web2.0 methods and processes

PHP security issues - tips and tricks

http://www.sitepoint.com/article/php-security-blunders