Casper Posted October 25, 2011 Report Share Posted October 25, 2011 www.dbainspace.com Quote Link to comment Share on other sites More sharing options...
Jst2fst Posted October 25, 2011 Report Share Posted October 25, 2011 This would be pretty interesting to do. Quote Link to comment Share on other sites More sharing options...
redbarron77 Posted October 25, 2011 Report Share Posted October 25, 2011 damn sql server related questions..... Quote Link to comment Share on other sites More sharing options...
r1crusher Posted October 25, 2011 Report Share Posted October 25, 2011 It's only SQL for crying out loud! It's not like it's Oracle! LOL! Quote Link to comment Share on other sites More sharing options...
RVTPilot Posted October 25, 2011 Report Share Posted October 25, 2011 select * where dba = astronaut Quote Link to comment Share on other sites More sharing options...
Casper Posted October 25, 2011 Author Report Share Posted October 25, 2011 select * where dba = astronautFunny. I was thinking something similar. Quote Link to comment Share on other sites More sharing options...
Casper Posted October 25, 2011 Author Report Share Posted October 25, 2011 damn sql server related questions.....It's only SQL for crying out loud! It's not like it's Oracle! LOL! Me's thinks R1 doesn't know what Red does for a living. Quote Link to comment Share on other sites More sharing options...
Scruit Posted October 25, 2011 Report Share Posted October 25, 2011 Bitch please.select dba from company into spaceship where name = 'Scruit'; 1 Quote Link to comment Share on other sites More sharing options...
RVTPilot Posted October 25, 2011 Report Share Posted October 25, 2011 Bitch please.select dba from company into spaceship where name = 'Scruit';I just ran that on one of our servers. Are you in space yet? Quote Link to comment Share on other sites More sharing options...
Scruit Posted October 26, 2011 Report Share Posted October 26, 2011 Didn't seem to work. Did you get any error messages? Probable a firewall issue. Quote Link to comment Share on other sites More sharing options...
RVTPilot Posted October 26, 2011 Report Share Posted October 26, 2011 Didn't seem to work. Did you get any error messages? Probable a firewall issue.Dammit. No errors. Let me check the logs. Quote Link to comment Share on other sites More sharing options...
max power Posted October 26, 2011 Report Share Posted October 26, 2011 Me's thinks R1 doesn't know what Red does for a living. We all know what Red does for a living. He cruises porn sites for OR. He's on the payroll. Quote Link to comment Share on other sites More sharing options...
jporter12 Posted October 26, 2011 Report Share Posted October 26, 2011 Too much nerd in this thread for us mere mortals. Quote Link to comment Share on other sites More sharing options...
redbarron77 Posted October 26, 2011 Report Share Posted October 26, 2011 Pr0n is my calling in life, to pay the bills, I do the IT thing....for almost 22 years, 20 of it as an Oracle DBA, and have played around on SQL Server, MySql, etc....but for some odd reason I have found folks pay more for a good Oracle DBA. And since I have a personality, and can talk to non-technical folks in such a way they can understand technical issues, they keep me around.Then Casper sends me this DBA in Space, and the damn questions are using RedGate's damn management software on a SQLServer database....bastages.... Quote Link to comment Share on other sites More sharing options...
Scruit Posted October 26, 2011 Report Share Posted October 26, 2011 I cut my teeth on FridayForm (older than the internet - I can't find proof it ever existed?) and then moved up to Delta. My first summer job was developing a relational database for BS5750 compliance (precursor to iso9000) for a company that made pressure vessels. I was 16, and yes, they got their certification.I passed through MS Access like a White Castle Slider (spending less than a year of my professional life on it, yuck). Now I work SQLServer and Mysql. Mostly mysql these days. I have used every type of database out there (oracle, postgres, db2, sybase etc) but only been a DBA for SQLServer and Mysql.So it's been about 21 years since my first DBA job. Wow I feel old now. Quote Link to comment Share on other sites More sharing options...
Scruit Posted October 26, 2011 Report Share Posted October 26, 2011 (edited) but for some odd reason I have found folks pay more for a good Oracle DBA.Surprised they have any money left to pay the DBAs after they pay the Oracle bill... Edited October 26, 2011 by Scruit Quote Link to comment Share on other sites More sharing options...
r1crusher Posted October 26, 2011 Report Share Posted October 26, 2011 Bitch please.select dba from company into spaceship where name = 'Scruit';You missing something.....CREATE TABLE spaceship(name char(50),launch_date date)Then we can see who's going up when...select * from spaceship where name = '<astronauts_name>' order by launch_dateAnd I bet there's a good bit I could learn from Red. In my line of work our clients could be using M$SQL or Oracle for the back end DBs. And if the clients are doing multisite implementations they have to use Oracle for the DB replication (that's the only one that's supported for now). Got any experience with replicated instances Red? LOL! Quote Link to comment Share on other sites More sharing options...
r1crusher Posted October 26, 2011 Report Share Posted October 26, 2011 surprised they have any money left to pay the dbas after they pay the oracle bill... qft!!!! Quote Link to comment Share on other sites More sharing options...
redbarron77 Posted October 26, 2011 Report Share Posted October 26, 2011 Scruit is very correct, Oracle's pricing is expensive. This is why so many people are going with SQL Server and MySQL, even with "lesser" performance.As far as replication via Oracle, I'll give the patented Oracle answer, "it depends". Dataguard is one of the simplest forms of data replication, but most folks use streams to facilitate replication of data. Anyone can ask Casper, I am the laziest person in existence(except for Pr0n). How can you define me as lazy? i.e. - Question - What is the definition of a lazy white boy? Answer - A man who marries a woman who is already pregnant! Both times I've been married, both of my wives already had kids, so that makes me the "Laziest White Man" in history!Ok, back to the replication issue....if you are licensed for it, dataguard is the way to go. Under 11g, use OEM(aka GRID) to create a physical standby via archivelog shipping. Under 10g, OEM was flaky for dataguard creation, I have some instructions that might be able to help you. Anything earlier, and streams are your main choice, or use the RMAN duplicate on a periodic basis.Feel free to shoot me email/questions at either redbarron77@yahoo.com or Mr.Ed@tamu.edu. I'm really damn good with Oracle, but I will never say I am an expert. Don't have all the answers, but I have quite a few of 'em! Quote Link to comment Share on other sites More sharing options...
r1crusher Posted October 26, 2011 Report Share Posted October 26, 2011 Thanks for the offer Red. I might take you up on it in the future.With what we install and configure using Oracle the distributed multimaster method is always used. No streams or dataguard, just advanced replication. I have a stack of Don Burleson authored Rampant books that I reference more often than I like but they've been very handy. We have written some code and we sell a service for replicated environment remediation. Too many times we've seen database inconsistencies between sites and we never have a good way to fix those problems (short of removing the site and recreating it ). Once we dug into it we found there are some internal procedures that can fix things, but there's always a catch. For us it's the use of LOB objects in some tables....total pain in the ass to deal with. Then you can have package and package bodies that get corrupt or the stupid DBMS jobs fail for some reason and they clients don't know to restart the job and there's 20k transactions pending....uuhhhgg.Such is my life. But I'm start in on learning SharePoint and thusly that comes jam packed with a M$SQL backend. Yippie!And I have some really good stories about Oracle implementations, Oracles "DBAs", and the costs associated. Quote Link to comment Share on other sites More sharing options...
Casper Posted October 26, 2011 Author Report Share Posted October 26, 2011 We all know what Red does for a living. He cruises porn sites for OR. He's on the payroll. He should be on the payroll. And if the clients are doing multisite implementations they have to use Oracle for the DB replication (that's the only one that's supported for now). Got any experience with replicated instances Red? LOL! If old Ed can't help, I can. Replication, clustering, DR, and heterogeneous integrations are kinda my specialties. That goes for Oracle, MS SQL, and MySQL. I'm a high safety high availability guru. Anyone can ask Casper, I am the laziest person in existence(except for Pr0n). How can you define me as lazy? i.e. - Question - What is the definition of a lazy white boy? Answer - A man who marries a woman who is already pregnant! Both times I've been married, both of my wives already had kids, so that makes me the "Laziest White Man" in history! The only person I've ever met so lazy that he actually created an environment alias l="ls -al". Quote Link to comment Share on other sites More sharing options...
Casper Posted October 26, 2011 Author Report Share Posted October 26, 2011 Thanks for the offer Red. I might take you up on it in the future.With what we install and configure using Oracle the distributed multimaster method is always used. No streams or dataguard, just advanced replication. I have a stack of Don Burleson authored Rampant books that I reference more often than I like but they've been very handy. We have written some code and we sell a service for replicated environment remediation. Too many times we've seen database inconsistencies between sites and we never have a good way to fix those problems (short of removing the site and recreating it ). Once we dug into it we found there are some internal procedures that can fix things, but there's always a catch. For us it's the use of LOB objects in some tables....total pain in the ass to deal with. Then you can have package and package bodies that get corrupt or the stupid DBMS jobs fail for some reason and they clients don't know to restart the job and there's 20k transactions pending....uuhhhgg.Such is my life. But I'm start in on learning SharePoint and thusly that comes jam packed with a M$SQL backend. Yippie!And I have some really good stories about Oracle implementations, Oracles "DBAs", and the costs associated. Multimaster eh? For load balancing or for mobile databases? Quote Link to comment Share on other sites More sharing options...
r1crusher Posted October 26, 2011 Report Share Posted October 26, 2011 Multimaster eh? For load balancing or for mobile databases?Neither, strictly just to have the data in two places for speed and accessibility needs of different geographical locations. Back when long distance network connections were stupid expensive and slow this was their solution. Put a copy of the database local to each place that needed it. Quote Link to comment Share on other sites More sharing options...
r1crusher Posted October 26, 2011 Report Share Posted October 26, 2011 And on top of the database replication we have to deal with vault (aka file) replication to boot. Quote Link to comment Share on other sites More sharing options...
Casper Posted October 26, 2011 Author Report Share Posted October 26, 2011 Neither, strictly just to have the data in two places for speed and accessibility needs of different geographical locations. Back when long distance network connections were stupid expensive and slow this was their solution. Put a copy of the database local to each place that needed it. Ah. Are they looking to move away from that setup or continue using it that way?And on top of the database replication we have to deal with vault (aka file) replication to boot. Vault as in Autodesk Vault? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.