17
Mar
10

Rob Farley FROM Down Under

I am one of those people that like to see and do more than just read. If I read something without testing it, playing with it, picking up the book, setting it back down again I just don’t retain it as well. This is just one of the reasons that I think the Pulling apart the FROM clause chapter is well written.

I will back up a bit. Rob Farley is a SQL Server MVP that is base out of Australia. He has a blog that can be found here: http://sqlblog.com/blogs/rob_farley/ for the last month or so, but if you want to go back a bit more you may want to look here: http://msmvps.com/blogs/robfarley/. From looking at the About page on his blog he has done work with more than just SQL Server.

The main idea of this chapter is to take a Deep Dive into the FROM clause, there is a strong attention to detail that Rob has when it comes to discussing the topic. There is information that starts with the FROM all by itself before you start to add any of the many layers to it. To the chapters end where he talks about how joins will impact you. When covering the many different angles such as the Joins or the Cross there are examples to help you see not only the syntax, but the proper usage.

This chapter is a must for anyone who writes SQL Code. There is so much here that I don’t believe many books compare to the depth of his coverage on the topic. The more that I think about it we should all spend some time in the topic, if there is an opportunity to improve our t-SQL skills I think we have to take it.

Advertisements

1 Response to “Rob Farley FROM Down Under”


  1. March 19, 2010 at 4:02 am

    I’m pleased you like it, Chris.

    Your readers might also be curious in a recording of a session I did at SQLBits last November, at http://sqlbits.com/Agenda/event5/Designing_for_simplification/default.aspx, where I demonstrate the “4 uses for a join” concept that I cover in Chapter 7.

    If they like it, they can give me a vote at http://speakerrate.com/talks/2077-designing-for-simplification 😉


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Chapters

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 13 other followers