*
  
*
*
* *
Login 
  Monday, April 22, 2019 Register 
Weblog Calendar
 
 
 
Weblog Archive
 
 
 
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

Posted By: Blaine Trimmell | Permalink
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.
Posted By: Blaine Trimmell | Permalink
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.

 

Posted By: Blaine Trimmell | Permalink
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. 
Posted By: Blaine Trimmell | Permalink
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

Posted By: Blaine Trimmell | Permalink
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

Posted By: Blaine Trimmell | Permalink
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

Posted By: Blaine Trimmell | Permalink
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

Posted By: Blaine Trimmell | Permalink
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

Posted By: Blaine Trimmell | Permalink
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

Posted By: Blaine Trimmell | Permalink
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
Posted By: Blaine Trimmell | Permalink
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/
Posted By: Blaine Trimmell | Permalink
Weblog Recent List
 
 
 
Copyright 2002-2003 Worldinfomall
*
The Nerd Group   Terms Of Use   Privacy Statement
>