Category Archives: Work

GoDaddy changes manual renewal to auto-renewal. Lame.

GoDaddy: “Unless you have specifically selected the manual renewal option, your purchase includes enrollment in our automatic renewal service” This domain was set to manual renewal and I did not even notice an option during the checkout process to “keep” it that way, instead GoDaddy automatically set it to automatic renewal 🙁 I am not a fan of that. On renewal why not have leave it at the domain’s previous renewal designation?

Enable remote MySQL connections on Turnkey Linux LAMP

I am a big fan of Turnkey Linux. It is great for working on projects locally, though sometimes I need to allow others access to the MySQL server on our LAN. Here are simple instructions for enabling remote MySQL connections and for allowing user access: How to allow remote access to databases | TurnKey GNU/Linux docshttp://www.turnkeylinux.org/docs/database-remote-accesssed -i “s/^bind-address/#bind-address/” /etc/mysql/my.cnf Configure MySQL to accept remote root connections (from any host (‘%’)): (added line breaks for readability) 🙂

Negotiating an Oil and Gas Lease (Creek County OK)

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

5 monitor setup

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

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

  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

GoDaddy send message error on Thunderbird [SOLVED]

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

SQL Server database and table listing

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