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

Importing data from Excel to SQL Server requires going back in time, so to speak. Yes, back to 32-bits at runtime. As much as it can be a pain, a lot of projects still require that you import data ...

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

Brien M. Posey is a freelance technical writer who has contributed to dozens of books and is a six-time Microsoft MVP award winner. Many IT professionals live by the maxim that if something isn’t ...

On August 30, Microsoft announced the public preview of the Azure Database Migration Service (DMS) to support online migrations of various databases to Azure. What’s an “online migration”? Online ...