Comments (0)

By nick, October 4, 2009 12:38 am

It has been an interesting year, and those of you who know me should certainly agree. This last year has been my Industrial placement year as part of my Degree – All fun and games you might think. Mostly, you’d be right – aside from the daily struggle of commuting to Leeds every day.

It’s been a busy year in YSTV too. This time a year ago I had just rolled out a bunch of new servers, setup a new flash streaming solution and generally made life more difficult for myself (but better for everyone else, i hope!). A year later, and I’m at it again. This time I’ve rolled out some new high spec Edit PCs, complete with Windows 7. On top of that, myself and several others completely rewired and re-organised the Control Room.

However, what this post is all about is how my outlook on a certain few big corporations has changed – Microsoft and Apple.

Continue reading 'From Hate to Love in a little over a year…'»

Comments (0)

By nick, January 12, 2009 3:06 pm

If like me you learnt SQL using MySQL, and then gone into a job and found yourself using Microsoft’s SQL Server, you’ll probably be as irritated as me to find that Transact-SQL does not feature the ‘AUTO INCREMENT’ keyword that MySQL provides. Fortunately, the solution is far easier here than it is in PostgreSQL.

All you need is to add IDENTITY(1,1) in your column definition. I’m not going to pretend to understand exactly what this does, only that it will Automatically increment and ID field for you. If anyone wants to enlighten me on exactly what it does, then feel free :)

An Example is below:

   1: CREATE TABLE dbo.myTable(

   2:     ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,

   3:     ColumnA VARCHAR(200),

   4:     ColumnB BIT

   5: )

   6:  

Comments (0)

By nick, January 11, 2009 8:23 pm

After a few delays by Microsoft, I finally got a hold of Windows 7 Beta this morning. I must say…I’m pleasantly surprised. It certainly does seem much much better than Vista was – even at the Beta stage!

Continue reading 'Windows 7 – A Pleasant Surprise'»