Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Migrating from SQL Server to Oracle Series

There are advantages to knowing more than one database development language. If you're familiar with Microsoft SQL Server, this is the spot to understand the reasons for adopting Oracle as your secondary language and to learn the steps to transfer your skills to Oracle.


advertisement
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 .


   
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date