First day on new job AAAAAAAGGGGHGHGHGHGHGHGHG!!!!!

Post #100,473 by boxley 5/5/03 10:57:05 PM Reply	First day on new job AAAAAAAGGGGHGHGHGHGHGHGHG!!!!! I was hired as a SAN/Architecht/sysadmin. A group of 20 newbies are placed in a room and were warned of the horrors of data center work in the largest of the baby bells. After suitable warnings, myself and one other was separated from the pack and led elsewhere. My new job consists of: The architecture group is separated into Servers/networks/storage I am with the server group. In the last Year DEV groups wanting resources go to MY group and whine for equipment. Using best practices MY group allocates resources to the DEV groups for test/QA/prod. Now MY group wants to take the various spreadsheets, word docs, PPT presentations of the historical decisions made by my group and match them to the usability reports(sar outputs etc) to validate their processes and make a model of right sizing production needs to see if they have left money on the table(allocated resources correctly) they also would like a front end to define a transaction/usage need by app/db/frontend/backend requirement to make the provisioning system semi automatic. At lunch the other sysadmin looked at me and said fuck this I am out of here. Me I have never done this before so would find it mildly interesting. First thing is cornholing all the data points into a central repository with Win XP office and any sql compliant freebee tools (databases) available for that platform. Any Ideas would be appreciated. thanx, bill will work for cash and other incentives [link\|http://home.tampabay.rr.com/boxley/resume/Resume.html\|skill set] questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org] Carpe Dieu
Post #100,483 by deSitter 5/6/03 1:37:37 AM Reply	Great News! The fact that one can again make money doing nothing is a sure sign the economy is improving! -drl
Post #100,496 by CRConrad 5/6/03 7:16:03 AM Reply	"...any sql compliant freebee tools (databases)..." [link\|http://firebird.sourceforge.net\|http://firebird.sourceforge.net] [link\|mailto:MyUserId@MyISP.CountryCode\|Christian R. Conrad] (I live in Finland, and my e-mail in-box is at the Saunalahti company.) Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link\|http://z.iwethey.org/forums/render/content/show?contentid=71575\|Ashton Brown]
Post #100,497 by pwhysall 5/6/03 7:24:51 AM 5/6/03 7:25:01 AM Reply	Not like you're biased or anything, eh? :-D 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] Edited by pwhysall May 6, 2003, 07:25:01 AM EDT Expand All History
Post #100,654 by boxley 5/6/03 10:33:14 PM Reply	thank you, youre a "Christian" and a gentleman :-) will do will work for cash and other incentives [link\|http://home.tampabay.rr.com/boxley/resume/Resume.html\|skill set] questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org] Carpe Dieu
Post #100,533 by Steve Lowe 5/6/03 11:25:32 AM Reply	MySQL [link\|http://www.mysql.com/\|MySQL] runs pretty good on WinXP. I was playing with it a few months ago. ----- Steve
Post #100,636 by orion 5/6/03 7:36:22 PM Reply	Yikes, hold on there Bill tackle it as you would anything else, take it one part at a time. Do the Database in Access XP first, then scale it up to a SQL Server or other database later on. Since you have Win XP Office, I assume you have a license for Access XP. In Access XP you can work out the design flaws. As far as alternatives to SQL Server go read this post: [link\|http://z.iwethey.org/forums/render/content/show?contentid=80450\|http://z.iwethey.org...w?contentid=80450] You might have to do some data entry to convert the data from Powerpoint, etc. I am not sure how else to turn charts and graphics into raw data. Word and Excel sheets you can just copy and past the numbers off of them into the tables. If you hold on to the project and get it done, it will be a feather in your cap. Good luck. *"If you're going to cheat, cheat fair. If there's anything I hate it's a crooked crook!" -Moe Howard*
Post #100,653 by boxley 5/6/03 10:31:39 PM Reply	Sorry the fscking Orifice professional doesnt come with abcess, it has msquery but no fucking abcess. Think I will give CRC's stuff a shot. thanx, bill will work for cash and other incentives [link\|http://home.tampabay.rr.com/boxley/resume/Resume.html\|skill set] questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org] Carpe Dieu
Post #100,696 by jbrabeck 5/7/03 8:59:07 AM Reply	Gotta disagree with you... Per the [link\|http://www.microsoft.com/office/howtobuy/choosing.asp\|Microsoft Office website] XP Office Professional does come with Abcess. Thought I'd check since I have to use Access here and had Office Pro loaded. [link\|mailto:jbrabeck@attbi.com\|Joe]
Post #100,767 by orion 5/7/03 3:28:52 PM Reply	Maybe they didn't install it? I thought that Access came as part of Office Pro, but maybe they did a custom install and didn't install it? *"If you're going to cheat, cheat fair. If there's anything I hate it's a crooked crook!" -Moe Howard*
Post #100,837 by mmoffitt 5/8/03 12:58:17 AM Reply	I know I'm gonna get flame for this. But, you might try MSDE (same Sql engine as MS Sql Server, but limited to 5 concurrent connections and 2 Gig databases). [link\|http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp\|MSDE 2000 Info] The advantage to using MSDE is that the databases that you create are 100% compatible (i.e. you can "detachdb" and "attachdb" the databases to a full-blown Sql Server install w/out modifying anything in the database). So, if you know you're going to have to eventually use the full-blown MS Sql Server product, none of your work will be lost. And, MSDE is free. bcnu, Mikem The soul and substance of what customarily ranks as patriotism is moral cowardice and always has been...We have thrown away the most valuable asset we had-- the individual's right to oppose both flag and country when he (just he, by himself) believed them to be in the wrong. We have thrown it away; and with it all that was really respectable about that grotesque and laughable word, Patriotism. - Mark Twain, "Monarchical and Republican Patriotism"
Post #100,873 by inthane-chan 5/8/03 8:47:35 AM Reply	(It's also the same codebase as SQL Server) With the caveat that you have to patch it with the same patches, otherwise... Worms suck. After 9/11, Bush made two statements: 1. "Terrorists hate America because America is a land of freedom and opportunity." 2. "We intend to attack the root causes of terrorism." Sounds like everything is going according to plan.
Post #100,929 by pwhysall 5/8/03 12:58:16 PM Reply	Other limitations 2G max database size. Max 5 connections. No tools whatsoever. 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 #101,018 by mmoffitt 5/8/03 10:46:29 PM Reply	Picky. You don't like writing Sql scripts by hand? I should have mentioned that. I guess I left it off because I've had Enterprise Manager already installed for other servers. bcnu, Mikem The soul and substance of what customarily ranks as patriotism is moral cowardice and always has been...We have thrown away the most valuable asset we had-- the individual's right to oppose both flag and country when he (just he, by himself) believed them to be in the wrong. We have thrown it away; and with it all that was really respectable about that grotesque and laughable word, Patriotism. - Mark Twain, "Monarchical and Republican Patriotism"
Post #101,162 by orion 5/9/03 8:02:51 PM Reply	It can make a big difference as Enterprise manager can find your mistakes, and writing a SQL Script by hand more than likely won't until you go to run it. Typos and things like that. It can be done by hand, or even Visual BASIC 6.0 has some SQL Server tools in it. Which is why MSDE 2000 has a license for use with VIsual Studio 6.0 because of the SQL Tools in it. Still maybe FIrebird has an IDE Interface for it somewhere? I haven't found one yet, I downloaded the Firebird database, but I hadn't had time to figure it out yet without some GUI to guide me. I need error checking to work out my typos. *"If you're going to cheat, cheat fair. If there's anything I hate it's a crooked crook!" -Moe Howard*
Post #101,164 by tjsinclair 5/9/03 8:42:42 PM Reply	OOo has some basic DB connection/query tools Supports ODBC, JDBC connections. I haven't tried it on Windows, though. Tom Sinclair "Man, I love it when the complete absence of a plan comes together." - [link\|http://radio.weblogs.com/0104634/\|Ernie the Attorney]
Post #101,179 by orion 5/9/03 11:31:24 PM Reply	Is that OO as in Open Office? Otherwise I am not sure what you are talking about? *"If you're going to cheat, cheat fair. If there's anything I hate it's a crooked crook!" -Moe Howard*
Post #101,191 by tjsinclair 5/10/03 1:22:51 AM Reply	Indeed it is OpenOffice.org Sorry, I guess I was trying to be all hacker-y and elite. (or should I say L33T!) Tom Sinclair "Man, I love it when the complete absence of a plan comes together." - [link\|http://radio.weblogs.com/0104634/\|Ernie the Attorney]
Post #101,229 by deSitter 5/10/03 7:24:57 PM Reply	Re: Indeed it is OpenOffice.org Sorry, I guess I was trying to be all hacker-y and elite. (or should I say L33T!) Thank you for remaining among the non-idiots. BTW OpenOffice is not bad, from a cursory first inspection. It handles Word 97 documents pretty well. A major drawback for me is that the vaunted Linux still mostly has extremely shitty applications, in particular, the equation editors are horrible (I utterly refuse to deal with something as insane as TeX). -drl
Post #100,940 by orion 5/8/03 2:22:56 PM Reply	MSDE 2000 is on the Office XP Pro CD in the \\MSDE\\ directory. Only disadvantage is that you don't have Enterprise Manager to administer it unless you also have the SQL Server 2000 CD to load it with as part of the client and administrator tools. *"If you're going to cheat, cheat fair. If there's anything I hate it's a crooked crook!" -Moe Howard*
Post #101,169 by boxley 5/9/03 10:10:43 PM Reply	using mysql because the tutorial was a great refresher for db's which I havnt touched much in the past couple of years and the firebird product docs in the download were prety iffy. thanx, bill will work for cash and other incentives [link\|http://home.tampabay.rr.com/boxley/resume/Resume.html\|skill set] questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org] Carpe Dieu
Post #101,416 by CRConrad 5/12/03 9:03:08 AM Reply	Hmmm... You really sure it beats all you can find... ...on the [link\|http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_document\|IBPhoenix Documentation] and [link\|http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download\|Download pages]? Or the [link\|http://firebird.sourceforge.net/index.php?op=doc\|Firebird Documentation page], particularly the [link\|http://firebird.sourceforge.net/index.php?op=doc&id=userdoc\|User Documentation]? Sounds like a pretty bad reason to choose a product, anyway: "I got the Yugo in stead of the Volvo, because it has such a good general driving handbook, and I haven't been on the roads for a while..." So why not read the Yugo general driving handbook (=SQL tutorial) -- and drive the Volvo anyway? If nothing else, one would think IBPhoenix' 25-page [link\|http://www.ibphoenix.com/downloads/qsg.pdf\|Firebird Quick Start Guide] .PDF should suffice pretty well, for an experienced guy like you... (Heck, if you want, I'll go down in the basement and see if I still have my old InterBase 4.2 paper manuals down there somewhere! :-) [link\|mailto:MyUserId@MyISP.CountryCode\|Christian R. Conrad] (I live in Finland, and my e-mail in-box is at the Saunalahti company.) Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link\|http://z.iwethey.org/forums/render/content/show?contentid=71575\|Ashton Brown]
Post #101,619 by boxley 5/13/03 9:05:09 AM Reply	for screaming in a hurry it works for me but will be downloading the firebird workbench as soon as I get the feelings in my wrist and fingers back. I have been doing more typing in the last week than the last 5 years. thanx, bill will work for cash and other incentives [link\|http://home.tampabay.rr.com/boxley/resume/Resume.html\|skill set] questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org] Carpe Dieu
Post #101,421 by deSitter 5/12/03 9:23:48 AM Reply	Why not postgres? I think Scott detailed some time ago why is was better than mySQL. I don't remember how the argument went, because I didn't really understand all of it. Again, the inferior solution wins. It's downright amazing. Box, if you turn into a Doobian, I'll jump off the Eads Bridge :) -drl
Post #101,423 by pwhysall 5/12/03 9:35:03 AM Reply	"Wins"? "wins" for suitable values of "powers a lot of weblogs", more like. 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]

Welcome to IWETHEY!