When creating automation scripts to discover, add, update or remove records from a remote SQL database, you need to make sure your script can successfully connect to the database.

Figure 2. Successful Azure PowerShell Connection Output. Although this next step might have been set for other reasons, you must have a server firewall rule setup to allow incoming SQL connections ...

LibreOffice Base can make working with remote MySQL databases a snap. Jack Wallen walks you through the steps to make this happen.