Aardvark’d: 12 Weeks with Geeks

Aardvark’d: 12 Weeks with Geeks is a 2005 documentary film about the development of Fog Creek Copilot, a remote assistance software tool. Conceptualization of the film began when Fog Creek Software CEO Joel Spolsky announced on his blog that he was seeking a filmmaker to document the development of the product, then called Project Aardvark.[1][2]

https://en.wikipedia.org/wiki/Aardvark%27d:_12_Weeks_with_Geeks

https://www.imdb.com/title/tt0813987/

Hardcore Software by Steven Sinofsky

Hardcore Software is a non-fiction, first-person account of the rise and fall of the PC revolution serialized through this platform, one section at a time, once or twice a week.

https://hardcoresoftware.learningbyshipping.com/archive

Through this first person account of Steven Sinofsky’s time at Microsoft, he aim to convey to you an insider’s story of growing influence and corporate obstacles, the evolution of technology that changed the world, and most of all the people that made it happen.

Check out companion videos and demonstrations of legacy products on the YouTube Channel.

https://hardcoresoftware.learningbyshipping.com/archive

What is it like to work with Microsoft’s Dave Cutler?

Dave is one of the most inspiring people I worked with (not closely, to be clear). Not only did he lead the team that built a new OS from scratch that was still compatible with DOS-based Windows, with many features on day one that took years to arrive in competitor’s products, he personally designed and coded the portable, multithreading, multiprocessor, secure NT kernel. He was brilliant.

https://www.quora.com/What-is-it-like-to-work-with-Microsofts-Dave-Cutler

Ex-Microsoft programmer Dave Plummer: I wrote Task Manager

The Microsoft developer who wrote Task Manager, along with other utilities and games, has popped up to „write this stuff down before I forget it all“.

A post on Reddit goes into detail about the tool, familiar to every Windows expert, which if you are lucky lets you terminate errant applications or processes, as well as providing some handy stats on how your PC is or is not performing.

Dave Plummer, or davepl, „started in MS-DOS in 1993 and spent a little more than a decade at Microsoft, leaving after Server 2003“, he told the University of Regina. He talked about the challenges of „coding for a billion machines“, saying: „It’s like you’re building one bull to be released into an infinite number of china shops.“

https://www.theregister.com/2020/05/26/task_manager_confession/

Github: Blazor ressources

Blazor is a .NET web framework using C#/Razor and HTML that runs in the browser with WebAssembly.

Interactive web UI with C#

Blazor lets you build interactive web UIs using C# instead of JavaScript. Blazor apps are composed of reusable web UI components implemented using C#, HTML, and CSS. Both client and server code is written in C#, allowing you to share code and libraries.

Blazor is a feature of ASP.NET, the popular web development framework that extends the .NET developer platform with tools and libraries for building web apps.

Details on github: https://github.com/AdrienTorris/awesome-blazor

Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL

https://trino.io

Trino is a highly parallel and distributed query engine, that is built from the ground up for efficient, low latency analytics.

Access data from multiple systems within a single query. For example, join historic log data stored in an S3 object storage with customer data stored in a MySQL relational database.

https://github.com/andreas5588/trino

Intersystems IRIS \ Docker \ Openflights Dataset

Some links about the topic from title

https://github.com/andreas5588/openflights_dataset

https://community.intersystems.com/post/using-docker-container-group-iris-openflights-dataset-and-apache-zeppelin

https://community.intersystems.com/post/tips-and-tricks-brand-new-load-data-command

https://hub.docker.com/r/andreasschneiderixdbde/openflights-iris-zeppelin

https://hub.docker.com/r/andreasschneiderixdbde/openflights-iris

https://openexchange.intersystems.com/package/openflights_dataset

https://www.kaggle.com/datasets/sherrytp/airline-delay-analysis/code

The Million Song Dataset Challenge aims at being the best possible offline evaluation of a music recommendation system
https://www.kaggle.com/c/msdchallenge/overview

Do you want to query complex data structures in an iterative way? Do you have access to hierarchical data structures that need to be queried? This course will teach you the tools required to solve these questions. You will learn how to write recursive queries and query hierarchical data structures. To do this, you will use Common Table Expressions (CTE) and the recursion principle on a wide variety of datasets. You will, for example, dig into a flight plan dataset and learn how to find the best and cheapest connection between two airports. After completing this course, you will understand the principle of recursion, and be able to identify and create hierarchical data models.

https://www.datacamp.com/courses/hierarchical-and-recursive-queries-in-sql-server

This article aims at showing good practices on how to retrieve data with SQL using practical examples on the data above. The following topics are covered:

  • operations on columns
  • most common joins
  • aggregations and window functions
  • tips to handle complex queries

https://www.mit.edu/~amidi/teaching/data-science-tools/tutorial/queries-with-sql/

Have you ever wondered about the differences between a subquery and a common table expression (CTE) in SQL? The concepts seem very similar, but knowing the difference – and when to use each one – will help you write efficient and readable queries.

https://learnsql.com/blog/sql-subquery-cte-difference/