Sully Syed

Your various software development projects are going to require you to use different versions of Node.js to compile and run; to make this process a little bit quicker, you can utilize NVM and .nvmrc files places in your project root folders to automatical…

Often enough when I’m debugging an issue that doesn’t occur the same in the staging or production environment as it does on a development or local environment, like most developers I add debug statements on those environments to catch/view output from var…

When deploying Laravel and WordPress to AWS Elastic Beanstalk, creating an .env file or just making use of environment variables is a common practice; however, Elastic Beanstalk tends to choke on string values of “null” and often returns the error message…

Normally, creating a second (or third, fourth…) MySQL superuser who has all available database privileges is as simple as executing: GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%' IDENTIFIED BY 'password'; However, MySQL database in Amazon RDS and Amazon A…

On Google Workspace, to allow a User to send an email on behalf of a group (like allowing Sully Syed to send an email from contact@yllus.com), do the following: Go to Gmail on the web ( https://mail.google.com/mail/u/0/#inbox ) and log in.

Fairly often we purchase a new domain or decommission an existing one and need to redirect all queries to it to a specific URL on a wholly different domain and website.

Assuming you’ve already uploaded all of the contents of the uploads/ folder into the Amazon S3 bucket (set to public), you now need to run the following SQL query to add rows to the wp_as3cf_items table: INSERT IGNORE INTO wp_as3cf_items (provider, region,

Figuring out what tables are making your database excessively large can be really helpful when working with production database exports and keeping various environments up to date.

Occasionally, you’ll want to duplicate a couple of records from your production MySQL database for local use without dumping the entire table (which could be huge).

Environics Analytics provides incredibly useful demographics, psychographics and segmentation data for Canada, but the raw data is challenging if the goal is to use it in a general SQL query: The raw data is in one file, the meanings of the columns are in…

Often enough in PHP, you’ll grab objects from a variety of sources and want to merge them into a single array of results.

When a major PHP version change (eg. 5.7 to 7.0, or 7.0 to 8.0) occurs, Amazon AWS Elastic Beanstalk typically does not allow for automated platform version updates but instead requires the cloning of an interface and a CNAME switch.

Do a git pull that overwrites local conflicts and accepts all remote changes via: git pull -s recursive -X theirs <remoterepo or other repo> For example, overwrite your local master branch with the remote origin‘s master branch: git pull -s recursive -X t…

Another typical regex scenario: You’re looking through some data (like a JSON object) and are looking for when a value is actually being set.

This is most easily measured by installing the sysstat package: sudo yum install sysstat -y And running the sar command, looking at the value of tps: sar -d 1

Here’s a quick way to get a recursive list of files, sorted in descending order by the last modified date, from any folder in *nix: find .

A few months ago I was struck by the mention of a study of chimpanzee society that found that the leader tended to demonstrate deep caring and empathy for members of their pack; empathy ultimately being a necessary aspect of their personality that benefit…

Permutations A selection of objects in which the order of the objects matters. nPk = n!

As a people manager, I’ve always been aware of the tendency of subordinates to want to agree with you – or at least to avoid having to voice a conflicting opinion.

Saw an interesting post in my e-mail today (care of the generally excellent CB Kickstart newsletter): When indeed is a good time to execute a rebrand for your organization?