https://github.com/enochtangg/quick-SQL-cheatsheet

Keeping it handy to refer people to!

Keeping this handy!

https://www.eff.org/deeplinks/2018/03/how-change-your-facebook-settings-opt-out-platform-api-sharing

A lot of people complain that with the algorithmic changes to the Facebook news feed, they don’t see what their friends are doing (which is all many of us want). In fact, those changes let to a tremendous amount of gaming the system. At first, Mark Zuckerberg denied anything was amiss, but over time, he has changed his tune.

Wired has a great article about the transformations that Facebook is undertaking to mitigate this problem. It’s a long read, but it is a very one.

While Facebook and Onavo include some details in their license agreement, I’m 100% sure no one realizes that Facebook is using Onavo to learn what apps users are using, and what sites they’re visiting. The whole point of a privacy VPN is to have privacy, not to expose everything to Facebook.

I’m not one for regulation, but it sure feels like this is dirty pool – killing competing apps in the cradle by knowing when they are getting traction, and then adding the functionality to Facebook so that they can take the market from the startup.

Read the TechCrunch article about it.

This is fascinating stuff.  While this particular test is focused on women, no doubt there will be tests that are for men, and gender neutral ones as well.

Are you a Todoist user?  If so, these two blog entries may help you get more out of your investment (either time or money)

https://blog.todoist.com/2015/09/03/10-hidden-features-of-todoist/

https://blog.todoist.com/2014/06/10/a-comprehensive-guide-to-todoist/

I received this link through Brent Ozar Unlimited’s weekly mailing list (if you’re a SQL geek at all, sign up for it by registering for their SQL First Responder Kit!).

The short version of Justin’s blog post is that Google is simply miles (kilometers for those of us not using Freedom Units) ahead of Apple maps, and everyone else. He delves into the level of data and derived information that Google has access too, which really shows how far ahead they are versus the competition.

Definitely worth the read, especially if you want to feel inadequate about your own data collection and analysis skills and systems.

https://www.justinobeirne.com/google-maps-moat