cmbaughman

Fixing SQL Query Performance With CTEs

Original query. Execution time: 127 seconds. +150 million rows.

SELECT
    c.customer_id,
    c.segment,
    SUM(t.amount) AS total_spent
FROM customers c

cmbaughman

Cool CSS Only Stuff

CSS Only Modals

<a href="#modal">Open Modal</a>

<div id="modal" class="modal">
  <a href="#" class="close">×</a>
  <p>This is a CSS-only modal window!</p>

cmbaughman

// Download file
export function downloadFile(url, filename) {
  const a = document.createElement("a");
  a.href = url;
  a.download = filename;
  document.body.appendChild(a);
  a.click();
  document.body.removeChild(a);
}
// Example: downloadFile("/resume.pdf", "MyResume.pdf");

cmbaughman

@echo off
setlocal

:loop
powershell -command "[void][System.Windows.Forms.Cursor]::Position = New-Object System.Drawing.Point((Get-Random -Minimum 0 -Maximum 1920), (Get-Random -Minimum 0 -Maximum 1080))"
timeout /t 300 /nobreak >nul
goto loop

endlocal

cmbaughman

// Get connection speed
if (navigator.connection) {
    const downlink = navigator.connection.downlink;
    console.log(`Current download speed: ${downlink} Mbps`);
} 
else {
    console.log("Network Information API not supported");
}

// Mobile device vibrate

cmbaughman

[*]
charset = utf-8
end_of_line = lf
indent_size = 2
indent_style = space
insert_final_newline = true
trim_trailing_whitespace = true
quote_type = single

### Frontend files

cmbaughman

# Windows God Mode

Create a folder anywhere you want a shortcut to
every setting imaginable called `GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}`

That's it. I got this from Twitter or something.

cmbaughman

Installing Docker on Ubuntu

Setup

1. Make sure you have gnome-terminal installed:

sudo apt install gnome-terminal

2. Get rid of older versions if you have them:

for pkg in docker.io docker-doc docker-compose docker-compose-v2 podman-docker containerd runc; do sudo apt-get remove $pkg; done

cmbaughman

To copy some files from one directory to another can be done kinda nicely with the find command.

1. First define the start date: touch --date "2024-01-01" /tmp/start
2. Define the end date: touch --date "2024-02-01" /tmp/end
3. Now simply craft a find command like this:

find /var/logs/some_dir -type f -newer /tmp/start -not -newer /tmp/end -exec cp "{}" /opt/another/directory \;

NOTE: In the above command, the -exec part of the find uses "{}" as where it puts each filename

cmbaughman

Ubuntu as a replacement for Windows Network server

Set up an Ubuntu Server as a standalone Windows network server. In this scenario, we'll assume that you want to replace an existing Windows domain server with the Ubuntu server. Here are the steps:

1. Install Ubuntu Server:

   • Start by downloading the Ubuntu Server ISO image from the official Ubuntu website.
   • Create a bootable USB drive or mount the ISO on your server.
   • Follow the installation prompts to install Ubuntu Server. During installation, choose the appropriate options for language, keyboard layout, and network configuration.

2. Configure Network Settings: