Interesting SQL scripts for Sql Server.

Zaktualizowano 3 miesięcy temu

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.

Zaktualizowano 4 miesięcy temu

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.

Zaktualizowano 7 miesięcy temu

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.

Zaktualizowano 7 miesięcy temu

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

Zaktualizowano 8 miesięcy temu

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

Zaktualizowano 9 miesięcy temu

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

Zaktualizowano 9 miesięcy temu

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

Zaktualizowano 9 miesięcy temu

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

Zaktualizowano 9 miesięcy temu