iOS 7.0.2 Released

iOS7Apple has released iOS 7.0.2 for iPhone, iPad, and iPod touch. This is a bug fix release that focuses on rectifying an issue that could allow users to bypass the passcode unlock on the Lock screen. Another fix in this release is to re-add the Greek keyboard options for pass codes.

iOS 7.0.2 also brings iOS 7 parity across all supported devices. Alongside the launch of the new iPhones, Apple released iOS 7.0.1, but this release was exclusive to the iPhone 5s and iPhone 5c, and did not apply to the other supported iOS 7 devices.

Today’s update requires a WiFi connection to download and install, and the file size is approximately 19MB in size but this can vary based on which device you are updating.

To update go to SettingsGeneral and then Software Update to get the update.

SQL Adding Row Number To The Returned Rows

Its something that took a bit of finding, but is very simple to do. I wanted to automatically add a row number to returned rows from a table in a database

e.g.

SELECT FirstNames, LastName, DOB FROM Staff ORDER BY FirstNames ASC

returns

FirstNames LastName DOB
Richard Taylor 01/01/1980
James Watts 01/01/1980
Richard Stringer 01/01/1980

we can modify this so that it returns a row number by changing the SQL as follows:

SELECT ROW_NUMBER() OVER (ORDER BY FirstNames) As RowNumber, FirstNames, LastName, DOB FROM Staff ORDER BY FirstNames ASC

now returns

RowNumber FirstNames LastName DOB
1 Richard Taylor 01/01/1980
2 James Watts 01/01/1980
3 Richard Stringer 01/01/1980

NB. The ROW_NUMBER() Requires that the over keyword be included after it, and that the order you choose should be the same as the order by on the query.

If you know how to do this in a different way, or a way that will work for a query that does not have an order by (a very rare occurence) then please do post a comment to let others know.

Netgear WG102 with latest firmware doesn’t allow MacBook Air to connect

wg102_tcm122-53787Its a really annoying problem – the Wifi works for a lot of laptops but not with others.

The problem we had was with a 2013 MacBook Air connecting to a NetGear WG102 with the latest firmware 5.0.3

A 2012 MacBook Pro Retina and numerous other laptops were fine, but the issue persisted with the MacBook Air.

To solve the problem, we reverted the access point back to 5.0.1 (download only the right version for where you are in the world). All devices can then access the wifi.

http://kb.netgear.com/app/answers/detail/a_id/10899/~/wg102-firmware-version-5.0.1

 

Using savings accounts to try to prevent big future and annual bills

Many years ago I watched a programme on TV about “Managing your money” and there was a very wise man on there who said that he had “about 20 savings accounts and put a small amount of money into each every month” to save there being any large scary bills once a year, or once every few years.

I decided about 2 years ago to adopt this scheme, but perhaps not quite to his extreme, and this is what I now do, which so far appears to be working exceptionally well.

  • Christmas Account – £25 per month (Allows for  £300 of present buying every Christmas)
  • White Goods Account – £8 per month (Allows for 1 new white-goods appliance every 5 years)
  • Car Insurance Account –   £19 per month (Allows for my car insurance at £230 per year)
  • Car Servicing and Tyres Account – £35 per month (Allows for one service every year and new tyres every 5 years)
  • Car Road Tax Account – £40 per month (The real down-side of owning large 4×4 family vehicle – the extortionate road tax of £460 per year)
  • House Fixing Account – £5 per month (To allow for minor fixtures and fittings a lightbulbs etc)
  • Birthdays Account – £15 per month (Gets expensive with a large family!)
  • Rates Account – £50 per month (The equivalent of council tax for those on the UK Mainland)
  • Clothing and Shoes Account – £3 per month (A new jumper or pair of jeans most years and a new pair of trainers every 3 years)
  • Heating Account – £50 per month (Allows for a fill up of oil once per year at £560)

Total outgoings to savings accounts every month:  £250.00

Hopefully this will give you some ideas! It really does work!