In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

A conference being held in Denver this week by the Professional Association for SQL Server user group will provide a forum for the biggest public unveiling to date of Microsoft Corp.’s SQL Server 2008 ...

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

Many considerations go into evaluating whether it is time to implement an upgrade to a new version of SQL Server. You need to think about socket vs. core licensing ...

There’s a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...