In this tip, Daniel Calbimonte compares the SQL Server (T-SQL) and Oracle (PL-SQL) extensions of the SQL language. The tip will compare both T-SQL and PL-SQL languages with respect to retrieving data, creating databases, tables, variables, etc.
2015-06-22
4,457 reads
On January 28th 3PM GMT, Randolf Geist will present a free, one-hour webinar analyzing different database query profiles based on a real-world customer case. He'll also look at how these different profiles influence the efficiency of Exadata's features and the new Oracle In-Memory column store option. Register now.
2015-01-23
8,371 reads
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.
2013-01-22 (first published: 2013-01-08)
2,675 reads
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).
2012-09-18
2,524 reads
A look at the memory architecture of SQL Server and Oracle, for those of you that may need to provide support for Oracle databases.
2012-02-13
4,139 reads
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.
2010-05-10
3,704 reads
The concluding part of the Oracle / SQL Server comparison looks at error logging, security, installation and finally querying the databases.
2010-04-02
3,828 reads
Part I of the Oracle / SQL Server comparison looks at the various editions of each database and their structure.
2010-03-25
6,514 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers