Arkadiusz arekgotfryd

👽

Working from home

arekgotfryd / Restore db backup (MSSQL)

Created January 13, 2020 19:02

	RESTORE DATABASE dbname FROM DISK = 'C:\whatever\dbname.bak'
	WITH MOVE 'dbname_data' TO 'C:\...\dbname.mdf',
	MOVE 'dbname_log' TO 'C:\...\dbname.ldf';

arekgotfryd / Backup whole db without detaching (MSSQL Server)

Created January 13, 2020 18:58

	BACKUP DATABASE VI_GenericRetail TO DISK = 'C:\exports\VI_GenericRetail.bak'
	WITH COPY_ONLY, INIT, NO_COMPRESSION;

arekgotfryd / Add unique (auto-incremented) primary key to existing table

Created September 11, 2019 08:01

	ALTER TABLE dbo.YourTable
	ADD ID INT IDENTITY
	CONSTRAINT PK_YourTable PRIMARY KEY CLUSTERED

arekgotfryd / gist:33c4576cf5b9208b0b2888d3debdf3b2

Created September 10, 2019 16:13

bcp import data from file to sql server table - usage

bcp McD.dbo.Stores in E:\bcp\Stores.dat -S localhost -n -Usa -Ppassword

arekgotfryd / bcp export table to file - usage

Last active September 10, 2019 12:55

bcp McD.dbo.Stores out E:\bcp\Stores.dat -S localhost -n -Usa -Ppassword

Created July 23, 2019 18:15

wget -i images.txt

arekgotfryd / How to load data from csv file into mysql table

Created July 23, 2019 18:00

	LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/products.csv'
	INTO TABLE inzynierka.product
	FIELDS TERMINATED BY ','
	ENCLOSED BY '"'
	LINES TERMINATED BY '\n'
	IGNORE 1 ROWS;

arekgotfryd / Advanced regular expression replace in VSC

Created July 23, 2019 17:53

 Find: "(\d),(\d)(\d) zł"
 Replace: $1.$2$3
 Example:
 It replaces expression "3,49 zł" to 3.49

arekgotfryd / robocopy using 16 threads

Created May 7, 2019 11:24

robocopy "F:\VM" "I:\SSD_bck\VM" /e /MT:16 /NP /NFL /NDL

arekgotfryd / gist:9cfd50c1282506ac572d6a93c3ecf746

Last active March 3, 2019 16:43

BSK Lab1 firewall.sh

	iptables -F
	iptables -P INPUT DROP
	iptables -P FORWARD DROP
	iptables -P OUTPUT DROP
	#icmp
	iptables -A OUTPUT -o eno16777728 --proto icmp -m icmp --icmp-type echo-request -j ACCEPT
	iptables -A INPUT -i eno16777728 --proto icmp -m icmp --icmp-type echo-reply -j ACCEPT
	#dns
	iptables -A OUTPUT -o eno16777728 -p udp -m udp --dport 53 -m state --state NEW -j ACCEPT
	iptables -A INPUT -i eno16777728 -p udp -m udp --sport 53 -m state --state ESTABLISHED,RELATED -j ACCEPT