Kemal C. ddeveloperr

PostgreSQL is Enough

Background and Cron Jobs

#Installation

The first thing to do is import the necessary repository key. From the terminal window, issue the following command:

sudo wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

Next, add the repository with the command:

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-preview.list)"

#1 Install it first: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-2017

#2 Check:

~$ sudo systemctl status mssql-server

#3 Do what you need:

~$ sudo systemctl stop mssql-server
~$ sudo systemctl start mssql-server

#SOLID Principles with ruby examples

##SRP - Single responsibility principle A class should have only a single responsibility.

Every class should have a single responsibility, and that responsibility should be entirely encapsulated. All its services should be narrowly aligned with that responsibility, this embrace the high cohesion.

##OCP - Open/closed principle Software entities should be open for extension, but closed for modification.

	You will need a Windows 10 boot disk;

	Installing Windows 10 using the media creation tool - create media then
	boot with it.
	http://windows.microsoft.com/en-us/windows-10/media-creation-tool-install

	How to Create a Bootable USB Flash Drive to Install Windows 10
	http://www.tenforums.com/tutorials/2376-usb-flash-drive-create-install-windows-10-a.html

	OR use this method :

 Finding and replacing any string text across the multiple files using Linux commands Grep and Sed
 Step1: Login with sudo privileges and locate your folder:
        ~$ cd /your-folder
 Step2:
        ~$ grep -rl 'Text-to-be-Replaced' /* | xargs sed -i 's/Text-to-be-Replaced/I-AM-Replaced-Text/g'
 Step3:  D O N E !
         NOTE that changes of find and replace linux server command will not be reflected
         on those files which needs an additional permission!

	As a root you should do the following steps using your terminal:

	1. Add Vivaldi repository:

	$ wget -qO- http://repo.vivaldi.com/stable/linux_signing_key.pub \| sudo apt-key add -
	$ sudo add-apt-repository "deb [arch=i386,amd64] http://repo.vivaldi.com/stable/deb/ stable main"

	2. Install

	$ sudo apt install vivaldi-stable

	Very simple:
	Step 1: Open your terminal
	Step 2: Write the following command in terminal
	```
	~$ sudo snap install postman
	```
	Step 3: Finfnd postman on your Ubuntu/Linuz system and use it. That's simple.

	This command will be working on other Unix based systems.

	-- How to comment & uncomment SQL code in DataGrip IDE

	-- 1. Mark SQL code
	SELECT TOP 3 *
	FROM CUSTOMER
	WHERE Customerid ='4de3092d03b742f3b2b88cf6fe0b09d0'

	-- 2. Press "CTRL"+"/" (Slash) on the keyboard
	--Code will become:


	1. Super key: Opens Activities search (Windows key!)
	2. Ctrl+Alt+T: Ubuntu terminal shortcut
	3. Super+L or Ctrl+Alt+L: Locks the screen
	4. Super+D or Ctrl+Alt+D: Show desktop
	5. Super+A: Shows the application menu
	6. Super+Tab or Alt+Tab: Switch between running applications
	7. Super+Arrow keys: Snap windows
	8. Super+M: Toggle notification tray
	9. Super+Space: Change input keyboard (for multilingual setup)