SQLServerCentral.com Articles tagged Oracle

Using Regular Expressions to Convert PL/SQL code to T-SQL

Fri, 19 Apr 2013 06:00:00 UT

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.

Free Webinar: Statistics in Oracle and SQL Server

Tue, 22 Jan 2013 07:00:00 UT

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.

Free Webinar: Statistics in Oracle and SQL Server

Tue, 22 Jan 2013 07:00:00 UT

Free Webinar: Statistics in Oracle and SQL Server

Tue, 22 Jan 2013 07:00:00 UT

Free Webinar: Statistics in Oracle and SQL Server

Tue, 22 Jan 2013 07:00:00 UT

Temporary Tables in Oracle and SQL Server

Mon, 08 Oct 2012 06:00:00 UT

Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Temporary Tables in Oracle and SQL Server

Mon, 08 Oct 2012 06:00:00 UT

Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables.

Run an Oracle package from SQL Server Integration Services

Tue, 18 Sep 2012 06:00:00 UT

If you want to run an Oracle Package and then execute a web service, copy files or folders, a sequence of tasks, you may need to use SQL Server Integration Services (SSIS).

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

An Overview of Memory Architecture - Oracle for the SQL Server Guy

Mon, 13 Feb 2012 07:00:00 UT

A look at the memory architecture of SQL Server and Oracle, for those of you that may need to provide support for Oracle databases.

Using Regular Expressions to Convert PL/SQL code to T-SQL

Fri, 19 Apr 2013 06:00:00 UT

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.

Using SQL Server to collect information from your Oracle server

Mon, 06 Jun 2011 06:00:00 UT

Using linked connections you can collect system information on your Oracle server from SQL server.

Mid October Free Training from PASS Virtual Chapters

Wed, 20 Oct 2010 06:00:00 UT

More free training this month from PASS B/I, PowerShell, and Oracle Virtual Chapters.

Oracle to SQL Server, Crossing the Great Divide, Part 3

Fri, 23 Jul 2010 06:00:00 UT

We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.

Oracle to SQL Server: Crossing the Great Divide, Part 1

Mon, 10 May 2010 06:00:00 UT

When a SQL expert moves from Oracle to SQL Server, he can spot obvious strengths and weaknesses in the product that are too familiar to be apparent to the SQL Server DBA. Jonathan Lewis is one such expert: In this article he records his train of thought whilst investigating the mechanics of the SQL Server database engine. The result makes interesting reading.

SQL Server Management Features vs Oracle Database Management Features

Thu, 06 May 2010 06:00:00 UT

The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service.

A High Level Comparison Between Oracle and SQL Server - Part IV

Fri, 02 Apr 2010 06:00:00 UT

The concluding part of the Oracle / SQL Server comparison looks at error logging, security, installation and finally querying the databases.

A High Level Comparison Between Oracle and SQL Server - Part III

Tue, 30 Mar 2010 06:00:00 UT

Part III of the Oracle / SQL Server comparison looks at the configuration options for each database, their storage options as well as the startup and shutdown procedures.

A High Level Comparison Between Oracle and SQL Server - Part II

Fri, 26 Mar 2010 06:00:00 UT

Part II or the Oracle / SQL Server comparison dives deeper into databases by exploring the architectural differences.

A High Level Comparison Between Oracle and SQL Server

Thu, 25 Mar 2010 06:00:00 UT

Part I of the Oracle / SQL Server comparison looks at the various editions of each database and their structure.

Querying Oracle from Powershell Part 1

Thu, 04 Mar 2010 07:00:00 UT

In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...

Querying Oracle from Powershell Part 2

Thu, 04 Mar 2010 07:00:00 UT

In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...

Oracle: Overhaul or Overkill?

Mon, 22 Feb 2010 07:00:00 UT

Vendor-specific hardware might make Oracle less painful to use in the future, so Chris Massey considers whether Microsoft should consider providing a more tailored and complete product with SQL Server. The verdict? "Not necessary".

Did Oracle buy MySQL by accident?

Mon, 17 Aug 2009 06:00:00 UT

The wording of the statement about MySQL that came out from Oracle after the merger was downbeat. The implication was "Oh no! Another Blooming Database to deal with". But surely they don't plan to just let it drift?

Oracle for the SQL Server Guy - Instances and Databases

Thu, 02 Jul 2009 06:00:00 UT

Many DBAs need to work with multiple platforms. New author Jagan Kumar brings us an article that helps to explain Oracle's architecture for those people used to working with SQL Server.

Connecting Oracle BI Publisher to SQL Server

Mon, 30 Mar 2009 06:00:00 UT

One of the main features of Oracle Business Intelligence Publisher (BIP) is its ability to connect to pretty much every major RDBMS on the market. Steve Callan shares the little documented steps of how to establish a connection to SQL Server.

White Paper: SQL Server 2008 Compared to Oracle Database 11g

Thu, 19 Jun 2008 06:00:00 UT

Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.