Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag oracle Rss

   Items 1 to 20 of 27    Older >>
 

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,500 reads

Free Webinar: Statistics in Oracle and SQL Server

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.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Red-Gate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,631 reads

Free Webinar: Statistics in Oracle and SQL Server

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.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Red-Gate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,631 reads

Free Webinar: Statistics in Oracle and SQL Server

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.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Red-Gate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,631 reads

Free Webinar: Statistics in Oracle and SQL Server

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.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Red-Gate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,631 reads

SSIS and Oracle All Your Non-options

Why do some things have to be so hard? I have been asking myself that question for the better part of...  Read more...
By Wesley Brown 2012/11/01 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,998 reads

Temporary Tables in Oracle and SQL Server

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.  Read more...
By Press Release 2012/10/08 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,897 reads

Temporary Tables in Oracle and SQL Server

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.  Read more...
By Press Release 2012/10/08 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,897 reads

Run an Oracle package from SQL Server Integration Services

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).  Read more...
By Additional Articles 2012/09/18 | Source: MSSQLTips.com | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 1,749 reads

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

A look at the memory architecture of SQL Server and Oracle, for those of you that may need to provide support for Oracle databases.  Read more...
By jagan_pillai 2012/02/13 | Source: SQLServerCentral.com | Category: oracle
Rating: |  Discuss |   Briefcase | 2,537 reads

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,500 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,363 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 | 691 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 | 2,890 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,362 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,184 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,385 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 | 3,917 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,546 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,099 reads
   Items 1 to 20 of 27    Older >>
 
Tags
sql server (5)    
blogs (3)    
powershell (3)    
database weekly (2)    
editorial (2)    
integration services (ssis) (2)    
webinar (2)    
bi (1)    
business intelligence (1)    
events (1)    
free training (1)    
instances (1)    
linked server (1)    
management (1)    
memory management (1)    
migration (1)    
monitoring (1)    
mysql (1)    
pl/sql (1)    
regular expressions (1)    
sql agent (1)    
sql server 2008 (1)    
statistics (1)    
temporary tables (1)    
t-sql (1)