Interesting SQL scripts for Sql Server.

Updated 4 months ago

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.

Updated 6 months ago

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.

Updated 9 months ago

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.

Updated 9 months ago

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

Updated 10 months ago

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

Updated 10 months ago

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

Updated 11 months ago

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

Updated 11 months ago

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

Updated 11 months ago