Russell Hankins RussellHankins

Interesting SQL scripts for Sql Server.

Uppdaterad 3 månader sedan

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.

Uppdaterad 4 månader sedan

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.

Uppdaterad 7 månader sedan

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.

Uppdaterad 7 månader sedan

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

Uppdaterad 8 månader sedan

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

Uppdaterad 9 månader sedan

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

Uppdaterad 9 månader sedan

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

Uppdaterad 9 månader sedan

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

Uppdaterad 9 månader sedan