How to Change the Icon of an Apple Script Application

If you have an Apple Script that you’ve saved as an application, here’s a way to change the icon for it. The process is straightforward and mainly involves copy/paste. Create an icon in any format. For best results, make sure it’s a square image. Go to https://iconverticons.com/online/ and download the .icns file …

How to Run Microsoft Money on a Mac

Wine is a great tool to run Windows applications and setup is fairly easy on a Mac. These instructions could actually apply to any Windows application. Install Homebrew: https://brew.sh/ Install wine prerequisites. Open up a terminal and run the following: $ brew cask install java xquartz Install wine (this step …

How to Configure AnyTerm Web-based SSH on Ubuntu

Anyterm provides a web-based SSH interface that would allow you to, for example, access your internal system using SSH via a web page. Configuration is straightforward, but will require compiling the Anyterm source. In order to download the source, you’ll need Subversion. Download Anyterm (http://anyterm.org/download.html) into a directory called anyterm …

How to Run SQL Against Every Database on a Microsoft SQL Server

Use the sp_msforeachdb stored procedure. In the following example, I needed to find out if there were any objects that were referencing a specific linked server: DECLARE @command varchar(1000) SELECT @command = ‘USE ? SELECT OBJECT_NAME(object_id) [?] FROM sys.sql_modules WHERE definition LIKE ”%LINKEDSERVERNAME%”’ EXEC sp_msforeachdb @command In my case above, …

Enable Active Directory Authentication for GitLab

If you’re having trouble, here are some tips: Query all the users by using the following command: dsquery user -limit 1000 > users.txt Find the bind_dn user from this list and copy and paste the entire line. It will be a format similar to: ‘CN=Name\, Display,OU=Some Organizational Unit,OU=Another Organizational Unit,DC=domain,DC=com’ …