Skip to content

Instantly share code, notes, and snippets.

@john-delivuk
john-delivuk / sp_generate_inserts.sql
Last active November 7, 2016 21:02
This is a first attempt at making something we can scrape transactional tables and commit them to our git repo, while dealing with sensitive values in memory
SET NOCOUNT ON
GO
PRINT 'Using Master database'
USE master
GO
PRINT 'Checking for the existence of this procedure'
IF (SELECT OBJECT_ID('sp_generate_inserts','P')) IS NOT NULL --means, the procedure already exists
BEGIN
@john-delivuk
john-delivuk / ec2_sd_config
Created March 20, 2018 18:26
A great starting place for an ec2 node exporter which binds metadata and tags.
- job_name: service-ec2
scrape_interval: 5s
scrape_timeout: 5s
metrics_path: /metrics
scheme: http
ec2_sd_configs:
- region: us-east-1
refresh_interval: 1m
port: 9100
relabel_configs: