The hottest Substack posts right now

according to Hacker News
Category

Must Learn KQL Part 19: The Join Operator

Rod’s Blog • 19 implied HN points • 31 May 23
🕹 Technology Data Analysis
  1. The Join operator in KQL is used to merge rows from two tables by matching values of specified columns.
  2. Using different flavors of Join, like inner, leftouter, rightouter, and fullouter, can change how data is displayed in the results.
  3. To practice and understand the Join operator better, examples can be tested in the KQL Playground or explored in advanced tutorials like 'Addicted to KQL'.

The Era of Acute GPT Shortage Will Soon Begin

Tomasz’s Substack • 19 implied HN points • 27 Mar 23
🕹 Technology AI Supply and Demand Regulation Global Competition Market forces
  1. Researchers predict that GPT-4 technology could significantly speed up tasks in the US, leading to a potential surplus of LLM services.
  2. There could be a shortage of GPT services due to the high demand from professionals and large corporations, with supply potentially struggling to keep up.
  3. OpenAI may restrict GPT-4 access, possibly limiting it to US-based businesses, which could give American and Chinese companies a competitive advantage in utilizing advanced LLM models.
Get a weekly roundup of the best Substack posts, by hacker news affinity:

Walking Meditation, Making Videos, and A Book That I'm Rereading.. | #1

Code Crafters by Anas • 19 implied HN points • 08 Sep 23
🕹 Technology Productivity Self-Improvement Content creation Social media Software Engineering
  1. Taking walks can clear your mind, solve problems, and relieve stress.
  2. Trying out making videos can be fun, help with public speaking, and be a good outlet for sharing content.
  3. Reading 'The War of Art' can motivate and remind you to stay disciplined in creative projects.

Why Boring Technologies Are Exciting

The Digital Anthropologist • 19 implied HN points • 11 Sep 23
🕹 Technology Innovation Market Hardware Applications Business
  1. Exciting innovations often arise from technologies that have become mundane and boring.
  2. Significant technological advancements can be found in sectors like manufacturing, transportation, and energy grids.
  3. Value and impact of technologies are not solely determined by mass consumer adoption but also by their silent contributions to society.

An Introduction

Irrational Analysis • 19 implied HN points • 19 Aug 23
💰 Finance Analysis Newsletter Investing Stocks Technology
  1. The author shares their journey of pursuing their dream job of chip designing and how it led to their current obsession with semiconductors and investing.
  2. The newsletter 'Irrational Analysis' focuses on high-risk, high-reward investing with a strong emphasis on technology-driven investment analysis over traditional metrics.
  3. Transparency is vital to the author, who discloses all active positions and emphasizes that the newsletter's content is based on public information and independent research.

My (new) perspective on creating content as a strategy for driving new business

Nate is Learning • 19 implied HN points • 03 Jul 23
💼 Business Marketing Content creation Industry Trends Professional Growth Business strategy
  1. The author no longer believes creating content is necessary for driving new business.
  2. In-house professionals in B2B companies might not have time or interest to consume content on platforms like LinkedIn.
  3. For B2B buyers, methods like peer recommendations, social ads, search, and cold outreach are more effective than personal branding.

Tech Nostalgia & Why We Love It

The Digital Anthropologist • 19 implied HN points • 06 Sep 23
🕹 Technology Nostalgia Generative AI
  1. We enjoy looking back at past predictions on future technologies, finding humor and nostalgia in how they were portrayed.
  2. Future technology predictions are influenced by cultural norms and biases, shaping how artists and designers envision the future.
  3. Nostalgia helps us deal with changes by making us feel more comfortable with the present and provides a lens to imagine possible future scenarios.

The Improvisational Art of Innovation: How Jazz, Comedy, and Intuition Can Transform Business and Life

⭐️Bob’s Newsletter • 19 implied HN points • 02 Apr 23
💼 Business Innovation Data Intuition Leadership Creativity
  1. Trust your intuition to drive true innovation and creativity more than data.
  2. Data sets the foundation, but creativity and intuition transform it into innovation.
  3. Embrace curiosity, diversity of thought, and active listening to unlock potential for innovative problem-solving.

