An innerjoin it is the most common kind of join, so common that SQL doesn’t actually make us say “inner join” to do one.
An outer join returns a set of records or rows that include what an inner join would return, but also includes other rows for which no corresponding match is found in the other table. There are 3 types of outer join:
The other day I only had access to my secondary Mac (mac mini) via the Terminal. For some reason Screen Share did not work. I needed to enabled File Sharing on my mac mini in order to transfer some backup files from my MacBook Pro to the mac mini. Coffee was brewing!
This is how I activated File Sharing via the terminal on the mac mini. I ran these two commands:
If for some reason, you need to enable the root account, all you need to do is to set a password for the root user. In Ubuntu, you can set or change the password of a user account with the passwd command.
To change the root password you need to run the following command as a sudo user:
sudo passwd root
You will be prompted to enter and confirm the new root password.
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
That’s all! Now you can login to the Ubuntu system as a root. This is not the recommended way. You should always use a sudo user account instead.
A session is defined as a group of interactions one user takes within a given time frame on your website.
For example a single session can contain multiple page views, events, social interactions, and E-Commerce transactions. A single user can open multiple sessions. Those sessions can occur on the same day, or over several days, weeks, or months. As soon as one session ends, there is then an opportunity to start a new session. There are two methods by which a session ends:
After 30 minutes of inactivity
If a user arrives via one campaign, leaves, and then comes back via a different campaign.
By default, a session lasts until there’s 30 minutes of inactivity, but you can adjust this limit so a session lasts from a few seconds to several hours. See suggestions by Google in this link.
Most theme authors fix themes in a timely manner, but others won’t 🙁 . There are times you will need to update WooCommerce templates yourself. Its easier than what you think, but it may take you some time.
You need to determine what templates to update, make a backup of old templates and then restore any customizations.
Go to WooCommerce > Status> System Status. Scroll to the end of the page where there is a list of templates overridden by your theme/child theme and a warning message that they need to be updated. For example <aTheme>/woocommerce/cart/cart-totals.php version 2.2.0 is out of date. The core version is 2.3.0 and so on...
Before you do anything .Save a backup of the outdated templates!
Copy the default template from wp-content/plugins/woocommerce/templates/[path-to-the-template] and paste it in your theme folder found at: wp-content/themes/[path-to-theme]
It may take you a while to complete the entire process, but sometimes we have no choice.
If this issue keeps going with future WooCommerce updates and your theme keeps breaking consider changing your theme for a better supported one.
Hola! Recently I went for an interview for a DevOps/IT Engineer position at NYC. I was skeptical about my skill set and if I would be able to talk about ‘DevOps’ stuff and etc…
To my surprise, I learned more about myself during that interview. I was able to talk about and respond to about 95% of their questions with confidence. I underestimated myself. I know more that what I thought. This may happen to many. But, I suggest you go out there and apply to jobs with fancy and scary ‘Job titles’.
Go and interview with a mindset of a spy. Ask questions about the technology the company uses, daily tasks, team environment and etc..Don’t be afraid!
Below is the main key points I discussed during the interview with this high-end Advertising company. I’m going over each and reviewing/improving my skills. I hope they can help you also.
AWS: Concentrate on the main services only.
Basic commands to Linux (CentOS/Ubuntu).
Apache virtual hosts.
Load balancer basics.
SSL certificates installs.
OAuth, APIs, OpenID, etc.
Let me know if you have any questions in the comments section. Cheers!