Skip to content

Instantly share code, notes, and snippets.

View ombak's full-sized avatar
🎯
Focusing

Sukma Saputra ombak

🎯
Focusing
26 followers · 24 following
View GitHub Profile
@ombak
ombak / Menjalankan_SQL_Server_2017_pada_Debian_Stretch_Dengan_Docker_4.sh
Created May 28, 2020 02:55
sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \
-S localhost -U SA -P '<YourStrong!Passw0rd>' \
-Q 'ALTER LOGIN SA WITH PASSWORD="<YourNewStrong!Passw0rd>"'
@ombak
ombak / Menjalankan_SQL_Server_2017_pada_Debian_Stretch_Dengan_Docker_5.sh
Created May 28, 2020 02:56
sudo docker exec -it sql1 "bash"
@ombak
ombak / Menjalankan_SQL_Server_2017_pada_Debian_Stretch_Dengan_Docker_6.sh
Created May 28, 2020 02:56
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P '<YourNewStrong!Passw0rd>'
@ombak
ombak / Menjalankan_SQL_Server_2017_pada_Debian_Stretch_Dengan_Docker_7.sql
Created May 28, 2020 02:57
CREATE DATABASE TestDB;
@ombak
ombak / Menjalankan_SQL_Server_2017_pada_Debian_Stretch_Dengan_Docker_8.sql
Last active May 28, 2020 03:04
USE TestDB;
@ombak
ombak / Menjalankan_SQL_Server_2017_pada_Debian_Stretch_Dengan_Docker_9.sql
Created May 28, 2020 03:05
CREATE TABLE Inventory (id INT, name NVARCHAR(50), quantity INT);
@ombak
ombak / Menjalankan_SQL_Server_2017_pada_Debian_Stretch_Dengan_Docker_10.sql
Created May 28, 2020 03:06
INSERT INTO Inventory VALUES (1, 'banana', 150); INSERT INTO Inventory VALUES (2, 'orange', 154);
@ombak
ombak / Menjalankan_SQL_Server_2017_pada_Debian_Stretch_Dengan_Docker_11.sql
Created May 28, 2020 03:07
SELECT * FROM Inventory WHERE quantity > 152;
@ombak
ombak / Menjalankan_SQL_Server_2017_pada_Debian_Stretch_Dengan_Docker_12.sh
Last active May 28, 2020 03:08
sqlcmd -S 10.3.2.4,1433 -U SA -P '<YourNewStrong!Passw0rd>'
@ombak
ombak / Menjalankan_SQL_Server_2017_pada_Debian_Stretch_Dengan_Docker_13.sh
Created May 28, 2020 03:09
sudo docker stop <container-name>
sudo docker rm <container-name>