As SQL Server 2008 and 2008 R2 reach the end of support in 2019, you’ll have an opportunity to upgrade to a cloud database service. Follow this step-by-step guide to manage change effectively as you ...

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 SQL Server version migrations are one of the more difficult activities for a DBA to execute, yet they are a very common change to the infrastructure. Databases eventually have to be migrated ...

My last couple of months have been filled with a major migration to Microsoft Azure for a client, who has both a very large data warehouse and an online transaction processing (OLTP) Web site. In all, ...

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

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...

My host has notified me that I need to migrate to a new VPS. My old server is running SQL Server 2008 R2 (the free version) and the new server will be running SQL Server 2016 (the free version). My ...

Microsoft capped off a week of high-profile announcements related to SQL Server with an aggressive migration offer aimed at Oracle database customers. Here's the bottom line, from Microsoft's ...

The announcements add built-in durability for Amazon ElastiCache for Valkey and a new bring-your-own-media option for Amazon RDS for SQL Server. AWS said the enhancements extend its strategy of ...