Wednesday, September 26, 2007

Tech support fun

Nothing is fucking better than coming home after a 17 and a half hour day, collapsing in bed, and then an hour later having your on-call pager go off so you can spend the next 45 minutes tailing a log file while a customer de-fubars his Oracle cluster.

Wonderful.

Tired and Grumpy

Worked from 9:30 to 3am. Just getting home now. Run into a pretty serious problem and I'm not seeing any easy way out. Shit.

I got some more spam in my LiveJournal comments section today. If this continues I'm going to have to restrict posting to logged on users. This will clearly inconvenience the two out of the three people who post to my blog since they will have to get their own accounts.



Also discovered that Apple recently changed the DVD player that comes with OS X so that you can't do screenshots while it is running. In fact, it specifically says "Screen capture is not permitted when DVD Player is running". That kind of pisses me off since it's a completely arbitrary decision and Apple doesn't really have anything to gain by preventing it since they aren't a movie studio.

Tuesday, September 25, 2007

Verizon DSL arrived

So my self-install kit for Verizon DSL showed up in the mail today. It isn't supposed to be activated until October first. I love completely one-sided contracts. Check out their Terms of Service. Oh yeah, and it's double sided:



Alot of it is the standard boilerplate I would expect of any provider - the Internet is a dangerous place, we aren't responsible if you get a virus, blah blah.

Here's a few fun snippets:

15.2 You agree that the Internet is not owned, operated or managed by, or in any way affiliated with Verizon and Verizon is not responsible and has no control over the information or materials accessible thorugh use of the Service.

Well, that's a load off. Glad that they are willing to recognize that Al Gore invented the Internet and Sun is "the com in dot com". No Verizon, you own THE TELEPHONE NETWORK.

15.6 You are not authorized to use any Verizon name or mark as a hypertext link to any Verizon Web site or in any advertising, publicity or any other commercial manner without the prior written concsent of the Verizon Licensing Company.

So in other words, if I were to put a link on my website to Verizon's website, like so http://www.verizon.com, then I would be violating their Terms of Service. Good thing I'm writing this post this from my stolen wireless connection instead of my new DSL service.

The really good stuff though is what they consider to be "acceptable use". Here a summary of what is not acceptable:

Verizon reserves the right to deny Service to you if your use of the Service ... and in the sole discretion of Verizon (a) is obscene, indecent, pornographic, sadistic, cruel or racist in nature, or of a sexually explicit or graphic nature; (b) espouses, promotes or incites bigotry, hatred or racism; (c) might be legally actionable for any reason, (d) is objectionable for any reason, or (e) in any manner violates the terms of this Acceptable use Policy.

Here comes the thought police... Don't get me wrong, racism and bigotry are bad, but do I really want Verizon to be the judge and jury on what constitutes "objectionable", "obscene", or "indecent"? At least in the worst case all they can do is terminate my service, charge me for the equipment, and charge me the mandatory early termination fee (yes, they can still charge the early termination fee even if they terminate the contract [see section 13.1.3 of the contract]).

Here are a few things beyond the typical "no spamming or stealing service" rules that constitute a violation of Acceptable use

  • (j) to damage the name or reputation of Verizon, its parent, affiliates and subsidiaries, or any third parties (so does writing this post discussing their ridiculous contract violate their TOS?)
  • (n) to generate excessive amounts (as determined by Verizon at its sole discretion) of Internet traffic
  • (s) to cause the screen to "scroll" faster than other subscribers or users are able to type to it...

The ridiculousness goes on and on, but I am tired and must sleep now.

Weekend roundup

On Saturday Victoria and I went to New Jersey. Had lunch with Grandma (who's birthday was Monday), Lauren, and Greg. Lauren had put together a gift package for me as a thank you for our participation in the wedding, which included awesome stuff like Season 3 of The Office on DVD, various pictures from her camera, Magnetic Poetry - The Office Style, and my very own Dwight-head stress ball.


(click to enlarge)

And no, Lauren did not give me the helpful recycling guide on the fridge. That was the City of New York Department of Sanitation.

Afterwards, went over to Jen and Jon's and played with Jayden for a couple of hours. I don't think I have ever seen such a hyperactive child. He was literally spinning in circles until he fell down. Holy cow.

Went to Michelle's party in Spring Lake that night. Met my high school typing teacher Mrs. Sullivan for the first time in about twelve years. Yummy desserts.

Came back to New York on Sunday. Spent the entire day at the office. Bleh.

Wednesday, September 19, 2007

Tired

Another long day. Arrived 10:00. Left 11:00.

Spent a good portion of my evening trying to figure out how to determine what Edition of SQL Server 2000 is installed on a server. In newer versions, it's alot easier as there is just a registry key to check, but with the earlier versions of SQL Server, it is considerably more difficult. Found a scarcely documented call on MSDN though that might be worth trying.

Apparently you can get the Edition info by making an undocumented call to an export provided by sqlboot.dll

DWORD WINAPI QueryValue(DWORD dwSetting);
typedef DWORD (WINAPI *LPFNQUERYVALUE)(DWORD); // QueryValue function pointer

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarsql7/html/deploybus_depdbsol.asp

Yes, I realize that I'm calling it undocumented but pointing to Microsoft's web site. Perhaps "completely unsupported and not in any official API documentation" would be a more appropriate characterization.

It is described a bit by a Microsoft developer in the SQL Server newsgroup too:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/f8bff873df9992a0/996e3e35e6483d5a?hl=en&lnk=st&q=sqlboot.dll&rnum=20#996e3e35e6483d5a

This whole thing wouldn't be an issue except you have to have the installation media in order to uninstall clustered instances. So I have to upload 500 MB worth of CD to the server in order to do an uinstall, and it has to be the media that matches whatever the edition I am trying to uninstall.

The whole matter makes me appreciate how much better the install works for SQL Server 2005, despite the issues I have run into there as well.

Tuesday, September 18, 2007

The saga continues

Had another fun day at work. Got there at 9:45. Left at 11:30. Ugh. Continuing to make forward progress, slowly.

Not that I want to use my blog just to bitch about my job. Unfortunately I didn't do anything else today so that's all there is. Tune in next time for the continuing adventure...

More insomnia

Yesterday worked from 10am to 12am. Came home. Peanut butter and honey sandwich for dinner. Sleep. Kept waking up from dreams about SQL Server clustering. Ugh. Around 5am I watched an episode of "From the Earth to the Moon" on DVD that Dan loaned me. Work starts again in 45 minutes.