SQL, Active Directory, and lastLogonTimestamp

There’s a fair bit of advice out there about converting the miserable integer8 (ANSI) date format into something you can use, but for some reason, none of it quite works for me.

I have been using MS SQL SERVER 2005, which may or may not be a specific part of the problem.

ANSI dates begin 1/1/1601, while Microsoft dates have, until recently, begun 1/1/1900.  Also, I believe MS dates are/were measured in millisecond, but I’m not sure.  I do know that the ANSI timestamp is represented in units of 100 nanoseconds since 1/1/1601, which is where we start.

If you grab the lastLogonTimestamp from Active Directory (say, by doing a csvde -m -f output.csv and the using the Jet.4.0 connector to represent the directory as a linked server’s … Continue reading

Medical Civil Disobedience

Doctor Cassell’s notice to customers. [Fair Use Claimed. Original caption and credits: “Sign at the office door of Dr. Jack Cassell, a Mount Dora urologist. (Photo by Deirdre Lewis / April 1, 2010)”]

As reported in the Orlando Sentinel: Mount Dora doctor tells Obama supporters: Go elsewhere

I admit that I’m torn as to whether this is acceptable for a doctor, as opposed to a different sort of business.  After all, I think that we are all fairly opposed to seeing a notice on the door of a medical provider telling you that you will be seen based on your politics.

In the end, however, I find it acceptable.  Here’s … Continue reading

Drydock 1, Yokosuka

Keeping your bottom dry since 1871

Following text peeled shamelessly from Wikipedia:

In 1866, the Tokugawa shogunate government established the Yokosuka Seisakusho, a military arsenal and naval base, with the help of foreign engineers, including the French naval architect Léonce Verny. The new facility was intended to produce modern, western-style warships and equipment for the Tokugawa navy. The construction of the arsenal was an important first step for the modernization of Japan’s industry. Modern buildings, an aqueduct, foundry, brick factories, technical schools to train Japanese technicians were established.

After the Boshin War and the Meiji Restoration, the new Meiji government took over control of the facility in 1871, renaming it the Yokosuka Zosenjo (Yokosuka Shipyards). The first dry dock … Continue reading

Advertising Fail

Novell paid a lot of money to have this image splashed around various websites. Of course, there is some story behind it.  Perhaps some of the text was supposed to be moving.  Perhaps this is a transition between slides.  I don’t know.  I will probably never know.  Because this is all I got.

Gorilla Run — Frank's Birthday

London’s Gorilla Run 2009 was held on September 26, which is Frank’s birthday.  One of my favorite Frank stories was about him doing a Gorilla Run in Hawaii, as part of a promotion for something.  If you’re not familiar with Gorilla Runs, a brief video may help you understand.  Or not.

Happy Birthday, Frank.  We all miss you.