arnabdas’s gists

arnabdas / restore_mssql.sql

Last active October 13, 2018 07:33

Restore a DB from backup in SQL Server Management Studio

	-- http://stackoverflow.com/questions/6267273/how-to-restore-to-a-different-database-in-sql-server
	-- https://github.com/Microsoft/sql-server-samples/releases
	RESTORE FILELISTONLY FROM DISK='/var/opt/mssql/backup/AdventureWorks2012.bak'
	-- Note the logical file names from the Results pane
	RESTORE DATABASE AdventureWorks2012 FROM DISK='/var/opt/mssql/backup/AdventureWorks2012.bak'
	WITH
	MOVE 'AdventureWorks2012' TO '/var/opt/mssql/data/AdventureWorks2012.mdf',
	MOVE 'AdventureWorks2012_log' TO '/var/opt/mssql/data/AdventureWorks2012_log.ldf'

	-- Make the new database name different than the filename specified to attach

arnabdas / hackerrank-javascript-template.js

Created January 23, 2017 11:50

JavaScript code template for Hackerrank

	process.stdin.resume();
	process.stdin.setEncoding('ascii');

	var input_stdin = "";
	var input_stdin_array = "";
	var input_currentline = 0;

	process.stdin.on('data', function (data) {
	input_stdin += data;
	});

arnabdas / Dockerfile

Created January 2, 2017 10:43

Check the docker container state

	RUN apt-get install -y openssh-server
	RUN mkdir /var/run/sshd

	RUN echo 'root:root' \|chpasswd

	RUN sed -ri 's/^PermitRootLogin\s+.*/PermitRootLogin yes/' /etc/ssh/sshd_config
	RUN sed -ri 's/UsePAM yes/#UsePAM yes/g' /etc/ssh/sshd_config

	CMD ["/usr/sbin/sshd", "-D"]

arnabdas / _datepicker.scss

Created December 26, 2016 10:43

A very simple datepicker with ReactJS

arnabdas / fwd-n-bkwd-month.js

Created December 13, 2016 10:13

arnabdas / unsupported.html

Created November 23, 2016 07:47

HTML page to state un-supported browser

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>CodeRuse</title>
	<link rel='shortcut icon' href='./favicon.ico' type='image/x-icon'>
	<link href="https://fonts.googleapis.com/css?family=Open+Sans:300,400" rel="stylesheet">

	<style>
	body {

arnabdas / checkSSD.sh

Created October 25, 2016 09:27

Check SSD

	# http://unix.stackexchange.com/questions/65595/how-to-know-if-a-disk-is-an-ssd-or-an-hdd
	# http://serverfault.com/questions/551453/how-do-i-verify-that-my-hosting-provider-gave-me-ssds

	# if on a bare server, 1 for rotating disk, 0 for SSD
	# cat /sys/block/sda/queue/rotational

	# if on a vps, this script should be finished in less than one second for SSD
	time for i in `seq 1 1000`; do
	dd bs=4k if=/dev/sda count=1 skip=$(( $RANDOM * 128 )) >/dev/null 2>&1;
	done

arnabdas / questions.js

Last active August 23, 2016 10:46

JavaScript Questions

	var a = 'name', b;
	console.log(a + b);
	console.log(a + b, function () {
	return a;
	}, a / b);
	console.log(a + + ': ');
	console.log('Hello, ' + 'World!!!');
	console.log('Hello, ' + + 'World!!!');
	console.log('Hello, ' + 'World!!!' + + '');
	console.log(typeof undefined);

arnabdas / youtube-dl-install.sh

Created August 20, 2016 07:01

Install and download Youtube video list in mp3 format

	# Install youtube-dl

	apt-get remove youtube-dl
	apt-add-repository ppa:nilarimogard/webupd8
	apt-get update
	apt-get install youtube-dl

	# Update avconv

	add-apt-repository ppa:heyarje/libav-11 && apt-get update

arnabdas / vultr-coreos-bootstrap.sh

Last active June 10, 2016 21:22 — forked from janeczku/vultr-coreos-bootstrap.sh

Cloud-config for CoreOS IPXE deployment on Vultr. Provisioning etcd, fleet, private network and docker compatible firewall.

	#!/bin/bash
	# Cloud-config for CoreOS IPXE deployment on Vultr
	##################################################
	# This cloud-config bootstraps CoreOS on /dev/vda and provisions:
	# - private ip-address on eth1
	# - etcd on private network
	# - fleet on private network
	# - basic firewall (docker compatible)
	# - SSHd security hardening
	##################################################

Arnab Das arnabdas