Format SQL code

I have been writing copious quantities of SQL lately. Some of the queries are getting really long. When I am working with Navicat it has a nice ‘SQL beautify’ feature that takes messy SQL and makes it nice and tidy. 🙂 While that features is great when using Navicat for SQL editing, sometimes I need to workdirectly with SQL Server 2008 there is no comparable feature built into Microsoft’s SQL pane. 🙁 Thankfully, with a quick copy/paste there is an online tool

Intel Centrino 6235 or 7260 Bluetooth not detected by Windows [SOLVED]

I came across an interesting tip today: […] Samsung RC530 and a 7260.HMWWB. Bluetooth can’t be activated on some notebooks, so you need to activate it manually with a hardware “hack”. Just get some Scotch Tape / Sellotape (in german “Tesafilm”) and stick it on pin #51 (picture). Put the card back in the PCIe slot and have fun . […] this workaround works also for the 6235 and other Intel Wifi/Bluetooth cards.. via Intel Communities. Well worth checking out

Pavestone retaining wall choices for timber frame home

Pavestone has a nice selection of retaining wall rock. These were the specific options we chose for our retaining walls around our house: Pavestone | Pavers, Retaining Walls, Patio Stones & Edginghttp://www.pavestone.com/Beautify your outdoor living spaces with Pavestone’s elegant collection of pavers, retaining walls, patio stones and edging. Our stone and concrete brick paving products transform landscapes…

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

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

AT&T LTE data speeds in Low Wassie MO

This result is quite good considering the rural location as well as the trees/hills. Nice job AT&T! 🙂 This test was on a Lumia 635 no contract phone which is often available for less than $80 USD. AT&T Nokia Lumia 635 – No Contract GoPhone: Cell Phones & Accessorieshttp://www.amazon.com/gp/product/B00LBFFSNM?ie=UTF8&tag=pixensity-20&linkCode=as2&camp=1789&creative=390957&creativeASIN=B00LBFFSNMThe Lumia 635 isn’t your average smart phone. Powered by Windows Phone 8.1, a Quad core processor and supporting a microSD card of up to 128 GB of memory, it’s fast and

AT&T mobile insurance vs AT&T mobile protection pack

If you are buying a phone from AT&T online, you will likely be prompted to choose one of the following: My question was: what exactly is the difference between “mobile insurance” and “mobile protection pack”. The answer is, not much. Specifically, the “protection pack” adds: “personalized technical support; and an app to find your device.” The insurance is the exact same that you can get for $3 less if you choose only the insurance. What is surprising is that many phone manufacturers

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?

Page 30 of 139« First...1020...2829303132...405060...Last »