Personalization Uncovered: The Surprising Ways Hyper-Targeted Advertising Influences Our Thoughts, Choices, and Lives

⭐️Bob’s Newsletter • 19 implied HN points • 30 Mar 23
🕹 Technology Advertising Data Privacy Personalization
  1. Hyper-targeted advertising limits exposure to new ideas and unexpected discoveries.
  2. Personalized advertising may give a false sense of autonomy in our consumption choices.
  3. Repetitive hyper-targeted ads can diminish real emotional connections with brands and others.

Must Learn KQL Part 18: The Union Operator

Rod’s Blog • 19 implied HN points • 31 May 23
🕹 Technology Data Analysis Query Language Data Integration
  1. The Union operator in KQL allows you to combine data from multiple tables to display all rows together, while the Join operator is used for more specific results by matching column values of two tables.
  2. Union in KQL supports wildcard usage to merge multiple tables and can be used to combine tables from different data sources like Log Analytics Workspaces.
  3. In Microsoft security tools like Microsoft Sentinel and Defender, the Join operator is commonly used for creating Analytics Rules for specific results, while Union is useful for advanced hunting tasks.

Clock time or rock time?

lifeboat • 19 implied HN points • 03 May 23
📖 Philosophy Agency Nature Perception Time Existence
  1. Time is weirder than we think, with deep connections to the past and future.
  2. Different cultures have different ways of understanding time, like the concepts of Chronos and Kairos.
  3. Changing how we perceive time can shift our sense of agency and possibility, moving us from despair to action.

Six Career Moves that Young Data Scientists Dismiss too Quickly as Boring

Mike Talks AI • 19 implied HN points • 10 Sep 23
💼 Business Career development Work-life balance Job Satisfaction Professional Growth Skills
  1. Don't underestimate the value of solving real problems even if it means using older technology.
  2. Repeating tasks can help you become an expert in a specific area, leading to career advancement and satisfaction.
  3. Understanding and exploring different roles like sales and management can provide valuable lessons and career growth opportunities.

Why We Fear New Technologies At First

The Digital Anthropologist • 19 implied HN points • 17 Aug 23
🕹 Technology Innovation Adoption Governance Social Impact
  1. Societies tend to fear new technologies initially, then overhype their potential once the fear subsides, influenced by norms, behaviors, and customs.
  2. Fear of new technologies can be a survival mechanism, signaling potential threats to culture and society.
  3. Adopting and adapting to new technologies in a fast-paced world requires new mental models, frameworks for unintended consequences, and agile governance mechanisms.

Must Learn KQL Part 17: The Let Statement

Rod’s Blog • 19 implied HN points • 31 May 23
🕹 Technology Programming Data Analysis Cloud Computing
  1. The Let statement in KQL allows you to create variables that can be used throughout the query, aiding in better query performance.
  2. Let statements can be used to create variables either from scratch, from existing data, or from Microsoft Sentinel Watchlists.
  3. It's important to properly finalize the Let statement with a semicolon to ensure the variable is stored correctly for query execution.

Holy H@&#rate!

nicosmid • 19 implied HN points • 28 Mar 23
🔮 Crypto Bitcoin Mining
  1. The network's hashrate has achieved a record high, reaching 358EH/s from 265EH/s in the first quarter of the year.
  2. There's been a 35% growth in the network's hashrate.
  3. A further increase of 7EH/s in the next few days could lead to a 100EH/s rise in the first quarter of the year.

Digest 5/19/23

axialdaily • 19 implied HN points • 20 May 23
💼 Business Biotechnology Investment Healthcare Innovation
  1. Axial invests in early-stage life sciences companies with great founders and inventors
  2. Doximity was founded to create a LinkedIn for doctors and now covers over 80% of physicians in the US
  3. Regeneron's formula focuses on having the best science and following it diligently for success

Software Engineering Radio

One Thing at a Time • 19 implied HN points • 08 Jun 23
🕹 Technology Programming Artificial Intelligence Cloud Computing Generative AI Software Engineering
  1. Dave Cross shared his experience of being a guest on a podcast to discuss GitHub Actions.
  2. Dave Cross found Generative AI tools like ChatGPT and GitHub Copilot to significantly boost his productivity in coding.
  3. Dave Cross is exploring AI services like CodeWhisperer at the AWS Summit and is looking for work opportunities in Perl, Linux, web development, databases, and more.

