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 is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure but ...

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

Due to my background working with other major database platforms such as Oracle, MySQL, and PostgreSQL, I’ve long been an advocate for the SQL Server Migration Assistant (SSMA). This powerful and easy ...

Microsoft's SQL Server Migration Assistant lets you move your data and schema to different SQL Servers. Here's what you need to know about the tool. Image: Dilok/Adobe Stock The Microsoft SQL Server ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...