Search tables for value

Search for any column in any table that has a specific value where the column is a specific data type 12345678910111213DECLARE @SearchGUID UNIQUEIDENTIFIER = ‘BF3CBDB9-39A9-487D-8754-FC4120E4D993’; DECLARE @SQL NVARCHAR(MAX) = ”; …

Test HSTS

How to manually test to see if HSTS is enabled on a web server 12~$ curl -s -D- https://owasp.org | grep -i strict-transport-security: Strict-Transport-Security: max-age=31536000 https://owasp.org/www-project-web-security-testing-guide/latest/4-Web_Application_Security_Testing/02-Configuration_and_Deployment_Management_Testing/07-Test_HTTP_Strict_Transport_Security

Upgrade AWS T instance to M instance

https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/migrating-latest-types.html 1). Update the AWS PV drivers manually https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/Upgrading_PV_drivers.html#aws-pv-upgrade 2). Update the ENA driver (Part 2 of the top link) 3). Update the config tools in step 4 I did …

Azure SQL Edge on Docker arm64

Windows 11 Pro Control Panel – Programs and Features – Turn Windows Features On or Off Enable Hyper-V (not visible on Home edition, also not sure I needed this) Enable …

Mongo Won’t Restart

MongoDB does not start after a reboot, sudo tail -10 /var/log/mongodb/mongod.log indicates 1Failed to unlink socket file /tmp/mongodb-27017.sock Operation not permitted To resolve the issue, run commands 123sudo rm -f …

Wazuh Cheat Sheet

List packages installed on a specific agent 1GET /syscollector/092/packages/?pretty=true&name=AIMS LPR Sync Delete a specific agent 1DELETE /agents?pretty=true&older_than=0s&agents_list=327,328&status=all GET /manager/daemons/stats?daemons_list=wazuh-analysisd

Git RESET

Git stable has changes that have been committed and not pushed. Stable doesn’t allow changes to be pushed. Rollback the branch to match the repo. Locate the specific commit # …