Working on the web

This month I started exploring Microsoft Azure.

Starting out with Windows 8

So I wanted to start to get to understand Windows 8. So far so good. I needed a blank PC to run the test on as most of my PCs are set up very specifically. So I purchased a Samsung Series 7 tablet PC and installed Windows 8 and I have to say that I am impressed.

As will all major changes there is a learning curve while we try and make it work the way we are expecting it to work. Once you watch the 3 short videos and stop and think it is amazing.

The tablet hand writing recognition is amazing, tie this to Microsoft OneNote and you have an amazing digital notepad that is searchable and easy to organise. I can finally see me actually using OneNote instead of just thinking that its pretty cool but a lot of effort.

The new start screen was great for me because I already use a Windows Phone so I felt at home. I did find it odd launching the full desktop and not having a Start Icon. Once you adjust to it though its a real improvement. For me the penny dropped when I installed MS Office and the shortcuts appear in the Metro screen. I had thought of them as seperate entities but no, it’s all the same and it’s all good.



Resolving slow row inserts in

wow who would have thought, adding rows to a datatable with a strongly typed dataset is about 10 times faster than an untyped dataset. It’s definately worth the effort if you are importing large CSVs.


I was writing a smal lapp that takes the content from 3 CSV files and loads them into datatables. Then I merge them into a fourth with some business logic thrown in along the way.

Inserting rows without a strongly types dataset was taking ages. I am importing about 50,000 rows and I swear it was taking around 20 mins to run. Of that maybe 3-4 minutes is loading the csv into the datatables. Because we are reading CSV the format is a little unpredictable. I changed that and wrote new exporters so that the formats all match then added a dataset and manually defined the datatable. Now when I read the csv into tables I declare them with the type. The inserts are faster like done from 15 minutes to maybe under a minute.


Amazing who would have thought!