IWETHEY.Employed++

Looks like Third Time is the charm. The manager/owner called me back today and offered me the job. Same rate as I made at the lawfirm, plus benefits. I'll work out the benefits tomorrow. I assume health insurance, etc. No 401K, but they s*ck these days anyway. I'd rather put my money into a Money Market or Mutual Fund and then roll it over to an IRA anyway.

I think I impressed him with the "peer to peer" updates of the database in case the server was down, and adding a "Last_modified" field in the table so they can tell when the record was last updated. Whomever gets the highest date gets updated, that way the hospital can tell where the tray is, not where it was yesterday. If Workstation A cannot find the SQL Server, then have it talk to Workstation B and Workstation C and see if it has an updated record for that tray. If it does then pull it down and update the database. He wants them to be able to Synch up to the main database, but they didn't think about the different workstations updating each other.

is that the network is maintained by hospital staff. The workstations could be on a different subnet than the server, and if someone futzes up security a bit on the network and the workstations cannot see the server for a few days until someone can fix it, then just have the workstations update each other until they can see the server.

For the offline viewer, consider using transaction tables and then do a big batch update when the network is back online.

The fault could be with the server, if someone does something to it, or changes an access password without telling the developers. Heck, some Nurse may have tripped over a network cable and unpluged it, and didn't notice it for hours or days.

Right now it takes Crystal Reports over six hours to do one report, my job is to make it do less than that. The program is mostly written in Excel VBA for now, and the VB conversion is on the way. One big mess, and I am the one to clean it up and get it to work better.

Post #50,641 by orion 9/5/02 2:58:21 PM Reply	IWETHEY.Employed++ Looks like Third Time is the charm. The manager/owner called me back today and offered me the job. Same rate as I made at the lawfirm, plus benefits. I'll work out the benefits tomorrow. I assume health insurance, etc. No 401K, but they sck these days anyway. I'd rather put my money into a Money Market or Mutual Fund and then roll it over to an IRA anyway. I think I impressed him with the "peer to peer" updates of the database in case the server was down, and adding a "Last_modified" field in the table so they can tell when the record was last updated. Whomever gets the highest date gets updated, that way the hospital can tell where the tray is, not where it was yesterday. If Workstation A cannot find the SQL Server, then have it talk to Workstation B and Workstation C and see if it has an updated record for that tray. If it does then pull it down and update the database. He wants them to be able to Synch up to the main database, but they didn't think about the different workstations updating each other. [link\|http://games.speakeasy.net/data/files/khan.jpg\|"Khan!!!" -Kirk]*
Post #50,642 by inthane-chan 9/5/02 3:01:31 PM Reply	Schweet! Go! Go! Go! WOOOT! End of world rescheduled for day after tomorrow. Something should probably be done. Please advise.
Post #50,646 by ChrisR 9/5/02 3:21:50 PM Reply	Congrats Sounds like you've already got your head wrapped up in the project. :-) I'm wrestling with a similar problem in that the main application is accessed via browser, but I want to write an offline client that can be used to view and update info. I don't envision a peer-to-peer solution, but I see where that could be interesting if you make the assumption that the fault is in the server, not in the network.
Post #50,648 by orion 9/5/02 3:26:52 PM Reply	The problem as I see it is that the network is maintained by hospital staff. The workstations could be on a different subnet than the server, and if someone futzes up security a bit on the network and the workstations cannot see the server for a few days until someone can fix it, then just have the workstations update each other until they can see the server. For the offline viewer, consider using transaction tables and then do a big batch update when the network is back online. The fault could be with the server, if someone does something to it, or changes an access password without telling the developers. Heck, some Nurse may have tripped over a network cable and unpluged it, and didn't notice it for hours or days. Right now it takes Crystal Reports over six hours to do one report, my job is to make it do less than that. The program is mostly written in Excel VBA for now, and the VB conversion is on the way. One big mess, and I am the one to clean it up and get it to work better. *[link\|http://games.speakeasy.net/data/files/khan.jpg\|"Khan!!!" -Kirk]*
Post #50,647 by boxley 9/5/02 3:26:15 PM Reply	You can doo itt!! now cut to the part in the movie water boy where the old cajun dude is twisting his nipple rings. great news!! thanx, bill will work for cash and other incentives [link\|http://home.tampabay.rr.com/boxley/Resume.html\|skill set] [link\|http://home.tampabay.rr.com/boxley/index.html\|boxley's home page]
Post #50,651 by drewk 9/5/02 3:32:52 PM Reply	About farkin time! I was gettin' real tired of seeing the other subject line in here. Way to persevere, dude. === Microsoft offers them the one thing most business people will pay any price for - the ability to say "we had no choice - everyone's doing it that way." -- [link\|http://z.iwethey.org/forums/render/content/show?contentid=38978\|Andrew Grygus]
Post #50,652 by Another Scott 9/5/02 3:34:56 PM Reply	Congrats! We all hope it works out well.
Post #50,664 by a6l6e6x 9/5/02 5:13:53 PM Reply	Excellent news! Now make them glad they did. Alex "Resort is had to ridicule when reason is against us." -- Thomas Jefferson
Post #50,667 by SpiceWare 9/5/02 5:44:04 PM Reply	Congrats! Darrell Spice, Jr. [link\|http://home.houston.rr.com/spiceware/\|SpiceWare] - We don't do Windows, it's too much of a chore
Post #50,678 by JayMehaffey 9/5/02 7:00:33 PM Reply	Congragulations - NT
Post #50,693 by ben_tilly 9/5/02 7:36:39 PM Reply	See, I said to take it seriously! :-) Computer Science is no more about computers than astronomy is about telescopes. -- Edsger Wybe Dijkstra (1930-2002)
Post #50,695 by imric 9/5/02 7:47:39 PM Reply	CHEER Best news I've had in a while! Imric's Tips for Living Paranoia Is a Survival Trait Pessimists are never disappointed - but sometimes, if they are very lucky, they can be pleasantly surprised... Even though everyone is out to get you, it doesn't matter unless you let them win.
Post #50,699 by folkert 9/5/02 8:09:07 PM Reply	TAAA DAAAA!!!! Smoking in the boys room again huh?? Well now you know what THAT'LL get ya.... Excellent Take Sir... `greg - Grand-Master Artist in IT, curley95@attbi.com -- [link\|http://www.iwethey.org/ed_curry/\|REMEMBER ED CURRY!!!] Your friendly Homeland Security Officer reminds: Hold Thumbprint to Screen for 5 seconds, we'll take the imprint, or Just continue to type on your keyboard, and we'll just sample your DNA.`
Post #50,701 by slugbug 9/5/02 8:34:11 PM Reply	Very good news!
Post #50,704 by admin 9/5/02 8:39:22 PM Reply	Excellent. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #50,712 by bepatient 9/5/02 9:43:26 PM Reply	Dude...you ROCK! Keep on impressing them!!! You were born...and so you're free...so Happy Birthday! _{Laurie Anderson} [link\|mailto:bepatient@aol.com\|BePatient]
Post #50,722 by tjsinclair 9/5/02 10:32:38 PM Reply	Yee-haw! Tom Sinclair "Everybody is someone else's weirdo." - E. Dijkstra
Post #50,729 by altmann 9/5/02 10:43:32 PM Reply	Woohoo! -- Chris Altmann
Post #50,736 by broomberg 9/5/02 11:03:43 PM Reply	Glad to hear it I hope you kick ass and OWN the industry. You make a lot of money, and the SOB who is competing with you that left my company loses another job.
Post #50,737 by gdaustin 9/5/02 11:03:57 PM Reply	Very Kewl! Good luck!
Post #50,758 by pwhysall 9/6/02 1:39:33 AM Reply	Well done. Peter [link\|http://www.debian.org\|Shill For Hire] [link\|http://www.kuro5hin.org\|There is no K5 Cabal] [link\|http://guildenstern.dyndns.org\|Blog]
Post #50,764 by Ashton 9/6/02 2:01:54 AM Reply	Promise them anything But give them Arp\ufffdge. Nice whsiperin' in the ear, there.. (Umm that's a perfume, son) (Was.?. a perfume, anyway)
Post #50,767 by wharris2 9/6/02 2:43:29 AM Reply	Life sucks, and then you get a new job? Seriously, dude (d00d?) congrats. It hurts, really hurts, to be a good guy adrift in a sea of tech workie wannabies. Best of luck/skill to you and... well if you're ever near Cincinnati, I'll buy you lunch or dinner. (Offer goes for all IWE here, breakfast, lunch, dinner. I may cuss yoou out if you order the most expensive item on the menu, but I'm goood for it [me grins]) The lawyers would mostly rather be what they are than get out of the way even if the cost was Hammerfall. - Jerry Pournelle
Post #50,795 by Silverlock 9/6/02 8:28:49 AM Reply	Now THAT, is seriously good news. I would also say, thank god you're not working for lawyers again. I hope to see a few more announcements like this from our other workforce challenged members. Re-elect Gore in 2004
Post #50,807 by Arkadiy 9/6/02 9:37:22 AM Reply	Finally! You're free now, to choose your own destiny. :) We have only 2 things to worry about: That things will never get back to normal, and that they already have.
Post #50,856 by deSitter 9/6/02 2:23:29 PM Reply	Re: IWETHEY.Employed++ Hey, come down to Soulard and I'll buy you a NA beer! When do you start? -drl
Post #50,917 by orion 9/6/02 10:42:14 PM Reply	I started today the boss didn't want to waste any time. So I started today, took a few hours to meet everyone, got a laptop with Windows 2000 Pro on it, and started installing programs on it. today. *[link\|http://games.speakeasy.net/data/files/khan.jpg\|"Khan!!!" -Kirk]*
Post #50,954 by bepatient 9/7/02 8:36:57 AM Reply	Awesome. I just got one of the pre-win2k machines as a "special loan"...on migration I had one legacy app that required "non-standard" configuration. Dell Latitude CPi 266. Runs Linux well ;-) Now to test this app against DOS emulation...it shall be free. They may sell off a bunch of these...they have about 100 and they aren't minimum spec for Win2k. I may get one for every room....though I could get one for every floor...and just carry them from room to room...(wireless is where its at ;-) You were born...and so you're free...so Happy Birthday! _{Laurie Anderson} [link\|mailto:bepatient@aol.com\|BePatient]
Post #50,971 by deSitter 9/7/02 10:55:31 AM Reply	Re: I started today Doesn't it rock when work gets you a quality ride? So what did they give you? -drl
Post #51,031 by orion 9/8/02 2:28:19 AM Reply	What they gave me is a Dell Inspiron 2500, 800Mhz Celery, er Celeron processor, 128M RAM, 10G HD, etc. I finish the paperwork on Monday and get the same benefits as everyone else. No 401K, but Health, Stock, etc. *[link\|http://games.speakeasy.net/data/files/khan.jpg\|"Khan!!!" -Kirk]*
Post #50,991 by kmself 9/7/02 4:33:00 PM Reply	Sweet. Glad to hear it, Norm, and very long overdue. -- Karsten M. Self [link\|mailto:kmself@ix.netcom.com\|kmself@ix.netcom.com] [link\|http://kmself.home.netcom.com/\|[link\|http://kmself.home.netcom.com/\|http://kmself.home.netcom.com/]] What part of "gestalt" don't you understand? [link\|http://twiki.iwethey.org/twiki/bin/view/Main/\|TWikIWETHEY] -- an experiment in collective intelligence. Stupidity. Whatever. Keep software free. Oppose the CBDTPA. Kill S.2048 dead. [link\|http://www.eff.org/alerts/20020322_eff_cbdtpa_alert.html\|[link\|http://www.eff.org/alerts/20020322_eff_cbdtpa_alert.html\|http://www.eff.org/...a_alert.html]]
Post #50,882 by CRConrad 9/6/02 5:41:37 PM Reply	Bravo! Best of luck in your new job!
Post #50,924 by tuberculosis 9/6/02 11:00:00 PM 8/21/07 6:27:03 AM Reply	SCORE! See, life can't suck all the time. I am out of the country for the duration of the Bush administration. Please leave a message and I'll get back to you when democracy returns. Edited by tuberculosis Aug. 21, 2007, 06:27:03 AM EDT Expand All History
Post #50,952 by static 9/7/02 7:31:34 AM Reply	Great news, my friend! "Ah. One of the difficult questions."
Post #51,145 by bbronson 9/9/02 6:39:41 PM Reply	Way to go! Granted, it's not a Macintosh job... ...but neither is mine! Good luck kicking ass and taking names! Brian Bronson
Post #51,150 by orion 9/9/02 7:24:07 PM Reply	It may turn out to be it depends on which direction the boss wants to take it. He is tired of Microsoft technology and is looking at alternatives. Linux, Java, Oracle, MySQL, PHP, etc. I am setting up a test server at work now, Windows 2000 Server, SQL Server, Terminal Server, etc. *[link\|http://games.speakeasy.net/data/files/khan.jpg\|"Khan!!!" -Kirk]*
Post #51,160 by Ashton 9/9/02 8:36:09 PM Reply	Heh.. with a little luck and sustained subtle prodding - you just might turn out to be the most effective IWE-Subversive yet! Smoky glass; clouds roil.. scene clears briefly - buncha folks in strange metallic-looking T-shirts lounging about some screen-like thingies. They seem to be toasting? some event - Viva Bolivar! who taught us to kick out the despots.. Viva Norman! who converted the first Corp exec to rational thought, made a fortune and retired to found the Home for Aged Downsized IT Workers It is a far far better thing I do than I have ever done..
Post #51,185 by Meerkat 9/10/02 6:56:52 AM Reply	Wheee! John. Busy lad.
Post #51,286 by Steve Lowe 9/10/02 6:48:31 PM Reply	Right ON!! :-) Congrats, Norm! I told you I thought this one lined up really well with your skillset, glad to see that they thought so, too!! GOOD SHOW!! :-) ----- Steve

Welcome to IWETHEY!