Tinychat.com is a free online chat room that is very easy to setup and requires no registration.
Just name your chat room and then pass the generated url to friends to begin chatting – it is that easy!
Features include:
I can see this being very useful.
It’s a code you enter into a game, or more recently, a website to get an easter egg or extra functionality.
Read more at: http://en.wikipedia.org/wiki/Konami_code
List of Konami websites:
http://konamicodesites.com/
List of Konami games:
http://en.wikipedia.org/wiki/List_of_Konami_code_games
Interesting article from the BBC on destorying your computer’s hard drive.
Here are some useful places to find video tutorials:
* I especially like Common Craft’s approach.
These SQL Server Performance Tips are from Simon Harriyott’s blog.
When you need to return the top number of rows in a result set you would use SELECT TOP which can be a percentage or number e.g.
SELECT TOP 5% … etc
SELECT TOP 5 … etc
This is fairly simple but what if the fifth, sixth and seventh rows had the same value. You would probably want to return them as well. This can be achieved by using WITH TIES e.g.
SELECT TOP 5 WITH TIES EmployeeID, Salary
FROM Employee
ORDER BY 2 DESC /* the 2 represents the second column */
The result set would have 7 rows.
Also see With Ties – SQL Server Tip from Simon Harriyott’ blog for an excellent example.
I found this pdf recently on How to use New Media. It’s a useful explanation of web 2.0 and includes a number of practical examples.
Sitepoint have released a major update to their free online reference, covering:
Here’s a collection of 10 lightweight applications if you are running an older PC or even if you’re not.
I tried CCleaner and managed to free up 1Gb on my hard drive.
Found this code sample recently on how to loop through a result set without using a cursor and therefore reducing any locking problems.
DECLARE @NextID INT
SELECT @NextID = MIN(EmployeeID) FROM EmployeeS
WHILE @NextID IS NOT NULL
BEGIN
SELECT EmployeeID, FirstName + ‘ ‘ + LastName FROM Employees
WHERE EmployeeID = @NextID
SELECT @NextID = MIN(EmployeeID) FROM Employees WHERE EmployeeID > @NextID
END
The code is incomplete. I imagine using a SELECT INTO statement to insert the records into a temporary table would be useful.
