Blog

When attempting to connect to a specific SQL instance from a custom or third party software program, it is common that the port number used by that SQL Server instance be specified in the application. 1. Click the Start button,…

1. Download SQL Server installation iso image then mount it. Open setup.exe file. 2. Select Maintenance then select Edition Upgrade. 3. Enter the product key for SQL Server, you can buy it from Microsoft or a local reseller. 4. Select…

There are multiple ways on getting the SQL Server instance name. You can refer any of below methods. Below example were tested on SQL Server 2019 version but the steps will be similar to other SQL Server versions. Launch the…

1. Search then open Control Panel. 2. Select the link Uninstall a program. 3. Select Microsoft SQL Server then click Uninstall/Change. 4. Select Remove. 5. Select the instance to remove from the SQL Server. 6. Select all features to remove…

Do you want to change SQL Server license key on production server? In this tutorial we’ll walk you through the steps to change product key for any existing SQL Server 2019 / 2017 / 2016 / 2014 installation, without having…

1. Right click on Windows icon then open Windows Powershell(Admin). 2. Run this command to get the hostname of your SQL Server. hostname 3. Run this command to connect to SQL server using single user mode. Replace servername by your…

1. Open a Command Prompt or PowerShell then connect to your SQL Server instance by executing this command: SQLCMD -S server_name\instance_name Note If you’re trying to connect to the default instance, just type SQLCMD. 2. Next, run the following T-SQL…

SSMS 18.11 is the latest general availability (GA) version, you can download it from this link You can download older versions in the below table. VersionBuild numberRelease yearDownload latestSQL Server Management Studio 1818.0.x.x2019DownloadSQL Server Management Studio 1714.0.x.x2017DownloadSQL Server Management Studio…