Cody Konior Senior SQL Server Database Administrator Spider photographer, stand-up comedian, astronomer, and occasional beekeeper.

Duh moments: Previous(), and Cross Apply

I came across two little learning experiences this week. Here's hoping someone else is stupid enough to make the same mistakes as me and look it up!

Common Dates For Reporting Services And T-SQL (Part 2)

Sometimes I need to get weeks ending on a certain day, like the week ending as if on Tuesday, or Saturday. It's pretty easy in SSRS expressions, but it's not so easy in T-SQL (if you want to account for @@Datefirst which jumbles the week starting date up). But I did finally work it out and have prepared samples below!

Carried Forward Page Totals

Reports that show financial data often require a carried forward amount, or per-page cumulative total, or running total, to show in the header or footer of the report. Reporting Services doesn't have a good (well described) way of handling this, until now. I'm going to lead you through a demonstration on how to make it really work, and some of the pitfalls (and the workarounds) I found along the way.

Porting VB6 Applications To VB.NET


I took the lead in porting a small (few thousand lines of code) VB6 application to VB.NET and here are some notes I made during the process, in case they're useful for anyone else.

No show Tuesday night

I'm tired. I stay up late every night doing nothing, and my weekends go so fast seemingly doing stuff for everyone else, so much so that they are more stressful than relaxing. I'm feeling down because a couple of people rated my videos down on which I don't understand at all because the audience reacted well and to be honest the standard of videos on isn't that high anyway. And I'm super overweight, I haven't been able to get myself to get back into my exercise regime due in part to that ridiculous lack of sleep from above.

Tweaks make for a good show!

In the very beginning, the MC forgot my name, and it was really embarrassing (for him, but it's no big deal really), and so when I went on stage I moped on and started saying, "Don't feel bad for me, when I was younger:" and then the video begins.

Another last minute show last night!

Last night I had a special call to fill in at Comedy Lounge just a few hours before the show was set to start.

That's wrong

I did another deadpan set tonight, though occasionally found myself slipping into my normal voice a few times, which ruined the effect a little. A lot of my bits didn't necessarily have punchlines but I was thinking they would pull through based on the weirdness/self-deprecation factor.

I won a YouTube award!

I'm the 75th most viewed Australian Comedian of the day on YouTube! Kind of sad if you think about it, but I've never done that before, so thanks everyone!

How to catch a pedophile

This is my new, must-see show!

Preparing for tonight's show

I had put together a set list for tonight but it just didn't flow like my previous acts and because so much material was related to porn, I felt like it didn't represent me properly as a comedian or a person. So I scrapped it.

Preparing for Tuesday 6th

I was speaking to a friend I hadn't seen in ages, and was excited to tell him that I was still continuuing as a stand-up comedian and that I'd done over a dozen shows now and that it was going good, even though I often bombed.

My girlfriend is a Transformer, redux!

If you've seen my stuff before, skip to the middle

My girlfriend is a Transformer

I hadn't done a comedy show in two months, and for the past month I'd been waiting for my turn to come up at Lazy Susan's. I spent about a week preparing but despite having written lots of little bits in that time, I couldn't find any funny way to string them all together.

RAW Comedy wildcard night

I was in the wildcard round of the RAW Comedy competition tonight. I put a set together which was a mix of what worked last Saturday and last night, plus one or two funny bits from the past and one or two completely new small things that I'd always wanted to do.

Exotic porn for angry people

I prepared a set almost exactly the same as the last half of my Northbridge street set from Saturday which got a good reception, so I knew it was good, and yet when I ran it last night it went okay but not great.

Street comedy in the Northbridge Piazza

I performed a free event last night on the edge of the Northbridge Piazza. It was 5 minutes of my Raw Comedy set, followed by 5 minutes of brand new material. It all went really well, but unfortunately I forgot to tape it.

RAW Comedy chose me!

After Set #9 I got picked to compete in the Wildcard Round of the RAW Comedy Competition!

RAW Comedy entry

Last night I participated in Heat 5 of the RAW Comedy Festival competition. There were 14 contestants, at least 3 didn't do well but the rest were great, and the MC and headliner were great, too. Everyone was friendly backstage. I also spoke before and after the show with someone from ABC Radio.

Models can't spell models

This sucked.