Migrating from SQL Server to Oracle Series

In this series, SQL Server expert Joe Lax will be describing the steps he takes to learn Oracle database administration. Included are editorials, book reviews, and technical articles that chart his course. The content will develop along with Joe’s migration journey, so think of it as a continual work in progress.

In the last several years, I have built and expanded my career based on my knowledge of Microsoft SQL Server. However, I am in the process of learning more about the flagship product of Microsoft’s chief rival: Oracle.
Read on…

???

Oracle Has SQL Server Beat in Stored Procedure Programming
Oracle9i and SQL Server 2000 add enhancements to the standard SQL language that enable you to use the database to implement your business rules and processes?SQL Server with Transact-SQL and Oracle with PL/SQL. Find out why the Oracle database engine is better suited for this role.

Concurrency Handling in Oracle: Preventing Locked Data
SQL Server and Oracle each have very different methods for maintaining data constancy when accessed by concurrent users. Oracle maintains a snapshot of the data, which prevents queries from hanging without stooping to “dirty reads.” Find out how it works.

Storing Your Data in Oracle
Compared to SQL Server, Oracle allows a DBA to go much further under the hood to properly manage data space requirements. However, space allocation in Oracle is complicated. Joe Lax shows you how locally managed tablespaces can let the database engine make most of the decisions for you.

Oracle Basics: Querying an Oracle Database
Oracle’s SQL*Plus is no SQL Server Query Analyzer, but with a little practice you’ll get the hang of it. Joe Lax shows you how to survive your first Oracle query with your dignity intact.

Oracle Concepts: The Instance and the Database
The complexity of how information is stored and where it is retrieved from is hidden from the casual user who queries a database. But if you plan on administering Oracle, you need to become familiar with how Oracle handles both resources. In this article, Joe Lax discusses two basic, but important, concepts with regard to memory and disk?the “instance” and the “database.”

Joe Lax has spent the last 10 years working in various database environments and has been a practicing DBA on all versions of SQL Server from version 4.2 onward. Joe is also a MCSE and an MCT. Recently, he has started to learn Oracle, which affords him no end of fun. Reach him by e-mail .

Previous

Next

Share the Post:

GM Creates Open Source uProtocol and Invites Automakers to Adopt It: Revolutionizing Automotive Software Development.

June 2, 2023

General Motors (GM) recently announced its entry into the Eclipse Foundation. The Eclipse Foundation is a prominent open-source software foundation. In addition, GMC announced its contribution of “uProtocol” to facilitate

What is Metadata?

June 1, 2023

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

What We Should Expect from Cell Phone Tech in the Near Future

May 31, 2023

The earliest cell phones included boxy designs full of buttons and antennas, and they only made calls. Needless to say, we’ve come a long way from those classic brick phones

The Best Mechanical Keyboards For Programmers: Where To Find Them

May 29, 2023

When it comes to programming, a good mechanical keyboard can make all the difference. Naturally, you would want one of the best mechanical keyboards for programmers. But with so many

The Digital Panopticon: Is Big Brother Always Watching Us Online?

May 26, 2023

In the age of digital transformation, the internet has become a ubiquitous part of our lives. From socializing, shopping, and learning to more sensitive activities such as banking and healthcare,

Embracing Change: How AI Is Revolutionizing the Developer’s Role

May 25, 2023

The world of software development is changing drastically with the introduction of Artificial Intelligence and Machine Learning technologies. In the past, software developers were in charge of the entire development

The Benefits of Using XDR Solutions

May 24, 2023

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

How AI is Revolutionizing Fraud Detection

May 23, 2023

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

Companies Leading AI Innovation in 2023

May 22, 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several

Step-by-Step Guide to Properly Copyright Your Website

May 18, 2023

Creating a website is not easy, but protecting your website is equally important. Implementing copyright laws ensures that the substance of your website remains secure and sheltered. Copyrighting your website

Fivetran Pricing Explained

May 17, 2023

One of the biggest trends of the 21st century is the massive surge in analytics. Analytics is the process of utilizing data to drive future decision-making. With so much of

Kubernetes Logging: What You Need to Know

May 16, 2023

Kubernetes from Google is one of the most popular open-source and free container management solutions made to make managing and deploying applications easier. It has a solid architecture that makes

Show More