Posted on Leave a comment

“I’m not hungry when I listen to techno”
– Flash on the Beach 2007

I love flash conferences, the ones I’ve been to have always had such an excellent selection of speakers and the general atmosphere is so lively and friendly (ok, so maybe not so lively first thing after a disco-styley party, but still).

The speakers I had the pleasure of seeing were:
Erik Natzke
Joshua Davis
Robert Hodgin
Brendan Dawes
Craig Swann
Carlos Ulloa
Hoss Gifford
Aral Balkan
Branden Hall
Grant Skinner
Keith Peters
Tink
Jared Tarbell
Ted Patrick
André Michelle

…and a little bit of Mario Klingemann at the 20 minute / 3 speaker session that they arranged last minute.

If you want to see what each speaker had to say, visit Dan’s blog cause I just snuck a peek over his shoulder to see him writing nice little details about each session we saw, so I’ll won’t go much into that and actually get some sleep while he does all the extra bits! Woohoo!!

But from creating insanely beautiful globes of light moving to audio created straight from numbers and code you couldn’t have been disappointed or uninspired.

My favourite quote from all of the FOTB’s sessions would have to be André’s answer to overrunning into lunch time and when being asked to wrap it up replied with “I’m not hungy when I listen to techno”. Queue well deserved applause. 😀

Already looking forward to the next flash conference, and hopefully inbetween now and then I’ve actually sat myself down and put some of what I’ve learned into practice.

Posted on Leave a comment

Import CSV to SQL Server Database

Quick steps to importing a csv to a sql server database. There are a couple first steps incase you have an existing database that you should make a backup copy of first or you can skip right to step number 3 which highlights the import itself.

1. Creating a backup of existing table

The code to take a table and back it up in case you do something wrong!

SELECT *
INTO tbl_mytable20070110
FROM tbl_mytable

TRUNCATE TABLE tbl_mytable;

That will take all of your existing table data and put it in a safe backup file. The truncate function then erases all of your tbl_mytable data, ready for the new data to be entered.

2. Conforming the CSV to date compliancy

Ensure the dates of your csv are in yyyy-mm-dd format to avoid any global date format issues.

3. Import the CSV data to the SQL database

  • Open SQL server and right click on the database table section.
  • Choose All Tasks > Import Data > Next
  • Choose Text from the drop down as the import file type and then browse to the location of your CSV file.
  • Click for larger example of choosing text

  • Ensure delimited option is chose and that ‘first row has column names is ticked. Hit next
  • Click for larger example of choosing file format

  • Choose Comma delimited and hit next.
  • For the destination source, make sure Microsoft OLE DB Provider for SQL Server is chosen. I used the SQL server authentication. Choose the Database you wish to import the data too and hit next.
  • Click for larger example of choosing destination

  • In the source tables and views window, select destination and choose the tbl_mytable that you will be importing the data to.
  • Click transform (the … button)
  • Ensure that all of the Source items correctly match the Destination. Change as necessary.
  • Click for larger example of column mapping

  • Un-tick Enable identity insert and hit OK.
  • Choose run immediately if not already chosen and hit next and then finish.

Now this is the way that some CSV imports will work, you may have to adjust if you do not use column names in your excel/CSV document for example.

Posted on Leave a comment

Growing from seeds : Part two…

Seeds in warm water overnight to encourage germination If you’ve read part one of “Growing from seeds” I’m sure you’ve been left cliff-hanging wondering what has happened to the seeds since their overnight warm water bath! Ok, so maybe not quite cliff-hanging but here’s the end to the seed planting opening scene nonetheless.

The sweetpeas and the lupins experienced a nice warm water bath over night to encourage germination, so in the morning I positioned myself in the usual ‘rainy-day, dry porch’ spot and started putting the seeds into the propagator. Sweet pea seeds in the propagator before covering with a layer of compost I’ve been using general purpose compost, which indications on the bag it is ideal for baskets, cuttings and seeds. I’ve recorded which colour sweetpea seeds were put which cells as I’m curious to see if it impacts which colour they ultimately grow as. I had yellow, brown and black seeds. Hopefully we’ll see soon!

Both of the propagators are now taking up the spare room’s windowsill and they all have different germination expectancy dates, with the soonest being 10 days (sweet peas) so hopefully in 10 days times I’ll be seeing some green work its way out from the compost.

I found a good reference guide here as well: (For sweetpeas)

Posted on 1 Comment

Growing from seeds

