Article View: bit.databases.mssql-l
Article #165Where does one start?
From: Doug Gentry
Date: Sun, 01 Jul 2001 00:17
Date: Sun, 01 Jul 2001 00:17
47 lines
3652 bytes
3652 bytes
At work we get an email from HR every Week telling us at the helpdesk who is going to be terminated and on what date. Then when the date comes up we disable the account and start to remove their network privileges, deleting email account and so on and so forth. Now comes the fun part. During the week we get all these emails from HR telling us that this person or that person will NOT be leaving on this date but will be leaving at a later date. We then have to remember when these peoples dates have changed. I was thinking to myself, Gosh, this needs to be put into a database of all the employees and when someone is getting ready to leave we in the helpdesk can see up to the minute information on these employees. I'm leaning towards the idea that HR should have a company wide Employee database and when a box is selected (lets call it "Terminate") that would open a page where they can enter the date when that person will be leaving. Then we at the helpdesk would have access to that page. Anytime HR would make a change to those fields it would update the page at that moment. Then we could go about our business without having to track down various emails relating to these people. As a learning project and maybe get noticed a bit. (Blush blush..self serving bastard aren't I?) Anyway. I would like to build a kind of small demo database and take it to work and show them what we can do. I'm running Win 98 on this drive and have Access 2000, But I also run Linux RH on my other drive. 1. Should I do this on 98 or RH? I'm leaning towards RH myself. 2. Which or what should I build it with? Oracle, Mysql? Or what? I'm looking for suggestions here. 3. I would also like to do it with a webpage where HR can go and enter the data and we can get the data output on the page with ASP. 4. Now, the company is running NT servers on a novell network and NT workstations with some 95 and 98 workstations. Also they're using Lotus notes.. GAKkkk.. BUT.. they are going to be moving to Win 2000 servers and Win 2000 workstations and exchange, except I did hear something in the works about ME. GAkkkkkkk... way too much to do hu? I am reading everything I can get my hands onto but I'm running into a slight problem of information overload adn then everyone says their product is SOoooo much better than the others. I'm starting to get confused with this stuff now. So if anyone can set me straight and point me in the correct direction. I'll even settle for your humble opinion on what you think. I would be very appreciative. Thanks So much. Doug Gentry
Technical Details
Message-ID:
<2_t%6.274857$p33.5537851@news1.sttls1.wa.home.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!canoe.uoregon.edu!hammer.uoregon.edu!enews.sgi.com!newshub2.rdc1.sfba.home.com!news.home.com!news1.sttls1.wa.home.com.POSTED!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f6611,edcf8bb87454281c,start X-Google-Attributes: gidf6611,public X-Google-ArrivalTime: 2001-06-30 17:17:03 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!canoe.uoregon.edu!hammer.uoregon.edu!enews.sgi.com!newshub2.rdc1.sfba.home.com!news.home.com!news1.sttls1.wa.home.com.POSTED!not-for-mail From: "Doug Gentry" <None@home.com> Newsgroups: bit.databases.mssql-l Subject: Where does one start? Lines: 51 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Message-ID: <2_t%6.274857$p33.5537851@news1.sttls1.wa.home.com> Date: Sun, 01 Jul 2001 00:17:02 GMT NNTP-Posting-Host: 24.20.46.181 X-Complaints-To: abuse@home.net X-Trace: news1.sttls1.wa.home.com 993946622 24.20.46.181 (Sat, 30 Jun 2001 17:17:02 PDT) NNTP-Posting-Date: Sat, 30 Jun 2001 17:17:02 PDT Organization: Excite@Home - The Leader in Broadband http://home.com/faster