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…

Snappening torrent download [verified]

Random Blurred Screenshots (not of the snappening)

The Snapchat service is in the news again. After their previous leak of sensitive user info another issue has occurred. The use unauthorized third party clients resulted in thousands of user images being hijacked. “The Snappening”, as this leak has been dubbed, features regular non-celebrity people. You can find the download links below: The Snappening is different than other recent photo leaks such as The Fappening, The Fappening 2 and the Fappening 3 which all prominently featured Jennifer Lawrence and other celebrities. Regardless, these types of security issues make me

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 3 of 11212345...102030...Last »