Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Oracle Rss

Search for any content tagged oracle

<< Newer    Items 21 to 37 of 37   
 

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

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.  Read more...
By P. Praveena 2013/04/19 (first published: 2011/10/11) | Source: SQLServerCentral.com | Category: regular expressions
Rating: |  Discuss |   Briefcase | 9,579 reads

Using SQL Server to collect information from your Oracle server

Using linked connections you can collect system information on your Oracle server from SQL server.  Read more...
By Rudy Panigas 2011/06/06 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,405 reads

Mid October Free Training from PASS Virtual Chapters

More free training this month from PASS B/I, PowerShell, and Oracle Virtual Chapters.  Read more...
By Aaron Nelson 2010/10/20 | Source: SQLServerCentral.com | Category: free training
Rating: |  Discuss |   Briefcase | 693 reads

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

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.  Read more...
By Additional Articles 2010/07/23 | Source: SimpleTalk | Category: migration
Rating:  Rate this |   Briefcase | 3,109 reads

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

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.  Read more...
By Additional Articles 2010/05/10 | Source: SimpleTalk | Category: oracle
Rating:  Rate this |   Briefcase | 3,541 reads

SQL Server Management Features vs Oracle Database Management Features

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.  Read more...
By Additional Articles 2010/05/06 | Source: Database Journal | Category: management
Rating:  Rate this |   Briefcase | 3,402 reads

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

The concluding part of the Oracle / SQL Server comparison looks at error logging, security, installation and finally querying the databases.  Read more...
By Additional Articles 2010/04/02 | Source: SQL Server Performance | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 3,568 reads

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

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.   Read more...
By Additional Articles 2010/03/30 | Source: SQL Server Performance | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,073 reads

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

Part II or the Oracle / SQL Server comparison dives deeper into databases by exploring the architectural differences.   Read more...
By Additional Articles 2010/03/26 | Source: SQL Server Performance | Category: sql server
Rating:  Rate this |   Briefcase | 4,673 reads

A High Level Comparison Between Oracle and SQL Server

Part I of the Oracle / SQL Server comparison looks at the various editions of each database and their structure.  Read more...
By Additional Articles 2010/03/25 | Source: SQL Server Performance | Category: oracle
Rating:  Rate this |   Briefcase | 6,227 reads

Querying Oracle from Powershell Part 1

In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...  Read more...
By Chad Miller 2010/03/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,519 reads

Querying Oracle from Powershell Part 2

In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...  Read more...
By Chad Miller 2010/03/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,061 reads

Oracle: Overhaul or Overkill?

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".  Read more...
By Chris Massey 2010/02/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 110 reads

Did Oracle buy MySQL by accident?

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?  Read more...
By Tony Davis 2009/08/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 166 reads

Oracle for the SQL Server Guy - Instances and Databases

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.  Read more...
By Jagan Kumar 2009/07/02 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 9,454 reads

Connecting Oracle BI Publisher to SQL Server

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.  Read more...
By Additional Articles 2009/03/30 | Source: Database Journal | Category: business intelligence
Rating: (not yet rated)  Rate this |   Briefcase | 1,744 reads

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

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.  Read more...
By Additional Articles 2008/06/19 | Source: Microsoft MSDN | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,930 reads
<< Newer    Items 21 to 37 of 37