Bulk insert of rows with sql server

sql server
I'm not sure how many total weeks of my life I've spent on data import. Many. Maybe Hundreds. Also, every new project needs test data and usually we'll write INSERT INTO blah blah full scripts again and again. Here's a way to slightly reduce the amount of text that needs to be written/sent to the server AND make your scripts cleaner. Available Sql Server 2008 and up.

Do yourself a favour go and race other series often

iRacing    simracing
Race a different series and give yourself a break. You'll also increase your skillset.

Accessing F1Speed via mobile devices

asp.net    f1speed    projects
How I got F1Speed to present an interface on mobile devices, using Nancy.

Zolder didn't go to plan

iRacing    simracing    star mazda
Week four was Zolder. It didn't go to plan. A busy week in the real world and an operating system upgrade to windows 8 meant I missed valuable track time and didn't get to race or qualify

jquery.validate and chrome doesn't validate australian dates

asp.net mvc    jquery
Whats that? Chrome doesn't nicely convert date strings? new Date("19/11/2011") fails?!

So you say you keep getting crashed out?

iRacing    racecraft    simracing
"Arghh I've had a rubbish week. I keep getting taken out on track" This is a comment complaint every iRacer hears every now and then. Someone, it may even be you, is having a bad week or two or more. It seems every race they're in they are involved in some "idiot"'s crash. You know what I say? What's the common denominator? That driver! To be honest I started my iRacing career like this. I was getting into more incidents that I wasn't, when racing MX-5's It seemed almost every race I was getting hit by, or hitting someone, and it wasn't often the same person. Personally, I think it's because I came to the sport with an expectation I'd be as good against real people as I was against AI. Thing is, AI don't have emotions, but people do. And people don't want to lose, they don't want to get overtaken, and they'll shut the door. They also crash. They push hard, maybe too hard, and then they come off. I remember I would brake as late as possible as often as possible. I'd run on the ragged edge and I'd attempt a pass at the faintest wiff of an opportunity. I took this behaviour with me into the Skip Barber series too. Understaing respect, and learning racecraft early on will help you...

Cycling out of bellbowrie

bellbowrie    theorising
Bellbowrie cyclists need a better way to get out of town

Hurry up and build a bridge between bellbowrie and riverhills

bellbowrie    theorising
Bellbowie is busy. We need a bridge not a bypass!

why am I only just finding out theres a racetrack near my house?

Random race-track found on google maps only a few kilometers from my house!

Underwhelming at Laguna Seca

iRacing    simracing    star mazda
Laguna Seca: I did alright here last season. Had a race win and some other good results. What will a lack of practice bring? Mixed results, that's what - and a near win.

indicating required fields with twitter bootstrap and asp.net mvc 4

asp.net mvc    twitter bootstrap
Need to add a required field indicator to your twitter bootstrap enabled asp.net mvc4 app? Well look no further, I've HACKED together something right here...

Ragged gets busy at Leguna Seca

iRacing    simracing    star mazda
Week 2 of the Star Mazda is Leguna Seca, home of the infamous "cork-screw". Last season both Andy and I hit the track for a race and came together on the first corner. We ultimately finished 2nd and 3rd in that first race. I had a few more troubles, coming together with Steve Owen, getting reversed into off the grid by Paul Ezerski...

V8Supercars rock Road America in 2012

iRacing    simracing    v8supercars
Round one of season four hit Road America this week. For me, it was to be my first every V8supercar event, after finishing 2nd in division four of the other main C class series, the Star Mazda. Fuel saving made it introduced a new dimension to the race, and I liked it.

The Ford V8supercar is not easy

iRacing    simracing    v8supercars
The Star Mazda is a pretty easy car to drive. The light weight, the massive grip both mechanical and aero, the open wheel nature, all lend itself to a pretty easy car to drive from the get-go. The Ford V8SC is anything but easy. It's a twitching, bucking, yelling, screaming beast. The Star Mazda is a refined, well mannered, upper-middle class car. The V8SC is a beer swilling, loud, obnoxious beast. But that's what makes it interesting...

Mammoth Networks sponsor for Season 4 2012

iRacing    simracing    star mazda    v8supercars
Mammoth Networks now sponsor my racing efforts. How so? They donated a VPS to run this blog. That and I work at Mammoth Media / Ausgamers. I like the colours too. Now if only they kick in some shiny 27" monitors...

Smashing it at Road America season 3 2012

iRacing    simracing
I had the best race of the season at Road America. Battling with the big boys and making a huge iRating and SR gain. Love this track. I started off the week pretty calmly and using my standard race preparation: Run the track with my default setup (32 Front and 31 Rear wings), incidentally the same wing settings I've used all season so far. The tuesday session is meant to be an acclimitisation session to familiarise myself with the track...