Wednesday, December 31, 2003 |
10:02 AM |
December 31,2003 |
Since this is the last entery for the year it is kind of appropriate for the first few internesting things that I found on the internet to be related to time. I found to pages on a website, http://www.minasi.com/ under the goffing off section, about time. One show how long each day really is ( they are not all 24 hours), http://www.minasi.com/dolog.htm , and the other lists the differences between a sundials clock and a watch, http://www.minasi.com/doeot.htm |
|
|
Tuesday, December 30, 2003 |
3:12 PM |
December 30,2003 |
Here are some good articles on WPA ( Windows Prodcut Activation), http://www.tecchannel.com/client/desktop/31/ .One artaicle tells about how and what Win XP activation is doing and one talks about Windows Update website. |
|
|
Wednesday, December 24, 2003 |
3:56 PM |
December 24, 2003 |
I foudn out about a interesting site, http://www.googlewhack.com that is a site that lists 2 word searchers that return extactly one result.
|
|
|
Tuesday, December 23, 2003 |
11:39 AM |
December 23,2003 |
This is a interesting interview from News.com with Tim Bray , co-inventor of xml, http://news.com.com/2008-1082-5080774.html . One of the things I thought was an eye opener is that his company does not use XML internally just to exchange data with outside people. |
|
|
Wednesday, December 17, 2003 |
4:44 PM |
December 17,2003 |
This is way cool, http://direct.msn.com/ , it is the home page for the new SPOT , Smart Personal Objects Technology , from MS. Serval watch makers have watches coming out in january , Fossial is one of them, look at fossils here This site has some info, http://www.spotsmart.com/
Here is a nice little free tool that will let you edit/delete typed url, http://www.webattack.com/get/editurl.html |
|
|
Tuesday, December 16, 2003 |
10:08 AM |
December 16,2003 |
Here is a nice use of flash, a greeting card that the link was emailed, same email, nice use of the internet. http://www.cardiff.com/flash/card_opt12.html
Here are some cool products that any nerd would like, http://www.scottevest.com and http://www.egrips.com
SQL SERVER STUFF I was on www.sqlservercentral.com and was reading some artilce from Christoffer Hedgate and saw a review of a product called SQL Stripes, http://www.sqlservercentral.com/columnists/chedgate/reviewofsqlstripes.asp , it is a nice little app. One of those you keep meanig to write. Well, some one did it for you and right now for the price of $0.00 ( free thats right , free) . Here is a link to the prodcut, http://stripes.docmusic.com |
|
|
Monday, December 15, 2003 |
4:54 PM |
December 15,2003 |
As you will soon see todays entry is about XML Schema stuff. Although, I am not a big fan of XML since it is very word and cause files to be much larger than their counter part CSV or Fixed Width file they do offer advantages when you need to read the file with human eyes or the number of fields are large and the required fields per record are much smaller which then can reduce the file size. If done correctly a saved XML file an do substitution of common strings to help reduce file size. Here is an article from MS about creating XML Schema from a Class, http://samples.gotdotnet.com/quickstart/howto/doc/xmlserialization/XSDFromCls.aspx
Here is a Walthrough from MS for creating a XML schema with the XML designer in Visual Studio .NET , http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbwlkwalkthoughdesigningpurchaseorderschema.asp
This is the W3C page on Schema, http://www.w3.org/XML/Schema#dev This page has a list of tools and the Specifications and Development section as some primers that are good.
here are some links to some other appliactions that help build XML scheme, XMLWritter From Wattle Software ( around $89 US), http://xmlwriter.net/ VisualScript XML From SmartDraw.com , http://www.visualscript.com/products/visualscript/index.htm Sonic Stylus Studio from Sonic Software http://www.sonicsoftware.com/products/sonic_stylus_studio/index.ssp
|
|
|
Thursday, December 11, 2003 |
11:22 AM |
December 11,2003 |
Ever need to delete duplicate records, this query will do it
DELETE FROM products WHERE recID NOT IN( SELECT MAX(recID) FROM products GROUP BY productcode,productdate)
or this one
DELETE FROM products WHERE EXISTS ( SELECT 1 FROM products prd1 WHERE products.productcode = prd1.productcode AND products.productdate = prd1.productdate AND products.recid < prd1.recid )
both will keep the record with the largest recid, if you want the smallest then change , products.recid < prd1.recid , to products.recid > prd1.recid , in the second version. In the first version change the Max function to a Min. The second version should be faster if on a large table.
sample table
RECID |
ProductCode |
ProductDate |
1 |
a123 |
2003-10-12 00:00:00 |
4 |
a123 |
2003-10-13 00:00:00 |
6 |
a123 |
2003-10-30 00:00:00 |
5 |
a123 |
2003-10-30 00:00:00 |
2 |
b |
2003-10-15 00:00:00 |
8 |
b |
2003-10-31 00:00:00 |
7 |
b |
2003-10-31 00:00:00 |
3 |
w |
2003-10-15 00:00:00 |
The resulting table would look like this:
RECID |
ProductCode |
ProductDate |
1 |
a123 |
2003-10-12 00:00:00 |
4 |
a123 |
2003-10-13 00:00:00 |
6 |
a123 |
2003-10-30 00:00:00 |
2 |
b |
2003-10-15 00:00:00 |
8 |
b |
2003-10-31 00:00:00 |
3 |
w |
2003-10-15 00:00:00 | |
|
|
Tuesday, December 09, 2003 |
10:19 AM |
December 9,2003 |
Here are some great flash itmes from E-Tractions.com , check them out Snow Globe - http://ww12.e-tractions.com/snowglobe/intro.htm Some Funny Games - http://ww12.e-tractions.com/web_dev/content/examples_fr.htm |
|
|
Tuesday, December 02, 2003 |
11:38 PM |
Devember 2, 2003 - Google |
If you like google and are ready to take it to the next step then learn to use the advanced features , http://www.google.com/help/operators.html , then there are these services that they offer , http://www.google.com/help/features.html , like you can type 5*3/48 and it will do the math. Here is a complete list of some of the services they offer like a API to make searches and offer customer stuff, http://www.google.com/options/index.html , like http://www.googlealert.com/ If you want to see what google is up to check out the labs page, http://labs.google.com/ , and you might dicover that google has a test doing voice phone searches, http://labs1.google.com/gvs.html |
|
|
10:48 AM |
December 2, 2003 |
I stumbled on to this access control system looking for something else and they are pretty cool. It uses the id buttons or a key that ids who , and when they accessed the system, they even have checkpoint devices so you can have a clock in out type of deal without a lock. how sweet is that, check them out , http://www.videx.com/ac_html/access_control.shtml |
|
|
Monday, December 01, 2003 |
10:39 AM |
December 1,2003 |
Well, like the wind November and the year has passed by and we are down to one month for 2003. Here is a funny quiz for computer nerds or people who like serial killers, http://www.malevole.com/mv/misc/killerquiz/ |
|