I'm very ghetto

I shat out a quick connectwise to KML python script so sales ppl can look at their turf in google earth and etc.  I am a bad person.  Bad in every way.  This will be refined into something I'm not embarrassed of, but I was surprised something like this wasn't on the internet already.

import pyodbc

from geopy.geocoders import Bing

import simplekml

bingkey="lsdfkglksjdfglksfdhlkjghsdlkfjhglskdfjhgsjdgjsjdf"

geolocator = Bing(bingkey)

kml = simplekml.Kml()

conn = pyodbc.connect('Driver=FreeTDS;Server=10.x.x.x;port=1433;uid=sqlreporting;pwd=blabalbalbalablab;database=blerblebleblrblebr')

cur = conn.cursor()

q="""

SELECT Company.Company_Name,Address_Line1,City,State_ID,ZIP

from Company INNER JOIN Company_Address on Company.Company_RecID=Company_Address.Company_RecID

and Company.Company_Status_RecID=1

"""

cur.execute(q)

i=1

for row in cur.fetchall():

        address=''

        company = row[0]

        addressline1 = row[1]

        addresscity = row[2]

        addressstate = row[3]

        addresszip = row[4]

        if (isinstance(addressline1, str) and isinstance(addresscity,str) and isinstance(addressstate,str)):

                address = addressline1 + ' ' + addresscity + ' ' + addressstate

        fulladdress=''

        latitude=''

        longitude=''

        try:

                fulladdress, (latitude, longitude) = geolocator.geocode(address)

        except:

                print("found a bad address: " + company + ' ' + address)

        if (fulladdress != ''):

                print (i, company)

                kml.newpoint(name=company, coords=[(longitude,latitude)])

        i=i+1

kml.save("bigtest.kml")

cur.close()

conn.close()

trailroc 255

new pair showed yesterday.  fit like a glove here in the house.  will run in them later.  the red/black ones are like $120 but the purple/orange can be had for $75.  such is life.

solving problems methodically

Scope the problem
-give it a name
-can it be measured
-can it be recreated at will
-with what frequency does it occur
-what else is is correlated with
-what is the definition of success
-what tests can be methodically executed to generate data
-how can data be collected
-what variables are involved that can be modified
edit:
-when did it start
-what other changes in may have occurred at or around that time

If you can measure it, you're in good shape.

datacenter crap

A misogynistic mnemonic:

C13-C14 is what you need most of.  C13 is the female end, cuz females are odd.  Hurr durr.

C19-C20 are the other ones, for UCS and HP chassis.  Again, C19 is female.

C14-C15.  Well, there's a notch in the C15 side.  For 4500s and other boxes that think they're going to get hot.

more cisco 4500s in a couple of weeks

Going to run and set up another set of 4500-X switches for a customer in the next couple of weeks.  This is my 3rd set.  I suppose I'll document that for the benefit of the world.

Initial thoughts: always check your airflow, your lead time, and your power cables (c14-15)

CCDP SWITCH thursday

Last test I need for CCDP.  Mainly just poking at the internet for topics and sample questions/labs.  This is a lot of my daily driving at work so I'm not too concerned.

next up, CCDE in August or November, or, maybe VCP->VCAP.  Depends on which impacts employer's vendor relationship most.

run faster

did my 4 mile "from-the-office-to-enger-and-back" @ 9:45 avg pace.  felt good.

ordered a new set of inov-8 trailroc 255 (3rd pair in a row).  Every pair of them I've had is like putting on well worn glove.  It's absurd.  I moved from roclite 315s (after 3 pairs) which required some break in time.  last year I got my new set of trailrocs ~1 week before the curnow tail marathon and went for I think a single 5 mile run in them before taking them out for 26.  My feet were unbothered.

TL;DR, the inov-8 trailroc 255 is the best trail shoe I've ever come across (for me, and what I do).

running a long ass ways

The trail marathon in question is http://www.curnowmarathon.com/

My goal is 6 hours.  We'll see about that.  I do my Chester loop daily (3.3ish, rather aggressive miles: http://runkeeper.com/user/59481260/route/3206511) at 10 minute miles as well as a loop out of downtown from the office (also, 3.something, also 10 minute miles: http://runkeeper.com/user/59481260/route/3181524)

that's pretty much the extent of my "training" aside from the occasional 7 miler.

intro

Maintaining something like a blog seems to be a thing to do.

I'm a network engineer for a network and managed services company.

Im looking to have my CCDE wrapped up in a couple of months here, so, I'll post on that progress.  Probably go do some other cert-type things (vmware, juniper, etc), whatever boosts my employer's partner status the best.

I'm also looking to up my ultra marathon skills.  I have a trail marathon (not quite an ultra, I know, but gotta start somewhere) next month.  We'll see how that goes.  I did a couple of trail marathons last year.  They were hard.  I'd like to pull off a 100 miler before I die.

Openstack is of interest to me.  Going to proof of concept it in the coming weeks, hopefully launch as a product (both as an addition to our current public cloud offerings, as well as turn-key private cloud deployment).

Hmm, what else?  Looking at starting a programming/engineering program for local kids.