Friday, March 22, 2024

Move SQL Temp DB to alternate partition

›
If you need to move your temporary databases to another partition- USE master GO ALTER DATABASE tempdb MODIFY FILE( NAME = temp2, FILENAME =...
Thursday, March 14, 2024

OpenSSL Self Signed Cert / PFX

›
openssl genpkey -algorithm RSA -out key.pem openssl req -new -key key.pem -out csr.pem openssl x509 -req -days 365 -in csr.pem -signkey key....
Monday, January 8, 2024

You create and deploy a shortcut/URL via GPO, but network icon file is missing.

›
Create a GPO and enable- Computer Configuration > Policies > Administrative Templates > Windows Components > File Explorer ->...
Friday, October 27, 2023

Windows Server 2022 DC shows in Private Network Instead of Domain

›
Windows Server 2022 DC shows in Private Network Instead of Domain Open Regedit, HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NlaSvc,...
Wednesday, October 4, 2023

SQL Windows Firewall

›
I set up a lot of SQL servers. Here are the powershell commands to allow the sql ports. Please don't be 'that guy' who shuts off...
Tuesday, October 3, 2023

How to set up a Site to Site VPN on AWS to your firewall

›
 AWS VPN- 1) First you need a "VIRTUAL PRIVATE GATEWAY"- this is the connection to the on-prem firewall. Use the amazon default AS...
Thursday, September 14, 2023

Adding Users to Send to group but still receive

›
 First, make sure you have Advanced Features checked under the View menu. Then, open up the distribution group’s properties, and go to the A...