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?

sanchezzzhak

SELECT table,
    formatReadableSize(sum(bytes)) as size,
    min(min_date) as min_date,
    max(max_date) as max_date
    FROM system.parts
    WHERE active
GROUP BY table

f3ew

Ryan Frantz defined monitoring at http://www.ryanfrantz.com/posts/solving-monitoring/ as

Monitoring is the aggregation of health and performance data, events, and relationships delivered via an interface that provides an holistic view of a system's state to better understand and address failure scenarios.

---

Here's my alternative definition

• Monitoring is the detection of variation outside the steady state of the business.

reyjrar

$ ./bin/bit-whois.pl adobe.com
adobe.com variation bdobe.com is taken (ns01.domaincontrol.com)
adobe.com variation aeobe.com is !! ERROR !!
   No Match Domain!
adobe.com variation acobe.com is taken (ns1.s416.sureserver.com)
adobe.com variation adpbe.com is taken (ns2.hastydns.com)
adobe.com variation adnbe.com is ** AVAILABLE **
adobe.com variation adoce.com is taken (ns2.warptech.net)
adobe.com variation adoae.com is ** AVAILABLE **
adobe.com variation adobf.com is ** AVAILABLE **

reyjrar

#!/usr/bin/env perl

use strict;
use warnings;

use HTTP::Status;
use URI;

use Snort::Rule;