Скачать или смотреть FIU SCIS-2020Summer-BOLO-InstallMaintenanceGuide

Version: 15.0

Team Members: Roland Aroche, Janeth Arriola, Ekaterina Banks, Anthony Benitez, Zachary Garcia, Adriano Herrera, Akeem Lake, Ismael Peña

Product Owner(s): Jason Cohen

Mentor(s): Frank Alvarado

Instructor: Masoud Sadjad

IntelliJ Download
Timestamp: 8:00
Link: https://www.jetbrains.com/idea/download/

Visual Studio Code Frontend Installation
Timestamp: 20:20
Link: https://code.visualstudio.com/download

Node and NPM
Timestamp: 20:36
Link: https://docs.npmjs.com/downloading-an...



MACOS INSTALLATION
Commands:
1. sudo docker pull mcr.microsoft.com/mssql/server:2019-latest
2. docker run -d --name sql_server_demo -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=reallyStrongPwd123' -p 1433:1433 microsoft/mssql-server-linux
3. docker ps
4. Sudo npm install -g sql-cli
5. mssql -u sa -p reallyStrongPwd123
6. select @@version
Azure Data Studio:
Timestamp: 4:32
https://docs.microsoft.com/en-us/sql/...


Azure Data Studio Database Commands:
--start
USE master
GO
IF NOT EXISTS (
SELECT [name]
FROM sys.databases
WHERE [name] = N'your_db'
)
CREATE DATABASE your_db
GO

use [your_db]
go
CREATE LOGIN your_user WITH PASSWORD = 'pass@123';
CREATE USER your_user FOR LOGIN your_user;

ALTER ROLE db_ddladmin ADD MEMBER [your_user];

ALTER ROLE db_datareader ADD MEMBER [your_user];
ALTER ROLE db_datawriter ADD MEMBER [your_user];

go

--end


WINDOWS INSTALLATION
Timestamp: 11:00
SQL Server download:
https://www.microsoft.com/en-us/sql-s...
MSSQL Server Studio download:
https://docs.microsoft.com/en-us/sql/...