Categories
Tech

Creating a local SQL admin user when you’re locked out

Please only use this for good. Restart SQL in single-user mode then check the commands section for commands.

Categories
Tech

Changing Server authentication mode in SQL Server

Right click instance name > Properties > Security > Server authentication

Categories
Tech

Trusted Platform Module has malfunctioned in Teams and Outlook (80090016)

Delete certs issued by MS-Organization-* in Certificates (Local Computer) > Personal > Certificates

Categories
Tech

Updating firmware on Procurve (Aruba) switch with console and TFTP

copy tftp flash tftp server IP .swi filename

Categories
Tech

Creating a self signed certificate on Procurve (Aruba) switches

crypto host-cert enroll-self-signed certificate-name valid-start mm/dd/yyyy valid-end mm/dd/yyyy subject common-name

Categories
Tech

Wiping (0ing) a HDD with shred

Do not use on SSDs! shred -vzn 4 devicename

Categories
Tech

Changing time zone with command prompt and PowerShell

tzutil /s “Central Standard Time”

Categories
Tech

Youtube to mp3 with youtube-dl

youtube-dl.exe –extract-audio –audio-format mp3 –audio-quality 0 –ffmpeg-location “ffmpeg\bin” -o %(title)s.%(ext)s url

Categories
Tech

FOG with UEFI

Change your boot filename to snponly.efi

Categories
Tech

Windows 10 2004 no internet icon / internet check bug

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NlaSvc\Parameters\Internet\EnableActiveProbing