SQL Server Data Dude

Jim Horn

Developer & Coffee Roaster

Scott Fell

programmer-analyst

Helena Marková

<div>
PP - Thanks for the book references, and I only threw in that line to prevent the Google Monkeys from posting. &nbsp; So far it seems to have worked. <br />
&nbsp; <br />
Raja - Thanks for the Oracle reference. <br />
&nbsp; <br />
Geert - Apparently, and I know as I have a wompload of SQL Server indexing, performance tuning, re-architecting, and technical debt cleanup work right in front of me. &nbsp; Also thanks for the Babylon reference, I may have to use that. <br />
<br />
As a side note every once in awhile somebody tells me I should take a foreign language, and my response is always 'I'm a 50 year old programmer, if I'm going to learn a foreign language it's going to be Oracle, Java, VB.NET, C#.NET, DAX. <br />
&nbsp; <br />
Scott - Thanks. &nbsp;I've already used the arguments 'So how much of a training period is management willing to accept for this to happen?' and 'So if you want me to double my skillsets does that mean you'll double my salary?'. &nbsp;Crickets chirping on both.
</div>


<div>
Splitting points across all helpful comments. &nbsp;<br />
<br />
Management never did clarify why they were asking this other then the desire to have us cross-train and call our own shots, and the effort eventually died due to lack of clarity + an inability to place this above my higher-priority tasks. <br />
<br />
Thanks all.<br />
Jim
</div>


<div>
At International Paper, we had one newly-hired Oracle DBA who was forced to split time 50/50 between SQL Server and Oracle, and he quit just because of that. &nbsp;Oracle DBAs tend to be <i>very</i> partial to Oracle, sometimes almost at a religious level. &nbsp;Although, now that Oracle is running ads touting &quot;<b>zero</b> DBAs&quot;, I wonder if they still feel the same way :).
</div>


<div>
<blockquote>
he quit just because of that.
</blockquote>
probably because he didn't want to waste time for all the things mssql can't do that oracle has built in
</div>


<div>
Yes, for some things. For MILLIONS AND MILLIONS more dollars. &nbsp;EVERY module is a new cost in Oracle.<br />
<br />
IP gave me a hard time because Oracle &quot;ran faster&quot; .... on a $2.5M grid machine. &nbsp;Prod SQL was on a $45K server. &nbsp;So I told them: give me ONE million dollars for a server, and it'll run as fast as your Oracle is now, what with all the inherent, forced overhead of rollback / &quot;snapshot&quot; processing (as SQL Server calls it). &nbsp;[Hopefully Oracle now has finally added a way to avoid ALWAYS having to copy ALL modified rows to rollback segments for EVERY table to satisfy the &quot;readers-dont-block-writer<wbr />s&quot; mantra.]<br />
<br />
At IP, it got to the point where NO developers would use Oracle for future tasks because the Ora development tools were so horrible. &nbsp;SQL got to equal Oracle usage. &nbsp;I was swamped, as the SINGLE SQL DBA, but they had SIX Oracle DBAs plus one part-time contractor. &nbsp;And they complained they were too busy!
</div>


<div>
only six ?<br />
i know places with 20 or more ... some managers get paid by the size of the crowd they manage<br />
intelligence is usually not something which is measured in places like that
</div>


<div>
&gt;&gt;I was swamped, as the SINGLE SQL DBA, but they had SIX Oracle DBAs plus one part-time contractor. <br />
<br />
Before multitenant:<br />
5 SQL Server databases != 5 Oracle databases
</div>


<div>
<blockquote>
Before multitenant:<br />
5 SQL Server databases != 5 Oracle databases
</blockquote>
<br />
No, esp. since an Oracle &quot;database&quot; = whole installation (as I already stated above).<br />
<br />
They did have a handful more Oracle installs, and yes, many of them had more transactions overall, but it was nothing like 6-1. &nbsp;We had SQL cluster and many other SQL instances. &nbsp;Far too many, because they had installs with only 2 or 3 small dbs. &nbsp;I also had to consolidate those into the cluster (with the ensuing fight about the users no longer being &quot;sysadmin&quot;s!).<br />
<br />
Oracle is (was?) just insanely expensive to install and maintain. &nbsp;So much so that now even Oracle itself is trying to say &quot;you don't need a DBA, we get it, we were way too complex!&quot;. &nbsp;Of course they'll never directly admit they're too expensive (just like IBM), but they're still showing they realize it.<br />
<br />
And their documentation was always horrendous, esp. compared to MS's. &nbsp;You gotta hand it to &quot;Books Online&quot; for being orders of magnitude better than any docs Oracle ever provided. &nbsp;You *always* had to go to 3rd party sources to get decent/understandable Oracle documentation.
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
I'm in a mixed group of SQL Server DBA's and developers and Oracle DBA's and developers from different business units that have only rarely interacted with each other in the past. &nbsp; Our upper management has given us a fuzzy directive to cross-train ourselves between Oracle and SQL Server, and for the most part everyone in the group is doing a twelve-way blank stare on what the expectations are. <br />
<br />
Question: &nbsp;Does anyone have any references to existing Oracle and SQL Server cross-training? &nbsp;Videos, published articles, blog posts.. <br />
<br />
This question is not..<br />
A request for info on which is the better database.<br />
An invitation for anyone to do a Google search and post the first thing that's returned, and then can't speak to it.<br />
<br />
Things I've stumbled across so far..<br />
PluralSight - <a href="https://www.pluralsight.com/courses/adv-sql-queries-oracle-sql-server" rel="ugc">Advanced SQL Queries in Oracle and SQL Server </a><br />
MVA - <a href="https://www.pluralsight.com/courses/adv-sql-queries-oracle-sql-server" rel="ugc">SQL Server 2016 Essentials for the Database Administrator</a><br />
Udemy - <a href="https://www.udemy.com/learn-data-migration-database-migration-ms-sql-to-oracle-db/" rel="ugc">Data Migration: Database Migration from MS SQL to Oracle DB</a><br />
<br />
Thanks in advance.<br />
Jim
</div>
</div>


Hi Experts

I'm in a mixed group of SQL Server DBA's and developers and Oracle DBA's and developers from different business units that have only rarely interacted with each other in the past.   Our upper management has given us a fuzzy directive to cross-train ourselves between Oracle and SQL Server, and for the most part everyone in the group is doing a twelve-way blank stare on what the expectations are. 

Question:  Does anyone have any references to existing Oracle and SQL Server cross-training?  Videos, published articles, blog posts.. 

This question is not..
A request for info on which is the better database.
An invitation for anyone to do a Google search and post the first thing that's returned, and then can't speak to it.

Things I've stumbled across so far..
PluralSight - Advanced SQL Queries in Oracle and SQL Server  (https://www.pluralsight.com/courses/adv-sql-queries-oracle-sql-server)
MVA - SQL Server 2016 Essentials for the Database Administrator (https://www.pluralsight.com/courses/adv-sql-queries-oracle-sql-server)
Udemy - Data Migration: Database Migration from MS SQL to Oracle DB (https://www.udemy.com/learn-data-migration-database-migration-ms-sql-to-oracle-db/)

Thanks in advance.
Jim

Cross-training in Oracle and SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.