36 articles
As you may know, the internal SQL Server name is based on the physical server name, but changing the physical server name does not update the metadata within SQL Server. When connecting to SQL Server, we use the physical server…
SQL Server 2019 (15.x) supports upgrade from the following versions of SQL Server: SQL Server 2012 (11.x) SP4 or later SQL Server 2014 (12.x) SP2 or later SQL Server 2016 (13.x) SP2 or later SQL Server 2017 (14.x) Windows 10…
In this article I am explaining how to do backup and restore using a SQLCMD and T-SQL command prompt. It’s one of the most important responsibilities for DBAs. It works across all supported operating systems, whether they are 64-bit or…
Creating backups using SQL Server Management Studio is pretty simple as well. Based on how simple the T-SQL commands are, there is a lot of clicking that needs to occur in SSMS to create a backup. The following screen shots…
Have you ever needed to upgrade or downgrade the SQL Server edition you already installed? Maybe you currently have Enterprise Edition and have discovered that you can save money on licensing if you downgrade to Standard Edition. The ability to…
Microsoft’s SQL Server Management Studio will connect by default to port 1433 and there’s nowhere in the connect dialog to specify a different port from the default. To connect using a different port specify the servername, a comma, and then…
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…