lgaa

vagrantfile:
    target: local
    vm:
        provider:
            local:
                box: puphpet/centos7-x64
                box_url: 'false'
                box_version: '0'
                chosen_virtualizer: vmware_workstation
                virtualizers:

lgaa

LOCK TABLES `table_name` WRITE;
SET autocommit=0;
SET foreign_key_checks=0;
SET unique_checks=0;


/*....
INSERT ... ON DUPLICATE KEY UPDATE
INSERT IGNORE INTO 
....*/

lgaa

 Sub ExportSheetsToCSV()
    Dim xWs As Worksheet
    Dim xcsvFile As String
    For Each xWs In Application.ActiveWorkbook.Worksheets
        xWs.Copy
        xcsvFile = CurDir & "\" & xWs.Name & ".csv"
        Application.ActiveWorkbook.SaveAs Filename: = xcsvFile, _
        FileFormat: = xlCSV, CreateBackup: = False
        Application.ActiveWorkbook.Saved = True
        Application.ActiveWorkbook.Close

lgaa

Example Nginx Configurations for Elasticsearch

This repository contains couple of example configurations for using Nginx as a proxy for Elasticsearch.

These examples can be run standalone from this repository -- the general pattern is:

$ nginx -p $PWD/nginx/ -c $PWD/<CONFIG FILE>

When you change the configuration, simply reload the Nginx process to pick up the changes:

lgaa

'''
@author Bommarito Consulting, LLC; http://bommaritollc.com/
@date 20131029
This script monitors and logs to CSV the status of all tunnels for all VPNs for a single EC2 region.
'''

# Imports
import boto
import boto.ec2
import boto.vpc

lgaa

import boto3
import logging
import json
import gzip
import urllib
import time
from StringIO import StringIO

logger = logging.getLogger()
logger.setLevel(logging.INFO)

lgaa

-- Permissions for a SQL Server source system:
ROLE [db_datareader]
GRANT VIEW DEFINITION
GRANT SELECT ON OBJECT::sys.sql_expression_dependencies

lgaa

.SESSIONS 2 1
.LOGON $TDPID/$USER,$PASS;
DATABASE $DATABASE;

DELETE FROM    $TABLENAME ALL;
DROP TABLE     $TABLENAME_ET;
DROP TABLE     $TABLENAME_UV;

BEGIN LOADING  $TABLENAME
ERRORFILES     $TABLENAME_ET