Let’s say you have several databases on a Microsoft SQL Server, each with loads of tables. Now you want to find a table with the word ‘users’ in the table name. Easy, run a SQL query to search the ...
Works With The Web
Cancel
SQL Search Objects Names
Exporting All SSRS Reports
I want to backup reports within SSRS with a bulk export. Prerequisites Make sure you’re using the latest version of PowerShell Install the needed modules: Install-Module -Name ReportingSer...
Fixing The OPNsense Package Manager Part 2
This post is a continuation of my post, Fixing The OPNsense Package Manager. This issue still bothered me, and I never did sort out the underlying cause. However, everything with all the affected i...
Fixing The OPNsense Package Manager
I recently had a very unusually rough time updating OPNsense. I use OPNsense as a backup backdoor management VPN server at various data centers. Two upgraded just fine to 22.7.1; the others appeare...
VyOS High CPU Utilization with SNMP checks via Zabbix
I was working with VyOS 1.2 and 1.3 routers in a lab test. I wanted to wanted to monitor the underlying Linux/Debian objects and various routing process statuses using Zabbix. Basic items like BGP ...
Install Zabbix Agent on Ubuntu 20.04
I’m running Zabbix 6.0 through my lab at the moment. To properly test, I’d also like to install the latest Zabbix agent on my test servers. Install all available updates sudo apt update sudo apt i...
Manually Update VMWare ESXi
VMWare is in the news again. I feel the next 24 months will be rough for security teams across the board. Many have spent the last year or more in lockdown refining skills and learning new ones. Cy...
Setup PowerDNS Recursor on Ubuntu 20.04
I’m exploring using PowerDNS to replace a good chunk of my DNS infrastructure. Don’t get me wrong; I like Bind. I’m looking for something database driven that is easier to integrate with monitoring...
USB Dongles and Multi-WAN - Go ahead and laugh at me
Tldr: The TP-Link UE300 USB ethernet dongle does not work properly on OPNsense 21.7.3_3. USB Ethernet dongles are a bad idea in general for this application. Don’t ping 8.8.8.8 or 8.8.4.4 as your m...