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 ...

Database replication is a valuable tool that allows companies availability and scalability with their data. To help support customers in this area, Dell is releasing version 8.6 of SharePlex, its ...

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 ...

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 ...

SQL Server leads the industry on security, performance, and price. And we want to prove to you that there is no equal. Move your Oracle databases to SQL Server and receive the necessary licenses of ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

OK, while I'm really bad about approving comments (mostly because the platform makes it so painful), I do want to answer a few of them here real quick. First and foremost because this is bothering me.

Moving your data from one device to another is a pain. It's enough of a pain that most software services these days offer some kind of data transfer tool when you set up your new device. Unfortunately ...

As an IT professional working for a small to mid-sized organization you are not only in charge of the servers, desktops, firewalls, routers, switches and mobile devices… you’re the chief, cook and ...