Skip to content

Instantly share code, notes, and snippets.

@paulrossman
paulrossman / encrypted_dual_boot_xps_17.md
Created July 24, 2022 23:35 — forked from ourownstory/encrypted_dual_boot_xps_17.md
Encrypted dual boot setup for Pop!_OS and Windows 10 using LUKS and Bitlocker on Dell XPS 17 9700

Encrypted dual boot setup with Pop!_OS and Windows 10

How to guide, using LUKS and Bitlocker on Dell XPS 17 9700

This guide is for those who want to use their XPS 17 in dual boot with their (preinstalled) Windows 10 and a new Pop!_OS installation, without giving up Bitlocker Encryption in Windows nor LUKS encryption in Linux.

The only guides that I could find were for Ubuntu, which it should be identical to, but I found the ommission of a few steps to resolve issues that I encountered in my first install attempt. Hoping to save you some trouble, I am sharing the steps that worked for me, linking the original guides that I found useful.

1. Preparation

  • 1.1 Of course: Backup all your data! You always do this when people tell you to, right? Maybe this time better be safe than sorry.
  • 1.2 Safely note your Bitlocker recovery key somewhere off your XPS. Where to find it
@paulrossman
paulrossman / forkcount.sql
Created October 20, 2015 06:04
BigQuery sql for GitHub Archive dataset: fork count per repo
/* fork count per repo */
SELECT
REGEXP_REPLACE(repo.name, 'MyOrg/', '') AS repo,
COUNT (*) AS cnt
FROM (
SELECT
type,
repo.name,
FROM
@paulrossman
paulrossman / issuelatency.sql
Created October 20, 2015 00:27
BigQuery sql for GitHub Archive dataset: issue close latency for issues opened after 2015-01-01 @ 00:00:00 UTC and closed before 2015-01-31
/* issue close latency for issues opened after 2015-01-01 @ 00:00:00 UTC and closed before 2015-01-31 */
SELECT
REGEXP_REPLACE(repo.name, 'MyOrg/', '') AS repo,
CEIL((closed_at-created_at)/86400) AS latency,
FROM (
SELECT
type,
repo.name,
JSON_EXTRACT(payload, '$.action') AS event,