Anthony's Blog

This article concerns the following Stack Overflow question:  Error Importing Azure bacpac file to local db error incorrect syntax near EXTERNAL which also encountered. In my issues, I was dealing with a 5Gb file and could not edit the needed files.  TLDR:  Rather than using the accepted solution from the Stack Overflow link, I had to go through creating a new database on azure and removed the external authentication provider manually. I was able to export the database in the Azure portal which forced me to use then download it again in a blog so I could import locally. Notes I did run into this issue,  Is there a way to successfully import a bacpac that exceeds 4GB in which I need to change the Collation?  What I did was moved the file locally to the server, from there I was able to get around the limit. At least that's what I remember at the time of writing I had always completed this project but forgot to document it but I believe that is what I did. Se...

So a lot of this info will be old but good for reference, I did get this project to  sort of   working version using bt878 on ubuntu 18 and another server using ubuntu 20. I say "sort of "  because most of what I got back from the video was distorted showing a green over most of it and I believe was from a bad board. That might have been why I got it so cheap and it was a non-returnable item through eBay. However, it was enough to see an example of what's possible with old computer boards and cheap cameras. I have since moved onto IP cameras and a lot of what I'm doing now is localized as well as working in 4k. Still I had a lot of fun working on this project. Docs : https://linuxtv.org/wiki/index.php/Btaudio_(bt878) Stretch Capture Card, VRC7016/VRC701 6L, DVR 16-Channel w/ Audio/Video Cable This is the card I used https://assets.maxlinear.com/web/documents/vrc7016_pb.pdf https://stargazerslounge.com/topic/327021-cant-get-a-video-capture-card-to-install-assistance-n...

 Currently I have 235 achievement out of 700 for Halo MCC, lets hope this makes things easier to focus on and filter out. This script should be useful for any game on the following url:  https://steamcommunity.com/id/{users}/stats/{game}/?tab=achievements

Wasnt able to get this to work but some notes on how to get started.  - Spoofing the machine ID? https://security.stackexchange.com/questions/258681/can-somebody-abuse-my-hardwares-ids - https://superuser.com/questions/485152/use-vpn-through-another-machine - https://answers.microsoft.com/en-us/windows/forum/all/internet-connection-sharing-in-windows-10/f6dcac4b-5203-4c98-8cf2-dcac86d98fb9 Unable to share the vpn itself because of the policies implemented... https://pureinfotech.com/export-import-vpn-connections-windows-10/ Error 720 : ERROR_PPP_NO_PROTOCOLS_CONFIGURED  typically occurs if the WAN Miniport (IP) adapter is not bound correctly on your PC . This is true even though the WAN Miniport (IP) adapter might look healthy when you examine the Network adapters node in Device Manager.

 First things first, lets delete cause that's super easy and before I delete anything I make sure to create backups. What I'm looking to do is expand a system like topshelf where it can just manage it remotely for me but using devops can be tricky. //delete command sc.exe delete <service name> or Ps way Remove-Service -Name "TestService" Note: curious about the registry but its better to use sc.exe. Now for adding sc create asperacentral binPath= "C:\Program Files\Aspera\Enterprise Server\bin\Debug\asperacentral.exe" DisplayName= "Aspera Central" start= auto

 Got tired of using filezila to do everything so this morning I set things up with Samba to allow me to share. Just a few notes along with this video that I think might be helpful for other devs. commands sudo apt-get install -y samba sudo ufw allow 139 sudo ufw allow 445 sudo service smbd status sudo vi /etc/samba/smb.conf sudo chmod 777 shared_folder/ [guest] # This share allows anonymous (guest) access # without authentication! path = /shared_folder read only = no guest ok = yes guest only = yes I used the folder path at the root and probably will later add a user for security but for now I have what I need to get running. Doesnt seem as fast as filezilla but thats not a big deal. 

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

Back in 2019 I was working for a consulting firm which this came in handle, I dont think I will ever need to go back to an ERP system and specially dont think I will need to work with flexcode again. Still this was something that I found and might help someone else. Public Sub Database_Connection()  Do      If cn1.State = 1 Then Exit Sub      On Error Resume Next      Set cn1 = macForm.ConnInfo.OpenADOConn      On Error GoTo 0  Loop  End Sub

Trying to handle a secure folder  where the files are not pushed to the server at deploy. Like all files in wwwroot they are in source control, these will not. The files I'm storing are so big that moving them is a separate process do outside of my application. https://stackoverflow.com/questions/36775942/how-do-i-serve-static-files-only-to-authorized-users https://github.com/ClintBailiff/MiddlewareDemo/blob/master/Startup.cs get current user   inside an MVC controller: From the  Controller  base class, you can get the  IClaimsPrincipal  from the  User  property System . Security . Claims . ClaimsPrincipal currentUser = this . User ; You can check the claims directly (without a round trip to the database): bool IsAdmin = currentUser . IsInRole ( "Admin" ); var id = _userManager . GetUserId ( User ); // Get user id: Other fields can be fetched from the database's User entity: Get the user manager using dependen...