Dangers of BEGIN and END

I’ve presented this material at three conferences recently, so it’s about time I wrote a blog post on it… As programmers, we love modularisation – even in the SQL space. We make stored procedures, views, and functions to encapsulate our code. This improves maintainability, simplifies the development experience, and is generally useful. But there’s a time when it’s a bad thing for SQL Server. There’s an amazing component of SQL Server called the Query Optimizer (I always want to write Optimiser, but I’m assuming it’s a proper noun and putting up with the US spelling). When we write queries in … Continue reading Dangers of BEGIN and END

More SQL Conferences coming up, including SQL Bits and SQL Down Under

I know I won’t be there, as I’m a million miles away in Australia, but being from the UK myself, I always have an interest in the UK SQL community and in particular, events like SQL Bits. This is the fifth SQL Bits conference, and they keep getting larger and larger. I’ve heard it’s now the largest SQL-focussed event in Europe. It’s going to be in South Wales (that’s OLD South Wales, not New South Wales), in November. I’m sure the area is lovely, good beaches ‘n all that… but considering it’s late November in Wales, I think you’ll be … Continue reading More SQL Conferences coming up, including SQL Bits and SQL Down Under

SQL Down Under talks, and England wins

This weekend is getting better and better. With England winning in both the football and the rugby, my mood is pretty good anyway – despite having to give the first presentation of Sunday morning at the SQL Down Under Code Camp. The local TV channel sent cameras just after I finished, so I think I managed to avoid having my presentation on the local news. At least, I hope they came just after I finished… otherwise I didn’t notice them lurking in the corner. I taught the crowd about MERGE & Table-Valued Parameters, and got good feedback from various members … Continue reading SQL Down Under talks, and England wins

SQL Down Under Code Camp begins

Two days of intensive SQL Server training, thanks to experts from around Australia and Kevin Kline from the US. All the Australian SQL Server MVPs are coming (five here so far, two more coming soon). The coffee is great (thanks Peter), the company is great, and there are so many more people here (than last year) because there is also a Security Camp on at the same time. All the user-group leads are here, including Perth and the new Hobart group (Jason Cook‘s getting this going), which means every Australian state is represented. I’m sure other people will be blogging … Continue reading SQL Down Under Code Camp begins

Free SQL training at events in the UK and Australia

…and I’m not even referring to the User Groups which run regularly. The ones I’m referring to are SQLBits and the SQL Down Under Code Camp. SQLBits was in the UK last weekend, and was a massive success. I would’ve loved to have been able to attend, but it’s a bit far to travel (I guess about 12000 miles). They had over three hundred attend, which is fantastic! Adelaide User Group regular Martin Cairney was there, and presented the talk he gave in Adelaide earlier this year. It seems to have been received well. And this coming weekend is the … Continue reading Free SQL training at events in the UK and Australia

Code Camps galore

We all know that Adelaide hosted Code Camp SA recently – it was a great success, and some people even wished I was there! TechEd is coming up of course, but now there are two code camps scheduled for October, on the same weekend (13-14) and at the same venue! Yes, that place is Wagga Wagga – one Wagga for each event. Firstly, and most importantly I’m sure, is the second SQL Down Under Code Camp. But the other one is the Security Camp Oz. With me doing the SQL Security talk at TechEd this year, I’m sure I’ll have a … Continue reading Code Camps galore

On learning (Calvin and Hobbes, the ACS and digital natives)

Digital natives learn differently. How do we take advantage of that? The funny thing is that right away, I’ve written this from an external perspective, when I’m probably in a mixture of both camps. Feel free to consider me in either camp as you read this. At TechEd Australia this year, the keynote was from Anne Kirah. She talked about the concept of the digital native. That’s someone who has grown up in a technology culture, and therefore thinks differently to someone who has grown up in a non-technology culture and come into it. I was born in late 1974, … Continue reading On learning (Calvin and Hobbes, the ACS and digital natives)

Slides and scripts on the OVER clause presentation

I'll write more about this when I get the chance. But in the meantime, if you want the slides and scripts from my presentations in Wagga and at AdSSUG last week, then get them from http://msmvps.com/files/folders/robfarley/entry180018.aspx . It was on Ranking Functions and Windowing, or on the uses of the OVER clause, etc.

SQL Code Camp Talks

All the talks this weekend have been great. Almost every talk has a bunch of things that I really hadn't appreciated before. All 5 SQL MVPs from Australia are here, plus Itzik (from Israel) and a few non-SQL MVPs from Australia. I would've liked there to have been a few more people here from my user-group in Adelaide, but I do appreciate it's a long way to come. There are two, plus me.

SQL Code Camp

Well, here I am at Wagga Wagga. It's Sunday morning, and Itzik Ben-Gan is speaking. He's just shown us slides of the SQLHike trip, which looks like a really cool idea. Being here in the middle of nowhere talking about SQL with people is really fun. My talk (on the OVER() clause) went okay yesterday. I was last up and had to keep it short, but I got good feedback from people. People liked it when I jokingly told Itzik to just put his hand up if he had any questions. I must check out Itzik's talk on row_number() some … Continue reading SQL Code Camp