Category Archives: Work

Negotiating an Oil and Gas Lease (Creek County OK)

Leave a comment

Recommended PDF: Lease clauses and forms, negotiation (RECOMMENDED) http://www.montana.edu/softwaredownloads/energydownloads/MineralLeasingHandouts.pdf Landmen.net – Clauses and Formshttp://www.landmen.net/clausesforms/clausesforms.htm  LEASE PROVISIONSOption to Extend Lease Surface Damages No Surface Operations Oil & Gas Only Royalty Increase Escalating Royalty Clause Minimum Royalty Clause Shut-In Royalty Clause Pugh… Negotiating Your OIl & Gas Lease | Oil, Mineral & Gas Lawhttp://www.kwgd.com/negotiating-oil-and-gas-leaseOne of the more difficult things landowners are called upon to do is negotiate an oil and gas lease.  Oil and gas leases contain many unique terms in the

Read more money tips, Work

5 monitor setup

Leave a comment

My good friend John Odom recently sent me a photo of his current office setup: John absolutely loves his three 23″ Apple Cinema Displays. I originally had one of them in college and then added another in law school. Eventually I traded them to him for some architectural work and he recently added a third to complete his setup. The two LCD TVs in the background are for viewing live reports and surveillance cameras. Overall he has a very nice

Read more computer tips, Computers, Gadgets and Tech, tech tips, Work

Count occurrences both greater than, less than, or equal in MySQL

Leave a comment

  SELECT COUNT(recycled) AS “Total”, SUM(CASE WHEN recycled = 1 THEN 1 ELSE 0 END) AS “New”, SUM(CASE WHEN recycled > 1 THEN 1 ELSE 0 END) AS “Recycled” FROM (a SELECT phone_number, count(*) AS recycled, sale_date FROM ( SELECT DISTINCT * FROM ( SELECT customers.phone_number, customers.sale_date FROM customers INNER JOIN ( SELECT customers.phone_number FROM customers WHERE sale_date BETWEEN ‘2014-05-23’ AND ‘2014-05-30’) list on customers.phone_number = list.phone_number ORDER BY phone_number DESC, sale_date DESC ) AS multiple_sales ) AS sale_dates_analysis GROUP

Read more Software Tips, Work

GoDaddy send message error on Thunderbird [SOLVED]

6 comments

Reader question (Solved, see below) Yo hoss.. Any chance you could team viewer on to my computer this morning and look at my JSO email. I have been having sending issues for a long time now, and just can’t seem to get it fixed. Every time I try and send something (especially with an attachment) I get the following error message: Most of the the time it asks me to enter my password again…. Thoughts? Answer: Please check your outgoing SMTP

Read more Internet tips, Software Tips, Work

SQL Server database and table listing

Leave a comment

I generally work with MySQL, not MS SQL Server. So when I needed some basic automated info about a SQL Server’s database/table layout I was thankful for the following two pages: Get list of databases from Sql Server – Stack Overflowhttp://stackoverflow.com/questions/147659/get-list-of-databases-from-sql-serverHow can I get the list of available databases on a SQL server instance? I’m planning to make a list of them in a combo box in vb.net. Get a list of all database on a SQL Server: SELECT name

Read more Misc Links, Software Tips, Work

Enable PHP error reporting on Turnkey LAMP Stack

Leave a comment

Recently while using Turnkey Linux I had some PHP scripts that were totally blank. This was just a local test server and I had a pretty good idea there were some PHP errors so I enabled PHP error reporting. If you are on a production server you would probably NOT want to do this. However, if you are like me and just doing some testing, here are the steps to enable error reporting: PHP error reporting is disabled – won’t

Read more Software Tips, Work

Turnkey SSH tunnel for MySQL PHP access

Leave a comment

Very useful examples at the Linux Journal: http://www.linuxjournal.com/content/creating-secure-tunnels-ssh and I finally found a connection specification that would work: root@lamp ~# mysql -h localhost -P 3308 -u root -psomepassword vlmdatabase ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysq ld.sock’ (2) root@lamp ~# mysql -h localhost -P 3308 -u root -psomepassword vlmdatabase ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysq ld.sock’ (2) root@lamp ~# mysql -h 127.0.0.1 -P 3308 -u root -psomepassword vlmdatabase The last one

Read more Database tips, Software Tips, Work

Fidelity Communications internet and phone service down

Leave a comment

The internet and phone service was down in Salem MO this morning for customers of Fidelity Communications. It was quite perplexing at first, because I was working on a wireless upgrade at the Crossroads Inn & Suites hotel in Salem. During the middle of the upgrade, internet connectivity was lost. Eventually we determined that it was not our system’s issue but rather Fidelity’s. After contacting them we learned that a router went down in Kansas City and that caused widespread

Read more Work