I have a static website that I host on o365 for some internal use. I upload some data that is rendered via js at some scheduled times. This works today but I wanted to deploy code via script, so I took another look at how I was doing things to... [Read More]
Batch decode user agent strings
mozilla who/what now??
Recently I downloaded some web logs for an app I have running. This app is pretty old and hasn’t been changed in quite some time, but it was tweaked a year or so ago in order to get it running as an azure app service. We’re looking to freshen it... [Read More]
Download Azure WebApp / AppService Logs via CLI
I better write this down...
This seems pretty easy, but just in case you have multiple subscriptions and multiple apps on a single app service, this seemed to be the easiest way to get the logs using the way I wanted to get them. This also covers some very minor things that I always forget... [Read More]
migrating git repositories from one azure devops org to another
so easy, even i can do it!
I have a lot of projects in azure devops. I started with a handful, but I started by storing each of the customer integrations and other semi-related things into their own projects. Why? Well, largely it is only me generating and maintaining all of this code. However it has recently... [Read More]
MS-SQL LAG window function and 31st
All 30 day months!
I will use some dummy tables for this topic. I’ll post something to generate some test data and the full SQL down at the bottom. For now it’s important to know this will involve a table I’ll name @SalesByDay with two fields named SalesDate and TotalSales. This table has Sales... [Read More]
Hosting Blazor App on O365 Sharepoint
I said what I said
I probably have a larger article to write on hosting static sites on o365, especially with respect to SPA style things. But for now I’ll just make a note of this particular item here so I don’t forget or if anyone else is looking for this, they can find it.... [Read More]
Watching a folder for changes and sending an email with powershell
Who watches the watcher?
I previously wrote about watchintg a folder for changes and displaying some information on those changes. This was primarily used for some live monitoring of a file mover that was being sunset. [Read More]
Using powershell to compress data in flight
Why don't we buy a bigger internet circuit, again?
I have a situation where I need to copy some data over a WAN link. This is a MS SQL backup that needs to be restored at a remote location when we relocate a system. We generally can get ~8-10MB/s while copying the files and the database backup is 300+GB... [Read More]
The fastest way to get a folder size in windows
Dir size fast...
Watching Files with Powershell
Uatu, the powershell script
I needed to watch a folder to see when files were created. I also decided to check for deleted files, below is the script. You can, of course, just look at the folder to see this in explorer. In this case, we had some files moving from one folder to... [Read More]