Living the non-Admin life

Living the non-Admin life
I stopped using Windows as an Administrator and I don’t even notice. Keep reading to find out what kind of pitfalls I ran into and overcame, and some ways to keep your sanity as a mere “user”.
Read more →

How to create a SQL Server CLR function

How to create a SQL Server CLR function
Sometimes you need to write a SQL query that you know is going to be really ugly, or you may need to do something that SQL doesn’t support natively. Common Language Runtime (CLR) functions can help in these types of situations.
Read more →

Securing our home/office network

Securing our home/office network
Our home network started off like most. We had a cable modem and a wireless router - two little boxy things plugged into the wall. We had internet; everything worked. Fast forward a few years - We now have a public-facing web server hosting several sites (I jokingly refer to this as “Bob’s Bargain Basement Hosting”), a whole bunch of PC’s/laptops/phones/IoT devices, a Plex server, security cameras, WiFi out the wazoo, and occasionally nefarious people poking around looking for a way in.
Read more →