Joel Snyder, Ph.D., is a senior IT consultant with 30 years of practice. An internationally recognized expert in the areas of security, messaging and networks, Dr. Snyder is a popular speaker and ...

Each version of Microsoft’s SQL Server comes with five years of full support, followed by five years of security-only updates. Here are five questions to ask before your next upgrade. 1. Should My ...

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

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

SQL Server 2016 lost mainstream support this month, on July 13. While you can still run SQL Server 2016 and open support tickets, there will be very few performance updates. In an unusual step, ...