SQL 2019 developer edition configuration on my workstation

install SQL 2019 developer edition on my T1500 workstation first. then install SQL management studio.

SQL 2019 developer edition configuration. password is: Nutec12142019!

zipped file is unzipped under C:\Samples.

Install notes

When installing from a script, the default database name is AdventureWorks or AdventureWorksDW. If you want the version added to the name, edit the database name at the beginning of the script.

The oltp script drops an existing AdventureWorks database, and the data warehouse script drops an existing AdventureWorksDW. If you don't want that to happen, you can update the $(DatabaseName) in the script to a different name, for example AdventureWorks-new.

To install AdventureWorks, follow these steps:

1. Copy the GitHub data files and scripts for AdventureWorks to the C:\Samples\AdventureWorks folder on your local client. Or, download AdventureWorks-oltp-install-script.zip and extract the zip file to the C:\Samples\AdventureWorks folder.
2. Open C:\Samples\AdventureWorks\instawdb.sql in SQL Server Management Studio and follow the instructions at the top of the file.
3. change runmode into SQL command mode
4. modify csv file location to fit your own folder structure.
5. run the installation script instawdb.sql.

good reference

the following links are good reference for future installation of SQL developer version.

1. How To: Download and install AdventureWorks database for SQL Server 2008
2. AdventureWorks REadme

please read To install AdventureWorks section. it is very clear description.

4. NVMe SSD enclosure