You must watch out for many subtle and not-so-subtle traps when translating Oracle queries to SQL Server. Just as T-SQL is the language engine of SQL Server, PLSQL is that of Oracle. Both these ...

Embarcadero Technologies has released a new version of its database change management software. Change Manager 5.1 helps DBAs and developers by automating complex database change management tasks, ...

If you’re building a Microsoft .NET network and you have an Oracle database, you should migrate it to SQL Server. It is not a question of which is better but of which one is the right tool for you. In ...

We have Great Plains running on MSSQL 2K. The Powers That Be have decided it would be a good thing to have an automated system in place to do automatic updates of corresponding tables in our main ...

Last week was quite the week for Microsoft -- Visual Studio integration with Eclipse, and then the big announcement that SQL Server is coming to a Linux operating system near you shortly. The cool ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server. The data won't be modified or changed ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...