Debunking the Myth of Network Effects

Platform Papers • 19 implied HN points • 13 Sep 23
💼 Business Strategy Antitrust Monopoly Competition Technology
  1. Network effects can be powerful in digital platforms but may not always lead to the expected outcomes. A merger between pet-sitting platforms revealed that horizontal preferences and platform differentiation can play a significant role in user behavior.
  2. The strength of network effects can be challenging to quantify due to external factors influencing participant value. Understanding factors like switching costs and repeat exchanges is crucial in assessing the true impact of network effects.
  3. Having multiple competing platforms can be more beneficial than having a single dominant one. This diversity can foster healthy competition, innovation, and prevent monopolistic practices, highlighting the importance of antitrust regulations.

Tutorial: Exploring the Gamma AI Design Partner

Perfecting Equilibrium • 19 implied HN points • 08 Aug 23
🕹 Technology Social media Artificial Intelligence Video content Web Development
  1. The tutorial explores Gamma AI as a design partner for building a new website.
  2. There is a transition from the Industrial Age to the Information Age, creating new jobs and requiring new skills.
  3. The Perfecting Equilibrium Vlog introduces the idea of new jobs for a new age and mentions JT Tom Johnson as a reference.

The Wild Nature of Correlations

Reminiscences Of A Young & Naïve Financier • 19 implied HN points • 28 Feb 23
💰 Finance Asset allocation Financial Modeling Market Analysis Correlations Investing
  1. Correlations vary widely over different time intervals, affecting asset allocation decisions.
  2. Shorter time intervals show smaller correlations, while longer intervals have greater variability.
  3. Conservative estimates of correlations using consistent shorter intervals may be more reliable for projecting into the future.

5/19/2023: The Wonder Boy Tragedy

The Great Reset Diary 2022- • 19 implied HN points • 19 May 23
💼 Business Success Leadership Psychology
  1. Success can be detrimental, especially for extremely successful people who may struggle to cope with their situation.
  2. Extremely successful individuals are often treated as symbols and icons, leading to a disconnect in human interactions and judgment.
  3. Having honest friends who can provide accountability and keep individuals grounded may help prevent self-destructive behavior in the face of extreme success.

Coaxial Drones

Barn Lab • 19 implied HN points • 30 May 23
🕹 Technology Military Aircraft Drones Engineering Open Source
  1. Coaxial drones have improved flight efficiency and longer flight durations due to their balanced torque effect from counter-rotating rotors.
  2. Coaxial drones are simpler in design with fewer motors and Electronic Speed Controllers, resulting in reduced weight and complexity compared to quadrocopters.
  3. Coaxial drones offer larger payload capacities, less noise, and are easier to transport, but their flight mode complexity presents challenges in control design.

Mommy, daddy, is ChatGPT going to automate your jobs? | Roundup #18

Workonomics • 19 implied HN points • 28 Mar 23
💼 Business Automation Policy Economics Labor Gig Economy
  1. A study found that higher-wage jobs have a higher exposure to automation than lower-wage jobs.
  2. A tight labor market has helped reduce inequality by increasing wages for low-wage workers more than high-wage workers.
  3. Different states have proposed various gig economy regulations, such as requiring gig platforms to show drivers how much they were paid and provide benefits like minimum wage and sick time.

Pinduoduo: When Business Success Comes with Hacking

Natto Thoughts • 19 implied HN points • 26 May 23
💼 Business Technology Security E-commerce Ethics International
  1. Pinduoduo allegedly had a hacking team that exploited vulnerabilities in Android systems to gather user data and influence user behavior for profit.
  2. The head of security at Pinduoduo, a genius hacker, was dismissed for refusing to conduct hacking attacks, showcasing ethical principles in the face of company pressure.
  3. Pinduoduo's growth model involved combining social commerce with exploiting mobile vulnerabilities, leading to rapid success and potential security concerns, especially as team members moved to its subsidiary Temu.