Microsoft SQL Server 2019 Developer Edition Installation on Windows Server 2016/Windows 10
In this video we are going to show how to install Microsoft SQL Server 2019 Developer Edition on Windows Server 2016/2019/Windows 10.
In this video we cover following lessons.
1. SQL Server 2019 Developer Edition Installation.
2. Install SQL Server Management Studio.
3. Connect SQL Server Management Studio with SQL Server 2019.
4. Create Database and Create Table in SQL Server 2019.
Before we see the installation please watch this video link how to obtain or download sql server 2019 developer edition Installation media or iso file.
https://youtu.be/BLK6tycVy6U
SQL Server Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer is an ideal choice for people who build and test applications.
Browse the below link for new features:
https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sql-server-ver15
SQL Server Management Studio
#############################
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts.
Use SSMS to query, design, and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud.
SSMS is free! Browse the below link to download SSMS
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver15