Posts

SQL Backup Database with Network folder

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
Read more

Mono GTK on Windows

 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
Read more

Windows & Service Development

 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
Read more

EFCore - Parallel Async

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.
Read more

Handling Raw Html

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? 
Read more

Image Enhancement Research

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)
Read more

Linux: Managing Security & System Logs

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-traffic
Read more

Popular posts from this blog

UI-Bootstrap Collapsible Sticky Footer

    I could have done this a lot of ways and ultimately I made it work with javascript modifying the class names. I also had to create multiple class names which I didn't like to much, I might come back and improve this but for now this is was I got. Also I call bootstrap+angularjs = ui-bootstrap, not sure if that's common sense but thought I should include it somewhere in my notes. Working Example: http://plnkr.co/edit/2N9ENlbw3bSvg1W9n0ch?p=preview This little css was key to prevent any kind of animation on the collapse, which would result in a scrollbar appearing on the body. A scrollbar can appear when the content's too long but not on the sticky foot duh! .no-animate { transition-duration: 0.0125s; } Research Angular-UI Bootstrap Collapse without animation - Stack Overflow http://jsfiddle.net/paulalexandru/Z2Lu5/  - Was looking at this to see if I could reuse it but I ended but just doing my own thing. Another way which I've seen Using a sticky
Read more

Installing Windows on Acer chromebook 15 cb3-532

Much of my notes are just small problems I faced (what's new!) haha. Either way this was a really fun project to do for a friend and I got excited once I research all the information. You can find instruction videos but what helped me the most was the coolstar website. Sadly they don't have parameters in the url so I can link the machine I used in this article. -  https://coolstar.org/chromebook/windows-install.html Scared of messing with the bios? Don't be!    So you need to first remove the screw to put a legacy bios on the machine. Its easy to backup the chrome os one and with the same steps to change it. You can go back in and revert to the chrome version bios. Its that last part that had me worried and its very easy to do.  Problems getting into Developer Mode?   Follow the instructions to the letter, during the step to disable the OS verification, press Ctrl-D to boot into os. If you hear two beeps I would go back to set one. I got in a loop where it s
Read more

Aspetcore: NLog with Postgresql

This Article is base ASP.Net Core 2 and the latest version of Nlog. 1. Install NLog and the Postgresql Package Using NuGet to install the package into your ASP.NET Core project: PM > Install-Package NLog.Web.AspNetCore PM > Install-Package Npgsql 3. Register NLog Add in your Startup.cs  public void Configure ( IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory ) { ... env.ConfigureNLog( "nlog.config" ); ... // make sure Chinese chars don't fk up Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); //add NLog to ASP.NET Core loggerFactory.AddNLog(); //add NLog.Web app.AddNLogWeb(); } 4. Add to Your Controller Add a logger object to your Controller. private readonly ILogger<YourController> _logger; Modify the constructor to use it public YourController ( ILogger<YourController> logger = null ) { if ( null != logger) { _logger = logger;
Read more