gefvert.org

SQL Server BCP reference

2020-08-11

bcp Database.dbo.TableName out savefile.bcp -S server -T -N -k

Exports data from a certain server and table to a savefile. -T means trusted connection (using Windows authentication), -N uses the database's native storage with Unicode values (specifically designed for server-to-server copy),...

> Keep reading

Ufw (firewall) Reference

2020-01-26

ufw enable ufw disable

Enable or disable the firewall.

ufw allow in http ufw reject telnet comment 'telnet is not encrypted'

Allow all incoming HTTP traffic and reject telnet globally (normally 'deny' is used but 'reject' will explicitly reject a connection).

...

> Keep reading

Docker Reference

2019-11-13

Command/option Description
 
Containers Containers are light-weight virtual machines
docker create image [cmd] Create container from image
docker rename container newname Rename container
docker rm container Remove a container
   -f Force
   -v Also delete volumes
 
`docker...
> Keep reading

sed and awk Reference

2019-10-10

Argument Description
 
awk '{print $1}' Print 1st word from lines separated by space
awk -F: '{print $1}' Print 1st word from lines separated by colons
 
sed -n Don't display input lines in output
sed '5d'...
> Keep reading

Common TcpDump Parameters

2019-09-04

Argument Description
 
Output
-A Print packet in ASCII
-e Print MAC address (link-level info)
-x Print packet in hex
--print Print parsed output even if saving packets to file
-w file Write raw packets to...
> Keep reading

Common CURL Parameters

2019-08-21

Argument Description
 
Protocols
--http1.0 Use HTTP 1.0
--http1.1 Use HTTP 1.1
--http2 Use HTTP 2
-4 Resolve domain names to IPv4
-6 Resolve domain names to IPv6
-k Allow insecure connections in SSL
 
**HTTP...
> Keep reading

My List of Ubiquitous Software

2019-08-15

(Really just a list for myself when I reinstall a new computer.)

Productivity

> Keep reading

Common wget Parameters

2019-07-31

Argument Description
 
Requests
--header=x Insert custom header
--method=x Use custom HTTP method
--post-data=STR Set POST data from string
--post-file=FILE Set POST data from file
--referer=x Use custom referer
-t n Number of retries (0=unlimited)
 
Authentication/TLS
--http-user=x...
> Keep reading

Windows CMD reference

2018-08-25

ATTRIB [/s] [/d]

Changes file attributes. /s makes it recursive, /d makes it operate on directories as well. I didn't know about these switches before. Handy.

CALL :label arguments

Neither did I know you could call a label in a batch...

> Keep reading

Common ffmpeg parameters

2011-06-24

Argument Description
 
Information
-codecs Display codecs
-formats Display formats
-f fmt Force format "fmt"
-i filename Set input file name
-y Overwrite output file
-t secs Force duration to specific length (hh:mm:ss[.xxx])
-fs limit Set...
> Keep reading