quephird

SQL Tricks

Contents

• Purpose
• Nota bene
• Example schema
• Selecting records
  • How do I get a list of items and the sum of another column in a table?
  • How do I concatenate a list of string values each relavant to a row?
• How do I get a list of items and filter the result set on some aggregate?

warewolf

#!ipxe

# boot-url and sanboot-url is set in bootstrap.ipxe

# Setup some basic convenience variables
set menu-timeout 5000
set submenu-timeout ${menu-timeout}
set base-iqn iqn.2012-12.com.xabean.sandbox
set base-iscsi iscsi:${iscsi-server}:::1:${base-iqn}

thwarted

#!/bin/bash

# find all supermicro Java iKVM Viewer windows and resize
# them to display all the content
#
# for reasons that are beyond sanity, this shitty closed source program
# sets the min and max window sizes to the same values, making it unresizable
# through dragging.
# this wouldn't be so bad if it actually resized the window to display all
# the content.  it constantly resizes based on the resolution of the 

cloudtobutt.user.js

// ==UserScript==
// @name s/the cloud/my butt/g
// @description Replaces the word "the cloud" with "my butt".
// @match *://*/*
// ==/UserScript==

function buttize(str) {
  return str.replace(/the cloud/g,"my butt")
    .replace(/the Cloud/g,"my Butt")
    .replace(/The Cloud/g,"My Butt")

robinsmidsrod

Add the following chunk to your existing ISC dhcpd.conf file.

if exists user-class and ( option user-class = "iPXE" ) {
    filename "http://boot.smidsrod.lan/boot.ipxe";
}
else {
    filename "undionly.kpxe";
}

(or see https://gist.github.com/4008017 for a more elaborate setup