MS SQL Express Static Port

Because SQL Express defaults to a dynamic port, opening the firewall can be a bit tricky. Typically, for PDM, it’s easiest to just set it to something static that can then be opened through the firewall. Instead of creating my own guide, here’s a link to a step by step guide by Javelin Technologies.

Read More

Upgrade to SQL 2014 SP3

For some reason, this is harder to find than it should be, so here’s a GoEngineer link as well as the actual link to the MS page. SOLIDWORKS PDM Upgrading SQL 2014 to Service Pack 3 | GoEngineer Download Microsoft® SQL Server® 2014 Service Pack 3 (SP3) from Official Microsoft Download Center

Read More

Synology ZeroTier Setup

Create a persistent TUN SSH into your NAS The following setup steps must be run as root Write script to /usr/local/etc/rc.d/tun.sh that will setup /dev/net/tun on startup Set executable permissions on script Run script once to create a TUN Check for the TUN If you experience trouble getting the TUN to work check out Rui Marinho’s guide Install docker on your NAS…

Read More

Ducky Instructions

Copied, verbatim, from the link in Helpful Links in case his blog goes down: Full Keyboard Backlight Use the following commands to customize the backlight for the whole keyboard. Key Description Fn + F10 Toggle between the following modes: Full Backlight, Breathing Mode, Raindrop Mode, Reactive Mode, Ripple Mode, Backlight Off. Fn + ↑ Increase brightness. Fn + ↓ Decrease brightness.…

Read More

Helpful Links

Ducky One Guide: https://www.hschne.at/2018/02/15/a-simple-guide-to-the-ducky-one.html Google Photos –> Synology: https://michelenasti.com/from-google-photos-to-synology-photos

Read More

Regex Expressions

Here are some of the regex expressions that I’ve found useful. The first is just for US phone numbers. I’ve modified one that I found so that it is a little more restrictive, specifically not allowing zeros or ones for the first digit of the area code or the central office code. Here’s how to…

Read More

VPN Issues

For whatever reason, trying to connect to a VPN from a domain account that was connected using the VPN has issues: The requested operation cannot be completed. The computer must be trusted for delegation and the current user account must be configured to allow delegation. Go to this registry key: Add a DWORD called ProtectionPolicy…

Read More