Arkadiusz arekgotfryd

## Backup whole db without detaching (MSSQL Server)
BACKUP DATABASE VI_GenericRetail TO DISK = 'C:\exports\VI_GenericRetail.bak'
WITH COPY_ONLY, INIT, NO_COMPRESSION;

## Add unique (auto-incremented) primary key to existing table
ALTER TABLE dbo.YourTable
   ADD ID INT IDENTITY
       CONSTRAINT PK_YourTable PRIMARY KEY CLUSTERED

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

## bcp export table to file - usage
bcp McD.dbo.Stores out E:\bcp\Stores.dat -S localhost -n -Usa -Ppassword

## How to download all images with use of wget and text file with images links
wget -i images.txt

## How to load data from csv file into mysql table
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;

## Advanced regular expression replace in VSC
Find: "(\d),(\d)(\d) zł"
Replace: $1.$2$3

Example:
It replaces expression "3,49 zł" to 3.49

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

## gist:9cfd50c1282506ac572d6a93c3ecf746
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

## Update sql table column with values from other table using spatial method contains to find the link between tables
  UPDATE a
  set a.Score = _TARGET.Score
  FROM McD_ROI_Hex_All_Afternoon a
  JOIN [SandBox].dbo.[McD_ROI_Hex_Timebuckets] AS _TARGET
  ON a.SP_GEOMETRY.STContains(_TARGET.SP_GEOMETRY) = 1
  AND a.Sum_Avg_Users = _TARGET.Sum_Avg_Users;
	BACKUP DATABASE VI_GenericRetail TO DISK = 'C:\exports\VI_GenericRetail.bak'
	WITH COPY_ONLY, INIT, NO_COMPRESSION;
	ALTER TABLE dbo.YourTable
	ADD ID INT IDENTITY
	CONSTRAINT PK_YourTable PRIMARY KEY CLUSTERED
	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;
	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
	UPDATE a
	set a.Score = _TARGET.Score
	FROM McD_ROI_Hex_All_Afternoon a
	JOIN [SandBox].dbo.[McD_ROI_Hex_Timebuckets] AS _TARGET
	ON a.SP_GEOMETRY.STContains(_TARGET.SP_GEOMETRY) = 1
	AND a.Sum_Avg_Users = _TARGET.Sum_Avg_Users;