|
|
|
|
Rob Farley - Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft MVP (SQL Server) and leader of the SQL User Group in Adelaide, Australia. Rob is also a Director of PASS, and runs training courses around the world in SQL Server and BI topics.
Browse by Tags
-
Some people question the ethics of writing about my company on my blog. But I don’t have a problem with it. Is it ethical to ignore the concerns of others and to just do what I want? Anyway – it’s relevant for this month’s T-SQL Tuesday, which Chris Shaw Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
In May, I’ll be in the US. I have board meetings for PASS at the SQLRally event in Dallas, and then I’m going to be spending a bit of time in Chicago. The big news is that while I’m in Chicago (May 14-16), I’m going to teach my “Advanced T-SQL Querying Read More...
|
-
A few days after the end of 24HOP, I find myself reflecting on it. I’m still waiting on most of the information. I want to be able to discover things like where the countries represented on each of the sessions, and things like that. So far, I have the Read More...
|
-
Session 11 is on as I write this – Ami Levin presenting about Primary Keys. It’s a good session. But actually, they’ve all been excellent so far, not just Ami’s. I’ve heard only good things about the content. So if you’re reading this and 24HOP is still Read More...
|
-
There’s a bunch of stuff going on at the moment in the SQL world, so if you’ve missed this particular piece of news, let me tell you a bit about it. Twice a year, the SQL community puts on its biggest virtual event – 24 Hours of PASS. And the next one Read More...
|
-
It’s a phrase I use often, especially when teaching, and I wish I had realised the concept years earlier. (And of course, fits with this month’s T-SQL Tuesday topic, hosted by Argenis Fernandez ) When I’m sick enough to go to the doctor, I see a GP. I Read More...
|
-
Hooray – we’re ready to announce the details of the 24 Hours of PASS event that’s coming to an internet connection near you on March 21st! Read on for the day’s schedule, some of my thoughts on the 24 Hours of PASS concept, information about the platform, Read More...
|
-
This is not the big announcement that I’ve promised about 24 Hours of PASS (which starts in five weeks from now!) – that’s coming later this week (and for those of you who haven’t picked up on it – 24HOP is the portfolio I’ve been given since becoming Read More...
|
-
In my last post, I showed a technique for dealing with working columns when writing T-SQL. The idea was around using APPLY to be able to push values from the existing set through calculations (but preferably not scalar functions, of course), producing Read More...
|
-
T-SQL Tuesday again and this month is on T-SQL Tips (thanks Allen !). In some ways it’s a tough topic, because there are things I don’t really consider tips that other people do, and vice-versa. This one’s legitimate though: Using CROSS APPLY for working Read More...
|
-
Little Bobby Tables’ mother says you should always sanitise your data input . Except that I think she’s wrong. The SQL Injection aspect is for another post, where I’ll show you why I think SQL Injection is the same kind of attack as many other attacks, Read More...
|
|
|
|
|
|