Dealing with a 1 million line CSV file

I’m doing a cloud migration to a SharePoint library, it’s for a law office so they have tons of documents, pictures, video, audio, and many many folders. After addressing the various oddities with Migration Manager… Ok, a quick tangent, if you have a path C:\Shares\General and the share is “General” and you want to migration

Penn Station Coupon Hacking

I’ve always enjoyed hacking the Penn Station coupons, because they’re so poorly secured. I got an email from Penn Station on the weekend and they have a “slot machine” it seems to run and then randomly send you to another page that generates a coupon. First thing I noticed is that the url: https://penn-station.com/slots23/ is simply

Sonicwall fix for QUIC UDP Issue

If you want the super quick answer it’s “UDP Flood Protection”, increase packet limit or disable it. Now the journey and longer answer: Fixing my own problems are always the hardest, I guess it’s because they’re memorable, little irritations that I fix for customers I do for myself instantly without even thinking about it or

Security Defaults, embrace or disable?

New Microsoft 365 tenants have this enabled by default, I usually leave it on while people get logged in, so that we can see if it’s viable to stay on it. If we get everyone on MFA with Authenticator app, it’s usually better to leave SD enabled. Sorry I’ll be using that abbreviation for the

Add extra “stickers” to ShareX

You can add your own library of icons to ShareX. Twitter supplies an open source of emoji https://github.com/twitter/twemoji, also here are more open source emoji: https://openmoji.org/ It’s a good start but I was looking for a way to indicate access points on a google maps image. So I also used https://icons8.com/ to download a few

ShareX: Best Snapshot Tool Ever

https://getsharex.com/ We’re starting to implement Security Defaults on Microsoft 365, so we’re having to get MFA enabled on all accounts including initial admin accounts on new customers.I was setting up a new account and wanted to put the QR Code into our password manager, so I snapped it with ShareX and then opened https://zxing.org/w/decode.jspx Oh no,

“I’ll do it myself”

Here is an excellent tale of why you shouldn’t cut the expert out and do it yourself. We could maybe make this into a blog post. Granted this customer did use the experts for all the camera installs except they had one camera left over and decided, it wasn’t enough to worry about getting the

Reporting Tech Support Scammers

We happen to use ConnectWise Control (formerly ScreenConnect) as our remote support tool so when we got a call from a customer that we already had an agent installed on, we were dismayed to find the scammer was also using a paid version of Control. This is the story of how we removed the scammer

Export Azure AD Groups and their Members to CSV file

I was tasked with examining our Azure AD groups and cleaning things up. So we wanted to know who is in which group and what kind of group is it. Seems like an obvious job for Powershell. https://github.com/dyerseve/AADGroupMembers