Interesting SQL scripts for Sql Server.

Päivitetty 3 kuukautta sitten

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.

Päivitetty 4 kuukautta sitten

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.

Päivitetty 7 kuukautta sitten

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.

Päivitetty 7 kuukautta sitten

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

Päivitetty 8 kuukautta sitten

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

Päivitetty 9 kuukautta sitten

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

Päivitetty 9 kuukautta sitten

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

Päivitetty 9 kuukautta sitten

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

Päivitetty 9 kuukautta sitten