Ok, this is my first attempt at growing from seeds. I’ve read up on germination and stratification and all sorts of general tips on growing from seeds… so I should be fine right? Dragged Dan out again earlier today to buy the seeds (it’s a rainy day and I was garden-eager but couldn’t do anything outside today, damn rain), so we went in search of Haskin’s near Ferndown. It’s a nice garden centre, quite big (not as big as Cadbury’s near Bristol) and has a good variety of plants, bulbs, seeds and garden tools. After being very tempted to just spend the extra money and buy the already grown plants we wandered over to the seed section. Firstly, are seed sections always terribly un-organised? Why don’t they just put them in sections, Annuals in one, Perrenials in another and then maybe alphabetically? Oh well…

So we rumaged through the different seeds, seeing which ones we could plant now and give me sprouts before I got bored and dumped them in the bin. We came home with four different seed packets and the ‘Mega value budget propagation 3-pack’, oh yes, no expense spared here! The seed packages consist of Canterbury Bells - Part of the Campanula mix of seedsCampanula (a mix of blue and white rockery plants), Achillea ‘Summer Berries’ hybrid, perennial sweet pea and some lupin ‘gallery mix’ seeds. I found myself a nice dry bit of ground under the porch to sit on and set about putting the compost in the propagator and then planting the Campanula and the Achillea seeds, the other two flower seeds have to be soaked in warm water overnight before being sowed apparently. I’m now thinking, yet again, that someone should really create some sort of microwavable plant. Put your seeds in and 30 seconds later, whala, big thick plant with gorgeous flowers… would be nice for someone as impatient as me…

Seeds from Campanula Rockery Mix and Achillea Summer Berries Hybrid at Day 1

Here are the seeds as they are now. Sitting happily in the windowsill, in a propagator (I took the plastic lid off for the picture) to keep the moisture in. I expect I’ll be happier with the Campanula mix as it takes 14-28 days to germinate while the Achillea can take 1-3 months. I’ll be checking them everyday to make sure the compost is moist but not wet, using a spray bottle to keep from drowning them and in turn causing them to mold.

Posted on Leave a comment

The Space Available

We’ve just bought our first house earlier this year and it has a small fenced off space out the back. It’s about 15ft by 15ft with a diagonal fence slicing the farthest left corner off… so there’s not a ton of space to work with, but it’s a very sweet little space all the same.

Our garden space

The ground is shingled (nightmare for heels AND plants alike) but container plants have been working quite well this far as the sun covers at least half of the garden for most of the day. We’ve so far stuck a small four chaired table in the middle of it and some half-moon baskets along the fence.

Our garden space

My very patient man (thanks Dan x) has been repeatedly dragged off to garden centres, B&Q and generally anywhere where I’ve seen plants sitting outside with price tags on. At the beginning we bought a bunch of annuals for the baskets, tempting me in with their bright colours and low maintenance demands. I’m not so much of a fan of them anymore.

The basket of shame

They started off well but I wasn’t particularly educated on how big each would grow, to excited at the prospect of having nice new flowers and colour in the garden, and so I didn’t bother to find out if they’d grow straight up or wander off to the side like vines… two of the three baskets are alright as I just planted the plain marigold plants in them, but the third is doing a thing all of its own. The geraniums in it have been and gone (too bad, I liked those ones..), leaving a brown stick standing proudly in the air, the flowers on the right have decided they’d like to turn into a bush in mid-air, protruding far beyond any of the other flowers and the red flowers which I’ve completely forgotten the name of at the moment seemed to bloom for a day and then rot into brown droopy messes.

On the up side I’ve been growing a few trees, and I’m quite proud of them so far. One is my tiny but ever growing ‘Christmas Tree’ who was originally received through the post as a gift from a printing company that my boyfriend’s company uses. For some reason though he seems to have stopped growing upwards and would much more prefer to continue getting wider… I keep meaning to research that and see why that is. The other tree is my Bay tree. Unfortunately when I was getting the original cutting from my boyfriends mom I heard her incorrectly and thought she had said ‘Bailey Tree’ …. that would have been nice, sadly there is no such thing as a Bailey’s tree so I will have to continue to buy the heavenly drink from the off-licence. It’s been growing nicely though, the Bay tree, I even started marking its progress on its support stick every Sunday, it’s been doing about an inch to an inch and a half each week.

The other plant I have is a recent addition (also from Dan’s mom) is a tomato plant. It had three flowers on it when I first put it in the garden… two of which I sadly found had fell off because of the torrential rain England had a month ago, the third flower, to my further dismay, fell off when I touched it. Further on in the week I had just finished a load of laundry and Dan was taking it outside to set it up in the sun when the clothes horse snapped under the weight off the wet clothes, falling directly onto the tomato plant. The tomato plant now has one stem and no branches, although it’s been a couple of weeks now and new flowers have started to bloom… we may get tomatoes yet!