Category Archives: Bransons Nantucket

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

Dell PowerEdge 1950 III Drivers and Firmware Updates (2013)

I recently set up two new Dell PowerEdge 1950 III servers. One for (free blog hosting) and one for Branson’s Nantucket (a lakefront resort in Branson). Dell makes very nice servers but their support pages can be a bit confusing. Therefore, here are the latest updates/drivers for the PowerEdge 1950 III, as of July 2013: Latest Dell PERC 6/i Integrated Update, v.6.3.1-0003, A14 1. Fixes an issue where the Perc battery does not always charge up properly, causing Virtual Disks

New RCI resort option for Branson MO

If you are looking for an RCI timeshare option in Branson MO, look no further Branson’s Nantucket a RCI Gold Crown Resort and Branson’s Nantucket, LLC today announced that Branson’s Nantucket Resort in Branson, Mo., has affiliated with RCI, the worldwide leader in vacation exchange. As part of this affiliation,… Their location overlooks Table Rock Lake and has easy access to Branson for when you want to head into town.

Branson’s Nantucket free Wi-Fi review

Excellent signal strength

I am staying at Branson’s Nantucket a few days this week so I have had a good chance to test their free WiFi. Connecting, Signal Strength The wifi is free in all the units and I received simple login instructions and password upon check-in.  Connecting was easy, I had no problems and overall the wifi signal quality is excellent: (each unit has its own secure encrypted connection/router/SSID, the lower strength signals are other units) Both my wife and I were