Russell Hankins RussellHankins

Interesting SQL scripts for Sql Server.

Aggiornato 3 mesi fa

Fetch the list of banned IPs from the database. Use ipset list to get the current list of banned IPs. Add any new banned IPs from the database to ipset.

Aggiornato 4 mesi fa

The MySQL BigInt isn't that big. 64 bits. If you want to store larger numbers, store them as text. But what if you want to add numbers stored in text? This procedure adds two text numbers of any size and returns the result as text.

Aggiornato 7 mesi fa

DNSExit.com offers a free feature where you can point your domain name at your home PC. If your IP address changes, this script will detect it and use the DNS Exit Dynamic IP API to update the IP address of your domain name.

Aggiornato 7 mesi fa

Shows the stack trace (file name/function name/line number) when a critical error crashes your program.

Aggiornato 8 mesi fa

websocket
0 0

websocket is a chatroom websocket server. Written in C++ using libwebsockets: https://libwebsockets.org/lws-api-doc-master/html/md_READMEs_README_8coding.html

Aggiornato 9 mesi fa

A procedure to list recent deadlocks on sql server. Another procedure to cause a deadlock.

Aggiornato 9 mesi fa

Graphics User Interface for the Raspberry Pi command line omxplayer audio/video player

Aggiornato 9 mesi fa

Copy files from one computer to another to make a backup. Only copies changed files. Also finds moved files.

Aggiornato 9 mesi fa