Airport Extreme: Using the Guest Wifi With Bridge Mode

This article did the trick: https://www.thegeekpub.com/5191/use-airport-extreme-guest-network-bridge-mode/. If happen to have an unmanaged “smart” switch (such as the NETGEAR GS108) between your Airport Extreme and your firewall, you should only need to config the VLAN on the firewall and your unmanaged “smart” switch should pass those frames with no problem.

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