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]
Bookmarklets for Scheduled Tasks in ServiceNow (creation and direct URL)
Little helpers for ServiceNow ScheduledTasks
So, recently we’ve moved over to ServiceNow for incident/request management. There are two things I wanted to be able to do: [Read More]
Listing Documents via Jekyll without collections
How to avoid configuration files for document meta-data? Just use the file names!
Recently, I moved all of our static sites over to hosting on github using github pages. Github uses jekyll for generation of the static content and there are tons of themes out there to utilize. [Read More]
Running PiHole on a Raspberry Pi Docker Swarm
OK, so this was a bit entertaining. There are a ton of articles out there on how to get a Docker Swarm running on a RasPi cluster. Basically, just get all of the Pis up, updated, and setup with static/reserved IPs, then install docker, then run the docker swarm init... [Read More]
Add Global Admin Directory Role in Azure AD via Powershell CLI
RBAC, why do you hate me?
Note that this won’t work in the azure portal powershell console or in a docker container as those do not seem to be able to let you login to the azure ad interactively. [Read More]