Format SQL code

This gets hard to read, we need to tidy/beautify this 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 that can

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

Intel wifi card in Lenovo X220, before connecting blue antenna

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

Sand blend rock color choice

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

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

AT&T LTE data speeds in Low Wassie MO

Speedtest.net Results!

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 smooth.…

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

You may end up paying for features that your device manufacturer already provides

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

Page 20 of 129« First...10...1819202122...304050...Last »