Compare an in-place upgrade with a side-by-side SQL Server migration, including downtime, testing, dependencies, and recovery after cutover.
SQL SERVER – Patch Installation Error: The version of SQL Server instance does not match the version
Applying a patch is something which is part of everyone’s life in the software industry. One of my clients reported below error related to Patch Installation Error.
Install SSMS: Setup and First Connection
To install SSMS, download the installer, run it, and connect to your server. This post explains why SSMS is separate from the SQL Server engine, how to fill in the first connection, what to do about the certificate error, and how to check the connection with one query.
SQL SERVER Installation – FeatureUpgradeMatrixCheck (SQL Server 2016 Feature Upgrade) setup rule failed
SQL Server Installation failed on rule FeatureUpgradeMatrixCheck: the edition upgrade from Enterprise to Evaluation is not supported. Here is why and the fix.
SQL SERVER – Fix Error – 948 A downgrade path is not supported. The database cannot be opened because it is version.
Attaching a database gave me Error 948: a downgrade path is not supported. Here is why a database from a newer SQL Server version won’t open on an older one.
What You May and May Not Do With SQL Server Developer Edition
Understand Developer Edition rights, identify the installed SQL Server edition, and keep shared test systems separate from production work.
SQL SERVER – FIX: Setup Was Not Able to Access Domain
A DBA installing SQL Server 2012 on a virtual machine got ‘Setup was not able to access domain’. Here is what the message means and how to get past it.