DB Best blog

In Oracle, you can write a SELECT statement with aggregate functions (like MAX, MIN or AVG) over a partitioned query result set and specify how data are ordered within a partition. Such queries have the following format:
SELECT column_list,
Aggr_fun(column_name) OVER (PARTITION BY column_name ORDER BY column_name)
AS alias_name
FROM table_name;

SQL Server allows selecting data using aggregate functions with [...]

In this article, I am going to cover the situation when REF CURSOR type is used in output parameter of a stored procedure. Often this method is chosen to return the result set from a procedure to an application. Still, in many cases, the cursor reference can be returned from the stored procedure to outer [...]

Here I will describe the migration of functions created as external C libraries in Oracle.  Usually these Oracle functions are defined as CREATE FUNCTION … AS external library … LANGUAGE C. The above statement publishes an external C library through a call specification.

The similar specification in SQL Server 2005/2008 can be written by means of [...]

As Oracle DBMS_PIPE mechanism has no direct equivalent in SQL Server, we should provide a method of emulating it. This article describes a possible approach to this task.

The DBMS_PIPE package allows two or more sessions in the same instance to communicate between each other. To do that, one user creates a Pipe. This pipe can [...]

When migrating Oracle tables to SQL Server, the problem of sequence conversion is one of the most common. Indeed, SQL Server does not have any object even distantly resembling an Oracle sequence, and some tradeoffs are inevitable when you make decisions about the mechanisms to implement its behavior in the target system.
In Oracle, a sequence [...]

In spite of the fact that Sybase Adaptive Server Anywhere and Sybase Adaptive Server Enterprise have many common features, the conversion of Sybase ASA to SQL Server 2005 can cause more problems than the conversion of Sybase ASE database to SQL Server. It depends on differences in SQL dialects, which SQL Sybase ASE and Sybase [...]