Posts

Error Importing Azure bacpac file to local Db error incorrect syntax near EXTERNAL

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

CCTV - Ubuntu Server with VRC7016 Capture card

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

Hide Unlocked Achievements for Steam Website Mod

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

Sharing VPN network

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

Managing Windows Services - Delete/Add

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

Ubuntu Server: Cmd line Network Shared folder for Windows

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

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

Popular posts from this blog

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

Entity Framework: ToListAynsc & WhereAsync

When upgrading aspnet mvc applications I like to take a look on how I can convert the api's to async. This sometimes is really easy but as things get more complex my queries do as well. So this is a list of ways you can form a where clause on top your  async  but note not all solutions take advantage of it. Notes on EFCore Entity Framework Core provides a set of asynchronous extension methods that can be used as an alternative to the LINQ methods that cause a query to be executed and results returned. Examples include  ToListAsync() ,  ToArrayAsync() ,  SingleAsync() , etc. There are not async versions of LINQ operators such as  Where(...) ,  OrderBy(...) , etc. because these methods only build up the LINQ expression tree and do not cause the query to be executed in the database. https://codereview.stackexchange.com/questions/32160/filtering-a-collection-by-an-async-result Filtering a collection by an async result ,  built an ext...
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 loo...
Read more