Welcome back to Not So Random Software, this week’s links are dedicated to leadership. We often struggle to define it, measure it and promote it, but leadership is still a key factor for your tech team’s success. This week’s links serve as a good reminder of what to focus on. Enjoy this random walk!
A random article or paper
Not all people interpret leadership the same way, and that’s why this article from Harvard Business Review is a good reminder of the different styles out there and when they are appropriate.
A random video or podcast
In this TED talk, Simon Sinek highlights why building a safe environment is key for leaders to be successful. Make your team feel safe, and they’ll follow you.
A random book
Based on thirty years of research and more than one million survey responses, Kouzes and Posner highlight what they think are the 10 top traits that define a leader; lots of insights and practical examples. My favorite lately? Values drive commitment.
A random tool
Being leadership so hard to measure and practice, I think journaling is one of the few tools that help you measure and challenge what you are doing every day; the second one is probably actively gathering feedback. There is a lot of choice for journaling tools out there, but this is all based on the command line, which some people might appreciate.
A random line of code
Did you know that in PostgreSQL subqueries appearing in FROM clause can reference columns from preceding FROM items if you use the JOIN LATERAL keyboard? Well, now you do! Very useful to create funnel-like reports without the need for functions or ninja moves, best to play around with the DB-fiddle!
FROM events e1
e1.user_id = user_id and
e1.event_type = 'visited_home_page'
) as e1
LEFT JOIN LATERAL
FROM events e2
e2.user_id = user_id and
e2.event_type = 'clicked_product' and
e2.created_at > e1.created_at
) as e2 on true
LEFT JOIN LATERAL
FROM events e3
e3.user_id = user_id and
e3.event_type = 'paid_product' and
e3.created_at > e2.created_at
) as e3 on true
A random quote
Leadership is the art of getting someone else to do something that you want done because he wants to do it, not because your position of power can compel him to do it, or your position of authority.Dwight Eisenhower