solrevdev

Wednesday, January 13, 2010

Trapped at work!

Service Condition Report
The latest travel news from the Oxford Bus Company at 0945
The conditions have deteriorated so badly in the last hour. The roads are now so dangerous that we have had to suspend all our services for the time being. Many of the main roads are now like ice rinks.
The espress service to London and the airline service to Heathrow and Gatwick have been suspended too as its impossible for us to get out of the city centre safely.
We have told our drivers to complete the journeys they are currently on and then return as carefully as possible to the depot.
We will review the situation again at 2pm.

via oxfordbus.co.uk

I'm trapped at work!

Posted via web from solution revolution

Tuesday, January 12, 2010

Oz firm seeks talented IT developer • The Register

via theregister.co.uk

Posted via web from solution revolution

Google suggests Islam is nothing • The Register

via theregister.co.uk

I wonder what happens if you type 'the register is' into google. Or 'google is' ?

Posted via web from solution revolution

Sunday, January 10, 2010

How to Change your Blogger Title Tags

via bloggingtips.com

A simple copy and paste operation from within the blogger template editor and now my blogger blog now has more SEO friendly page titles.

My posterous blog already has this optimisation but my blogger template is quite old now.

Nice tip

Posted via web from solution revolution

SCOPE_IDENTITY and @@IDENTITY broken on SQL 2005 and SQL 2008??!

Check out this website I found at connect.microsoft.com

It is late admittedly and I am just skim reading at the moment but unless I am very much mistaken SCOPE_IDENTITY and @@IDENTITY which are the inbuilt SQL Server functions for returning the newly inserted unique identifier are broken in SQL Server 2005 and SQL Server 2008.

Not good. Time to re-read this and have a rummage about on google.

Posted via web from solution revolution

Wednesday, January 06, 2010

Schema Compare does not support SQL Server 2008

Today I needed to compare the schema between two SQL Server 2008 databases and modify one database from the schema of the other.

In the past I have used the excellent tools from RedGate but I did not have them installed on my netbook however it gave me a chance to use the schema and data compare tooling in Visual Studio 2008 Team System edition that I do have installed on my netbook.

Going through the connection wizard setup Visual Studio gave me the following error message:

Schema Compare does not support SQL Server 2008

A bit of googling later and I found this patch that sorts this out:

Microsoft® Visual Studio Team System 2008 Database Edition GDR R2

After installing this I was able to get going and successfully update my database as you can see from the screenshot below: