Anthony's Blog

The time has come where I've been forced to work with SQL like a dba, and for once the pieces are falling in place.  https://stackoverflow.com/questions/3942207/how-can-i-backup-a-remote-sql-server-database-to-a-local-drive https://stackoverflow.com/questions/16491/restore-database-backup-over-the-network#:~:text=On%20the%20Server%20that%20you,bak%22 https://stackoverflow.com/questions/10204480/sql-server-the-backup-set-holds-a-backup-of-a-database-other-than-the-existing https://dba.stackexchange.com/questions/28082/restore-backup-fails-file-db-cannot-be-restored-to-mdf-use-with-mov Generating a script took too long and wasnt helpful for what I needed since I'd still need to move it onto the server. We're talking about 200gb and plus... and to make matters worse time is important. Since the backups are created nightly on the server and I just need to restore the backup on another server it seems kinda of a waste to not be able to use it. https://stackoverflow.com/questions...

 I'd like to use visual studio but visual code with mono.exe on the side is what I'm currently doing. I'm able to get WinForms to work however I'm running into difficult trying to run GTK on windows.  Unhelp Q/A - https://stackoverflow.com/questions/51132090/mono-compliling-gtk-on-windows its unhelp because I already have the complier working and referencing the package properly. Its just windows doesnt pick up GTK inorder to run it. https://stackoverflow.com/questions/51132090/mono-compliling-gtk-on-windows Possible Solution https://stackoverflow.com/questions/16417342/mono-gtk-hello-world-deploy-to-windows GTK Notes https://www.mono-project.com/docs/gui/gtksharp/beginners-guide/ mcs -r:"C:\Program Files\Mono\lib\gtk-sharp-2.0\gtk-sharp.dll" -r:"C:\Program Files\Mono\lib\gtk-sharp-2.0\glib-sharp.dll" -r:"C:\Program Files\Mono\lib\gtk-sharp-2.0\atk-sharp.dll" hello.cs mono hello.exe Unhandled Exception: System.IO.FileNotFoundException: Coul...

 As a consultant I've been able to start developing application and services at the lower levels of the operating system. Which is pretty interesting compared to what I use to do. I find myself doing the same thing with my web development. WPF -  https://en.wikipedia.org/wiki/Windows_Presentation_Foundation#:~:text=Windows%20Presentation%20Foundation%20(WPF)%20is,NET%20Framework%203.0%20in%202006. Understanding the .NET family https://en.wikipedia.org/wiki/.NET_Framework https://docs.microsoft.com/en-us/windows/apps/desktop/choose-your-platform https://en.wikipedia.org/wiki/Universal_Windows_Platform_apps

This is no longer needed but maybe can be used for real-time example projects. Currently dont have any use for it. https://stackoverflow.com/questions/44063832/what-is-the-best-practice-in-ef-core-for-using-parallel-async-calls-with-an-inje https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/ I've also been moving away from EF in favor for Dapper, still using tasks that might be unless until I write myself an example.

For sometime now I've been at a point in my research to find the proper way to handle raw html. Sometimes you need your api to push raw html with syntax that can't be edited once its submitted.  Handling all html in a 2D array where the first in just the html tag and the second is a child's value which can also be a html tag. { ["p"]["test"]  This may also be another case to start my project with a headless orchard core project. Using fluid syntax might be the better way to allow an api to take information and using a custom javascript library to convert html to the api? 

For some of the projects I have in mind this would be a great way to handle poor quality images, for example schematics that have low pixels. From there I would have an easier time convert to svg files but that is a project later down the road. For now this is something I need to keep in mind of. msmsajjadi/EnhanceNet-Code: EnhanceNet: Single Image Super-Resolution Through Automated Texture Synthesis (official repository)

Not a linux novice by any means, so this last year (2019) I had been tracking logs on my server. I'll come back to this article and clean it up but incase I dont these definitely helped me track things until I start using a third party tool. sudo ip6tables -I INPUT -m geoip --src-cc IT,FI,GB,CA,MX,CN,DE,TR,ID,RU,IN,IL,BR -j DROP http://blog.jeshurun.ca/technology/block-countries-ubuntu-iptables-xtables-geoip https://unix.stackexchange.com/questions/92560/list-all-connected-ssh-sessions  cat /var/log/auth.log | grep 'Connection closed' |  tail -n 40 sudo iptables -L  iptables -A INPUT -m state --state INVALID -j DROP Notes http://ipset.netfilter.org/iptables.man.html https://unix.stackexchange.com/questions/345114/how-to-protect-against-port-scanners https://unix.stackexchange.com/questions/318859/how-to-use-watch-command-with-a-piped-chain-of-commands-programs https://daenney.github.io/2017/01/07/geoip-filtering-iptables http://xmodulo.com/block-network-traff...