SQL Server

Table of Contents As you may know, the internal SQL Server name is based on the physical server name, but...

Table of Contents Upgrades from earlier versions to SQL Server 2019 (15.x) SQL Server 2019 (15.x) supports upgrade from the...

Table of Contents In this article I am explaining how to do backup and restore using a SQLCMD and T-SQL...

Table of Contents Overview Creating backups using SQL Server Management Studio is pretty simple as well. Based on how simple...

Table of Contents Edition Upgrade and Downgrade in SQL Server Have you ever needed to upgrade or downgrade the SQL...

Table of Contents Microsoft’s SQL Server Management Studio will connect by default to port 1433 and there’s nowhere in the...

Table of Contents  When attempting to connect to a specific SQL instance from a custom or third party software program,...

Table of Contents Download SQL installation iso image 1. Download SQL Server installation iso image then mount it. Open setup.exe...

Table of Contents There are multiple ways on getting the SQL Server instance name. You can refer any of below...

1. Search then open Control Panel. 2. Select the link Uninstall a program. 3. Select Microsoft SQL Server then click...