Category Archives: Work

Select top 2 rows from records, grouped/partitioned by Unique ID

Shows the records with their new ROW_NUMBERs added and paritioned

The Problem: A client needed a query that selected the two most recent tour dates for each user ID. This is an easy task for a single user ID because specifying the user ID and an ORDER BY tour_date DESC with a LIMIT 2 clause would get the dates needed. However, when there are a lot of users it gets harder. For a single date, the MAX function works great but in our instance it will not work because we

GoDaddy changes manual renewal to auto-renewal. Lame.

GoDaddy will change your manual renewal domains to auto-renewal without asking you first :-(

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 docs -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) – Clauses and Forms  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 Law 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

(3) Apple Cinema Displays and (2) Flat screen LCD TVs

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

Results of the query

  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]

Try changing the port to 25

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

Page 2 of 1812345...10...Last »