Workaround here

http://www.mrexcel.com/forum/showthread.php?t=337885

the annoying grey bar is actually part of your tool bars. Why it shows up is anyones guess, but to make it go away, put a tool bar over then and then a) move it back to the top, or b) hide it.

I am upgrading around 100 projects from 2.0 and 3.5 and was wondering if there was a bulk update in VS 2008 that I wasn't aware of.

Doing some searching it would seem not

One alternative would be write an application to add a few items to the csproj file.

(System.Data.Entity added to target 3.5 SP1)

http://msdn.microsoft.com/en-us/library/bb398197.aspx

In the end I did it manually

There have been numerous article recently on the performance of the FTSE over the last decade

http://www.telegraph.co.uk/finance/markets/ftse100/6913344/FTSE-100s-recent-rally-fails-to-make-up-for-a-lost-decade.html

with only a few commenting on the effect that dividends have on returns

http://business.scotsman.com/economics/Dividends-help-investments-pay-off.5951967.jp

The FTSE 100 sans dividends is down 22% over the period

whereas if we included dividends, we would get a return of around 8%

This is still pretty poor compared to the (very approx) 45% you would've got if you had invested at the base rate

this emphasizes the point that to achieve returns in excess of risk free, one must take a risk. The longer the investment, the less chance of being underwater at maturity, but that risk will always be there.

Just over a year ago I commented on the fact that several bodies in the housing market refused to give their predictions

http://www.noelwatson.com/blog/CommentView,guid,87934429-905b-4f5e-8b88-8a876b6a3fbc.aspx

As it turns out, they were all wrong, with both Halifax and Nationwide showing gains YOY.

Whether this will continue when/if QE is withdrawn and interest rates rise remains to be seen.

This was a lot easier than 70-433, and with no problems this time round

http://www.noelwatson.com/blog/PermaLink,guid,52983d44-0dc9-45da-bc15-12edb0847f72.aspx

I completed the test in around an hour

Snapshot vs. Serializable

http://blogs.msdn.com/craigfr/archive/2007/05/16/serializable-vs-snapshot-isolation-level.aspx

Partition level locking

http://www.sqlskills.com/BLOGS/PAUL/post/SQL-Server-2008-Partition-level-lock-escalation-details-and-examples.aspx

Lock compatibility

http://msdn.microsoft.com/en-us/library/ms186396.aspx

Sat my first exam over a decade ago, have done around 20 since then but haven't sat any since 2003. I fancied looking at the 2008 qualification to see what was new in 2008 (currently have experience with SQL 7-2005). I bought the MS book

http://www.amazon.co.uk/MCTS-Self-Paced-Training-Exam-70-433/dp/0735626391/ref=sr_1_1?ie=UTF8&s=books&qid=1259307240&sr=8-1

read that and then bought ther Transcender to see what areas the book hadn't covered

http://www.transcender.com/product.aspx?product_id=Cert-70-433

The problems started when I attempted to book the test at a test centre near me

and got this message. I phoned up the help desk and was informed that this error message indicated that the testing centre in question did not offer that particular exam. Instead I booked the exam at QA in Holborn.

I turned up at the testing centre yesterday and was informed that because of earlier problems with the Prometric system, I wouldn't be able to start my exam at the scheduled time. Eventually I was able to start at around 15 minutes after planned.

The first few questions were completely different to Transcender - fortunately I was able to rely on experience gained over the years. The problems started when I got to one of the questions as instead of seeing an embedded screenshot instead saw code that was intended to display the image. Two other questions referred to an exhibit, but teh exhibit button was nowhere to be seen! Another question had some XML that wasn't displayed properly. Finally, one of the questions had two answer options that appeared to be the same.

I complained to the attendant, he contacted Prometric and they suggested rebooting the box. This made no difference - when rebooted the test continued where it had left off. By this point I was fed up, and was seriously considering coming back another when they had sorted the test out. However, when I completed the test I thought I may as well go back through and check my reponses, and guess the questions mentioned above. I completed the test and left a few choice comments. It took an age for the results to come up, and imagine my surprise when I had passed!

The drama wasn't over yet. I went up to reception to pick up my exam results. However, the results had not yet been printed. After the drama, I was convinced that the results had been lost, but after waiting around for quarter of an hour, the printer was fixed and I had my piece of paper. Next stop 70-451

