Software Development

Installing Docker and Docker-Compose on Ubuntu

Docker apt-get update apt-get install apt-transport-https ca-certificates curl software-properties-common curl -fsSL | sudo apt-key add - apt-key fingerprint 0EBFCD88 add-apt-repository "deb [arch=amd64] $(lsb_release -cs) stable" apt-get update apt-get

Docker Cheatsheet

Docker provides a way to run applications securely isolated in a container, packaged with all its dependencies and libraries.   1. docker in linux can run dotnet 2.


MS SQL Server Cheatsheet

Reseeding a table identity in MS SQL Server DBCC CHECKIDENT (tablename, RESEED, new_reseed_value) Truncate Table truncate tablename Check Log size of all database DBCC SQLPERF(LOGSPACE);   Connection String Standard Security: 1. Server=ServerNameOrIpAddress;Database=DatabaseName;User Id=Username; Password=Password; Trusted

MySQL Cheatsheet

Login to MySql: mysql -u username -p password Create Database: create database databasename character set utf8 collate utf8_general_ci; grant all on databasename.* to databaseUser@'localhost' identified by 'password'; Delete Database: drop database