Minutes Difference Same Day (T-SQL)
// Get a time in the format : 8:00 AM // Returns the minute difference in integer using the current time // (only works for the same day but you can modify to work for … Read more
Category : Programming
Programming
OPENVPN Useful Sites
OPENVPN can be very tricky to set up but with the right resources the setup is not quite as bad. I tried to follow the OPENVPN manual (http://openvpn.net/index.php/open-source/documentation/howto.html) but before I know it I was … Read more
Common Default Ports
SSL 443 OpenVPN 1194 Microsoft VPN 1723 MYSQL 3306 MSSQL 1433
Add a Mysql as a Linked Server
The other day I got a request to migrate some data from Mssql to Mysql. I am like ok fine, I will just use SSIS and it will take me a second. This second led … Read more
Format date and time MS DOS
This is a quick MSDOS Batch script to help me out when I have to move a file and rename it in the process based on the current date. cls FOR /f “tokens=1-4 delims=/-. ” … Read more