Saw a leaflet in the FT today. Can't find it on the website, but found this

http://www.lloydsbankinggroup.com/media1/research/qtrly_regional_comments.asp

Interesting to see that Greater London is already 25% off peak

Was ~320k (this figure has been adjusted)

http://www.noelwatson.com/blog/PermaLink,guid,f6aea8d2-ce5c-42d4-8d20-90fd4d636840.aspx

(rows 1285 on 2nd and 3rd tabs)

http://www.lloydsbankinggroup.com/media/excel/24_04_09historicdata.xls

Now £241,306

http://www.lloydsbankinggroup.com/media/pdfs/research/GreaterLondonQ12009.pdf

Wikipedia page

http://en.wikipedia.org/wiki/Eric_Rosenfeld

Good read

http://www.amazon.co.uk/When-Genius-Failed-Capital-Management/dp/1841155047/ref=sr_1_1?ie=UTF8&s=books&qid=1240932983&sr=8-1

I have mentioned before that there is a link between mortgage approvals and house prices six months from now

http://www.houseprices.uk.net/articles/house_price_predictor/

and I thought I would look at when approvals started heading south

BBA:

BOE

In July 2007, both BBA and BOE approvals dropped dramtically. That is not to say that they wouldn't pick up again, but couple this with the Goldman hedge fund

http://business.timesonline.co.uk/tol/business/industry_sectors/article2253691.ece

and the XOver breaking through 500

http://www.noelwatson.com/blog/PermaLink,guid,3a000888-e5df-4208-9515-01586f6332f2.aspx

indicated that as was not well. Did we know then that things were going to be as bas as they are? Probably not - see my comments on whether the XOver would break through 1000.

UK GDP numbers are released in theory a total of three times for a given quarter. For Q4 we have

23/01/2009: Advance

25/02/3009: Preliminary

27/03/2009: Final

Q3 final number (23/12/2008) was -0.6% (revised down from -0.5% (P)), and has subsequently been revised down to -0.7%

Today's Q4 preliminary number was unchanged at -1.5%

Looking at the bigger picture, things aren't quite as bad as the 90s recession. Yet.

http://www.ft.com/cms/s/0/47931550-f874-11dd-aae8-000077b07658.html

Reading this article, I was wondering whether the two statements
"Even under what seem like extreme scenarios for UK and US house prices, many people agree that few mortgage bonds outside subprime definitely look expensive. "
"Also, for example, Fitch Ratings recently said that under its stress testing, which included the assumption of a 30 per cent fall in house prices, no mortgage bond rated triple A in the UK would see a downgrade."
are linked. In particular, is 30% fall in house prices considered to be an extreme scenario?  I belive the 30% reflects a peak to trough estimate

http://www.ft.com/cms/s/0/8305276e-ebdf-11dd-8838-0000779fd2ac.html

yet when the derivatives market are pricing in 46% peak to trough,

http://www.tfspropertyderivatives.com/pdf/RISK&MANAGE/2009/Feb-09.pdf

30% seems very optimistic.

http://www.ft.com/cms/s/0/fb6d3b8c-f8a6-11dd-aae8-000077b07658.html

"The world's most highly rated countries have for the first time been put into different categories reflecting their risks for credit downgrades, in a sign of the deepening financial crisis."

Reuters have done a little diagram

http://uk.reuters.com/article/UK_COMKTNEWS_MORE/idUKLB77042220090212

It appears that the UK is not best placed after all. Quelle surprise!

"Law firms offering graduates a median starting salary of £37,000 a year remained the highest payers. Investment banks were in second place, offering £35,000.

In third place, at £28,000 a year, were the business and financial services sectors"

http://www.ft.com/cms/s/0/53e54c1e-f0af-11dd-972c-0000779fd2ac.html

"Gordon Brown was on Sunday night accused of having “learnt nothing” from the economic crisis after he defended unorthodox mortgage loans worth 125 per cent of the value of a home.

After he was pressed on whether he should “shoulder the blame” for lax lending practices, Mr Brown insisted “high percentage mortgages” were fine as long as interest rates were low"

Astonishing that he believes this.

http://www.noelwatson.com/blog/PermaLink,guid,bc024a3b-6d2a-4ea1-bd0e-052811080655.aspx