“Fabulous”

I don’t tend to find that anything about me gets described as “Fabulous”. It’s not a word I ever use myself, so I was slightly amused to see it here. It’s going to be an interesting week (in May, Monday 14th to Saturday 19th), in which I have two stints in classrooms (the three day … Continue reading “Fabulous”

Adelaide’s SQL Tuesday

This coming Tuesday sees a midweek SQL Saturday hit Adelaide. LobsterPot’s a sponsor, as are a bunch of other companies. An all day event, with two tracks featuring some of the best material you’ve ever seen presented. I’m presenting too. The thing I really want to draw your attention to is that we have two … Continue reading Adelaide’s SQL Tuesday

Analytic functions – they’re not aggregates

SQL 2012 brings us a bunch of new analytic functions, together with enhancements to the OVER clause. People who have known me over the years will remember that I’m a big fan of the OVER clause and the types of things that it brings us when applied to aggregate functions, as well as the ranking … Continue reading Analytic functions – they’re not aggregates

How views are changing in future versions of SQL

April is here, and this weekend, SQL v11.0 (previous known as Denali, now known as SQL Server 2012) reaches general availability. And so I thought I’d share some news about what’s coming next. I didn’t hear this at the MVP Summit earlier this year (where there was lots of NDA information given, but I didn’t … Continue reading How views are changing in future versions of SQL