John Delivuk 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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| - 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: |
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |