SQL Performance Tuning in Bulk in AWS
My company recently moved to AWS, so I’ve been looking for more information specific to SQL Server performance tuning in AWS. Unfortunately, a lot of what I’m finding is marketing copy devoid of technical detail. Apparently, moving my data to the cloud is great for...A quick “back up all databases” script
Mostly so I can link it to a post that’s getting traffic… Declare @DBname varchar(255), @SQL nvarchar(max), @today nvarchar(50), @servername nvarchar(50) set @today = convert(nvarchar,GETDATE(),12) set @servername =...What is Mastodon and why should I use it?
I’m so glad you asked! 😀 So, of all the Twitter clones–let’s not get into Twitter, shall we?–the current top three are Mastodon, Bluesky, and Threads. I don’t have a Threads account so I can’t speak to whether it’s any good or...Hardware update
So, when talking about the Librem 5, I mentioned that I had a really old Librem 13 that I wasn’t using as much as I would like. Since then, the laptop that I was running Qubes on seized up and died, so… I’m once again running Qubes on my beautiful...Librem 5 First Thoughts
Okay, I’ve been playing with this for less than 24 hours and it’s not my daily driver phone or anything, so… disclaimer. If you’re not familiar with Purism, they’re the makers of absolutely gorgeous tech for the technoparanoid. (They also...Password Managers
Password managers. You want one. Let’s do this in Q&A format, shall we? Q: WTF is a password manager and why do I want one? A: Have you ever forgotten a password? Do you use the same password on every site? Is your password...How to route all Opnsense traffic through your private VPN
This is for your home network, yes. I tried several how-tos, and basically had to figure it out for myself. Here’s how I did it. Preface: I have two LANs; one for computers, tablets, and phones, and the other for IOT devices, including my Roku (which cannot...What Happens When You Request a Webpage
Okay, with all the securing all the things posts, it occurs to me that I haven’t actually explained this. (I did, however, explain this in depth for an interview at Large Internet Company, so it’s probably higher-level than I thought.) One of my first jobs...Why Public Wifi is So Insecure
Here’s a short demo of sniffing. They [TM] can possibly do this to you at that nice free public wifi spot you’re using. They need to be on your network. This is geographically limited, by which I mean that if you’re in Kansas and visiting a server in...Subscribe
