Monday, December 16, 2019

Saturday, December 14, 2019

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
  3. please read To install AdventureWorks section. it is very clear description.

  4. NVMe SSD enclosure

how to install LocalDB along with visual Studio 2017?

how to install LocalDB along with visual Studio 2017?

follow instruction in the first instruction to run Visual Studio 2017 installer. then I was prompted to update installer. so I did so.

To install SQL Server Express 2016 LocalDB, go to Start in your Windows OS, type Visual Studio Installer and run it. Then click Modify. It will open the Workloads selection screen where you can select .Net desktop development. .Net desktop development includes SQL Server Express 2016 LocalDB. After selecting, click Modify and you are done.

I checked installed components, I find SQL 2016 LocaDB is installed already.

  1. How to install LocalDB 2016 along with Visual Studio 2017?
  2. Basic Information And Overview Of Visual Studio 2017
  3. Visual Studio 2017: .NET Desktop Development - demo video
  4. How to connect to SQL Server Express LocalDB
  5. How to connect to MS SQL server
  6. How to connect and use Microsoft SQL Server Express LocalDB
  7. Download and Install SQL Server 2016 Sample Databases WideWorldImporters and WideWorldImportersDW
  8. AdventureWorks installation and configuration
  9. AdventureWorks Readme
  10. Download SQL Server Management Studio (SSMS)
  11. How To Install SQL Server Management Studio 2017
  12. download a free specialized SQL sever edition

check Visual Studio installation