SQL Server and Oracle Comparison

Learn about the similarities and differences of backing up a database in SQL Server versus Oracle.

In this article, we look at how to setup a file watcher process for SQL Server or Oracle to alert you when new files arrive in a folder.

In this article, we look at how to get historical performance stats for queries for both SQL Server and Oracle.

Learn how to query cached query statistics and execution plans for Oracle or SQL Server to identify code that can be optimized to improve performance.

Learn how to query lock information for both Oracle and SQL Server along with sample scripts and descriptions of each query element.

This article is a comparison of how to perform ETL tasks in an Oracle environment using ODI versus a SQL Server environment using SSIS.

Learn how to script database objects and data from Oracle using SQL Developer and SQL Server using SQL Server Management Studio.

In this tip, we will run several tests using different numbers of data files for SQL Server and Oracle databases to see if more files improves the per

In this article, we look at how to automatically handle scheduled jobs that hang in both SQL Server and Oracle.

In this article, we look at how to set up Transparent Data Encryption for SQL Server and Oracle along with the differences and similarities.

Learn how to set up Machine Learning for SQL Server and Oracle as well as perform sentiment analysis using R in both database platforms.

Learn how to bulk load data into SQL Server and Oracle using Bulk Copy Program (BCP) and SQL*Loader (SQLLDR).

In this article we look at some of the similarities and differences between creating a new database for Oracle versus SQL Server.

In this article we look at how to install SQL Server and Oracle using PowerShell to create development environments using Windows Containers.

In this final tip of this series we look at migrating the actual data from Oracle to SQL Server using the SSMA for Oracle tool.

In this part of the series we look at how to use the SQL Server Migration Assistant for Oracle to create database objects in the target SQL Server database.

In this second part of this series we look at how to convert database objects from Oracle to SQL Server using the SQL Server Migration Assistant for Oracle.

In this series of articles we will walk through how to migrate an Oracle database to SQL Server using the SQL Server Migration Assistant for Oracle tool.

In this tip we look at how to install the SQL Server Migration Assistant for Oracle Extension Pack.

In this tip we look at how to install the SQL Server Migration Assistant for Oracle.

In a prior tip we looked at using Linked Servers to transfer data between SQL Server and Oracle. Transferring data to Oracle from SQL Server was really slow and this tip shows a faster approach.

In this tip we look at how to transfer data between SQL Server and Oracle using a linked server.

Read these step-by-step instructions for installing an Oracle database server and setting up a SQL Server linked server that can query the data within the Oracle database server.

In Part - I of this tip series, we saw how to create a SQL Server Linked Server to Oracle and pull tablespace information into a SQL Server database table through a SQL Server Agent Job. In this tip we will create an SQL Server Reporting Services (SSRS)