|
|
|
|
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.
Browse by Tags
All Tags » t-sql tuesday (RSS)
-
This is not the big announcement that I’ve promised about 24 Hours of PASS (which starts in six 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...
|
-
Should SQL Server even have functions? (Oh yeah – this is a T-SQL Tuesday post , hosted this month by Brad Schulz ) Functions serve an important part of programming, in almost any language. A function is a piece of code that is designed to return something, Read More...
|
-
I’m now doing two sessions at the SQL Saturday event in Portland . I had been scheduled to do a single session (on indexes) , but got an email yesterday asking if I could do another one as well. So now I’m going to do a session earlier in the day about Read More...
|
-
Another month, another T-SQL Tuesday. Next month’s will start during my pre-con at the PASS Summit, which will be interesting. It’s one thing to type during demos (and my pre-con will be demos from start to finish), but another to write a blog post. I’m Read More...
|
-
First, an apology. I haven’t blogged for the last couple of months, except for T-SQL Tuesday events . I make myself blog for these, for two reasons. One is the simple fact that I like the concept – I like the idea of getting a blogging assignment, and Read More...
|
-
It’s not quite a Best Practice , but it’s something that I see as very important. It makes the difference between someone who might be quite good at T-SQL, and someone who can go past the rest and become one of those people who get asked to solve other Read More...
|
-
This post is in two parts – technical and personal. And I should point out that it’s prompted in part by this month’s T-SQL Tuesday , hosted by Allen Kinsel . First, the technical: I’ve had a few conversations with people recently about migration – moving Read More...
|
-
This T-SQL Tuesday is on the topic of CTEs, and is hosted by Bob Pusateri ( @SQLBob ). For a bunch more posts on the topic, follow the link to his Invitation Post , and you’ll see a pile of them, all about CTEs. If you’re reading this and it’s still May Read More...
|
-
I could go on all day about APPLY – it really is an incredible part of T-SQL. It helps solves problems were frustratingly painful to solve otherwise. It empowers the query writer in a way that is matched by few other features. This makes it a worthy topic Read More...
|
-
SQL Books Online is wrong (or at least, on that page). I say that because it lists the FROM clause without brackets, suggesting that it’s not optional. This post is going to look at a few situations where we leave out the FROM clause, showing that it’s Read More...
|
-
I wrote a post recently about how query tuning isn’t just about how quickly the query runs – that if you have something (such as SSIS) that is consuming your data (and probably introducing a bottleneck), then it might be more important to have a query Read More...
|
-
The UK has been well represented this summer at the Adelaide SQL Server User Group, with presentations from Chris Testa-O’Neill (isn’t that the right link? Maybe try this one ) and Martin Cairney. The slides are available here and here . I thought I’d Read More...
|
-
This month’s T-SQL Tuesday is hosted by Jen McCown, and she’s picked the topic of Resolutions . It’s a new year, and she’s thinking about what people have resolved to do this year. Unfortunately, I’ve never really done resolutions like that. I see too Read More...
|
|
|
|
|
|