Categories
Tech

Disable “Coming Soon” in Office

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\General\”DisableComingSoon”=dword:00000001

Categories
Tech

Checking a File Hash on Windows

Get-FileHash filename for SHA256

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 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