September 18, 2011 at 10:01 am
Ninja's_RGR'us (9/18/2011)
Lynn Pettis (9/18/2011)
bitbucket-25253 (9/17/2011)
Ninja's_RGR'us (9/17/2011)
Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.Now all I know about Oracle is how to speel it (and barely at that).
How hard is it to pick it up on the spot? The job seems to range from installing, to configuring, perf tuning to HA on both platforms.
Sounds like a lot to pick on the spot without and excellent mentor or full 100% responsibility split.
Talk with Lynn Pettis and/or follow his blog here a SCC
http://www.sqlservercentral.com/blogs/lynnpettis/
By Lynn Pettis in SQL Musings from the Desert 08-26-2010 10:15 PM | Categories: Filed under: Oracle
More importantly, I am getting exposed to the “O” word, yes, Oracle, and will be working with both Oracle 8 and Oracle 10.
And more importantly that I am now BACK in the SQL Server world. Oracle is the dark side, things we can easily do in SQL Server are not that easily done over there. Not only that the Oracle community for the most part is very stingy with their knowledge. It is nothing like the SQL Server community where we welcome the opportunity to share our knowledge and experience with others.
Here I'm assuming that I'll be working side by side with at least 1 other oracle DBA. So my assumption is that I have someone to fall back on & to teach me the basics.
With that in mind, is it on the not too utopic side of things?
Here I will say I hope so. The DBAs at Honeywell were of no real use helping me learn Oracle as a developer. In fact I don't think they would have recognized good code from bad code if they even had looked at the code.
And perhaps some of it is cultural, but as I wrote SQL and PL/SQL it seemed to me that in many respects that SQL Server got it right in comparision to how you had to do things in Oracle. There are things that are easy to accomplish in SQL Server that you actually need to jump through some extra hoops to accomplish in Oracle.
As a developer I did find simularities that allowed me to figure out what I wanted to do thinking in SQL Server, but then having to figure out how to convert it to work in Oracle. I couldn't quite make the complete mental shift to Oracle Think.
September 18, 2011 at 11:21 am
Tom.Thomson (9/17/2011)
SQL Kiwi (9/17/2011)
SQLRNNR (9/17/2011)
I was fully expecting to see this thread over 30,000 by this time.Shouldn't it be Cirque Du SQLeil?
No doubt it's been mentioned before...it just always jars my brain a bit when I see it in your signature.
Yes, come on Jason - admit that the only reasonm you changed the U to an E was so that we wouldn't find your picture here.
Well, in my younger days - I was that model.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 18, 2011 at 11:23 am
Tom.Thomson (9/17/2011)
Lynn Pettis (9/17/2011)
We are getting close. Who will be the lucky winner making the 30,000 post to The Thread???Out of date Lynn, we are now going to start not counting down to 40,000.
I think I have a script for that!! Not the countdown - the adhoc submitting of posts. Steve should have fun with that :hehe:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 18, 2011 at 11:26 am
Ninja's_RGR'us (9/17/2011)
Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.Now all I know about Oracle is how to speel it (and barely at that).
How hard is it to pick it up on the spot? The job seems to range from installing, to configuring, perf tuning to HA on both platforms.
Sounds like a lot to pick on the spot without and excellent mentor or full 100% responsibility split.
I think it depends on the person. I think you could pick up the SQL quickly, but the configuring/tuning,installing might be a different story.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 18, 2011 at 11:32 am
Lynn Pettis (9/18/2011)
bitbucket-25253 (9/17/2011)
Ninja's_RGR'us (9/17/2011)
Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.Now all I know about Oracle is how to speel it (and barely at that).
How hard is it to pick it up on the spot? The job seems to range from installing, to configuring, perf tuning to HA on both platforms.
Sounds like a lot to pick on the spot without and excellent mentor or full 100% responsibility split.
Talk with Lynn Pettis and/or follow his blog here a SCC
http://www.sqlservercentral.com/blogs/lynnpettis/
By Lynn Pettis in SQL Musings from the Desert 08-26-2010 10:15 PM | Categories: Filed under: Oracle
More importantly, I am getting exposed to the “O” word, yes, Oracle, and will be working with both Oracle 8 and Oracle 10.
And more importantly that I am now BACK in the SQL Server world. Oracle is the dark side, things we can easily do in SQL Server are not that easily done over there. Not only that the Oracle community for the most part is very stingy with their knowledge. It is nothing like the SQL Server community where we welcome the opportunity to share our knowledge and experience with others.
I think if I were given the chance to work with Oracle, I would have to obstruct that oracle community stinginess. I would blog much about what I did with that product - configs, tuning, etc etc etc.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 18, 2011 at 11:34 am
ALZDBA (9/18/2011)
Lynn Pettis (9/18/2011)
bitbucket-25253 (9/17/2011)
Ninja's_RGR'us (9/17/2011)
Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.Now all I know about Oracle is how to speel it (and barely at that).
How hard is it to pick it up on the spot? The job seems to range from installing, to configuring, perf tuning to HA on both platforms.
Sounds like a lot to pick on the spot without and excellent mentor or full 100% responsibility split.
Talk with Lynn Pettis and/or follow his blog here a SCC
http://www.sqlservercentral.com/blogs/lynnpettis/
By Lynn Pettis in SQL Musings from the Desert 08-26-2010 10:15 PM | Categories: Filed under: Oracle
More importantly, I am getting exposed to the “O” word, yes, Oracle, and will be working with both Oracle 8 and Oracle 10.
And more importantly that I am now BACK in the SQL Server world. Oracle is the dark side, things we can easily do in SQL Server are not that easily done over there. Not only that the Oracle community for the most part is very stingy with their knowledge. It is nothing like the SQL Server community where we welcome the opportunity to share our knowledge and experience with others.
IMO that tells more about the people than the engine of their concerns.
It's a cultural problem, just like the fact companies accept to spend more budget to that software to twist some nuts and bolts.
I love our community, but I'm jealous about that kind of easy budget !
Interesting choice of words. I was just thinking that Oracle had those companies by the nuts and bolts.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 18, 2011 at 11:35 am
GilaMonster (9/18/2011)
50 thread notifications since I went to bed....
Missed our goal by 250 then. Oh wait - that was Remi, Tom and Lynn carrying the load for us. I guess the rest of us need to do our part.
We need Alvin and Bob to chime in to help pick up the pace:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 18, 2011 at 11:38 am
SQLRNNR (9/18/2011)
GilaMonster (9/18/2011)
50 thread notifications since I went to bed....Missed our goal by 250 then. Oh wait - that was Remi, Tom and Lynn carrying the load for us. I guess the rest of us need to do our part.
We need Alvin and Bob to chime in to help pick up the pace:-D
And speaking of people who have been quiet of late, anybody heard from or talked to Barry Young?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 18, 2011 at 12:49 pm
SQLRNNR (9/18/2011)
Tom.Thomson (9/17/2011)
Lynn Pettis (9/17/2011)
We are getting close. Who will be the lucky winner making the 30,000 post to The Thread???Out of date Lynn, we are now going to start not counting down to 40,000.
I think I have a script for that!! Not the countdown - the adhoc submitting of posts. Steve should have fun with that :hehe:
Posting is easy (3 or 4 lines of code using CDO) and scheduling posts using say SQLAgent is also easy, but a good content generator is more difficult - how did you do that bit?
Tom
September 18, 2011 at 12:50 pm
SQLRNNR (9/18/2011)
GilaMonster (9/18/2011)
50 thread notifications since I went to bed....Missed our goal by 250 then. Oh wait - that was Remi, Tom and Lynn carrying the load for us. I guess the rest of us need to do our part.
We need Alvin and Bob to chime in to help pick up the pace:-D
Absolutely not!
September 18, 2011 at 12:50 pm
SQLRNNR (9/18/2011)
SQLRNNR (9/18/2011)
GilaMonster (9/18/2011)
50 thread notifications since I went to bed....Missed our goal by 250 then. Oh wait - that was Remi, Tom and Lynn carrying the load for us. I guess the rest of us need to do our part.
We need Alvin and Bob to chime in to help pick up the pace:-D
And speaking of people who have been quiet of late, anybody heard from or talked to Barry Young?
Quoted the wrong thread...
Absolutely not!
September 18, 2011 at 12:52 pm
SQLRNNR (9/18/2011)
Ninja's_RGR'us (9/17/2011)
Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.Now all I know about Oracle is how to speel it (and barely at that).
How hard is it to pick it up on the spot? The job seems to range from installing, to configuring, perf tuning to HA on both platforms.
Sounds like a lot to pick on the spot without and excellent mentor or full 100% responsibility split.
I think it depends on the person. I think you could pick up the SQL quickly, but the configuring/tuning,installing might be a different story.
Ya that's pretty much what I had in mind. If there's job for 5-10 dbas, why force all of them to be hybryd? I don't mind writing some code, but all the install / config seems like a lot to pickup on the spot for some urgent projects.
September 18, 2011 at 12:58 pm
For some general silliness...
CREATE DATABASE [Oops]
ON PRIMARY (
NAME = N'Oops', FILENAME = N'D:\Develop\Databases\Oops.txt:Data'
)
LOG ON (
NAME = N'Oops_log', FILENAME = N'D:\Develop\Databases\Oops.txt:Log'
)
GO
Data files, what data files? And where did the log go?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 18, 2011 at 1:06 pm
Tom.Thomson (9/18/2011)
SQLRNNR (9/18/2011)
Tom.Thomson (9/17/2011)
Lynn Pettis (9/17/2011)
We are getting close. Who will be the lucky winner making the 30,000 post to The Thread???Out of date Lynn, we are now going to start not counting down to 40,000.
I think I have a script for that!! Not the countdown - the adhoc submitting of posts. Steve should have fun with that :hehe:
Posting is easy (3 or 4 lines of code using CDO) and scheduling posts using say SQLAgent is also easy, but a good content generator is more difficult - how did you do that bit?
I have a table with 12 Cantos from Inferno. I use it for string generation (when I can't be bothered to haul out SQLDataGenerator). Would be weird, but consistently so.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 18, 2011 at 2:42 pm
SQLRNNR (9/18/2011)
ALZDBA (9/18/2011)
Lynn Pettis (9/18/2011)
bitbucket-25253 (9/17/2011)
Ninja's_RGR'us (9/17/2011)
Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.Now all I know about Oracle is how to speel it (and barely at that).
How hard is it to pick it up on the spot? The job seems to range from installing, to configuring, perf tuning to HA on both platforms.
Sounds like a lot to pick on the spot without and excellent mentor or full 100% responsibility split.
Talk with Lynn Pettis and/or follow his blog here a SCC
http://www.sqlservercentral.com/blogs/lynnpettis/
By Lynn Pettis in SQL Musings from the Desert 08-26-2010 10:15 PM | Categories: Filed under: Oracle
More importantly, I am getting exposed to the “O” word, yes, Oracle, and will be working with both Oracle 8 and Oracle 10.
And more importantly that I am now BACK in the SQL Server world. Oracle is the dark side, things we can easily do in SQL Server are not that easily done over there. Not only that the Oracle community for the most part is very stingy with their knowledge. It is nothing like the SQL Server community where we welcome the opportunity to share our knowledge and experience with others.
IMO that tells more about the people than the engine of their concerns.
It's a cultural problem, just like the fact companies accept to spend more budget to that software to twist some nuts and bolts.
I love our community, but I'm jealous about that kind of easy budget !
Interesting choice of words. I was just thinking that Oracle had those companies by the nuts and bolts.
😀
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 30,031 through 30,045 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply