As someone who started out as an Oracle DBA (15 years) and got a later job as an SQL Server DBA (now I do both), it's really one-way. The benefit of being an Oracle DBA is you learn TIGHT code (semicolons matter) and adherence to syntax (Microsoft plays fast and loose). The engines are completely different, however, and as Brent points out, they're only marginally comparable. For example, Views on Oracle are AWESOME. Not so much on SQL Server. Also REDO vs UNDO - HUGE difference! TOP vs ROWNUM. Transaction handling (explicit vs implicit COMMIT). And database nomenclature... but what's in a name? I'd hire an Oracle DBA into an SQL Server position, sure. I would be skeptical going the other way, however. To much to UNLEARN.
@mfreemany2k
2 ай бұрын
I moved from being an Oracle PL/SQL developer and performance tuner to being a SQL Server administrator and T-SQL developer. It took some time to get up to speed on the differences, but I became effective quickly. It took much longer to get really good at it. Some of that was the database differences for performance tuning and some was learning database administration. It depends on what specific tasks you'd want to hire an Oracle person to do in SQL Server. Performance Tuning is going to have a long learning curve. Writing code, not so much.
@BrentOzarUnlimited
2 ай бұрын
Yep!
@nickwilliams5579
3 ай бұрын
Nice hoodie....
@BrentOzarUnlimited
3 ай бұрын
Thanks! For somebody who lives in the desert, I have a surprising amount of hoodies, hahaha.
@derkami6722
4 ай бұрын
damn i saw the short before the whole vid... had a deja vu there
@AaronBuma
4 ай бұрын
Welcome to my neck of the woods! Enjoy the very rainy Junuary!
@BrentOzarUnlimited
3 ай бұрын
Thanks!
@francisopiyo2332
4 ай бұрын
does the postgres dev team you will be joining have a dedicated you tube handle. Something like what sqlbits and pass community do.
@BrentOzarUnlimited
3 ай бұрын
Not really - it's not a dedicated team. It's an open source project, so there are people all over the world involved in building Postgres.
Пікірлер: 10