Rob Farley
Rob is a data consultant in Australia. His company is LobsterPot Solutions. He's an MCM for life, MVP for now, and MCT for as long as he keeps meeting the required conditions.
Rob Farley's Sessions
The stuff about Joins they didnt teach you in schoolSQLBits 2018
Logical v Physical, Semi Joins, Lookup Joins, Redundant Joins - there is so much more to joins than you may have considered, and yet they are so fundamental to almost every query you ever write.
Where the bl**dy h*** are you? (Spatial Data Visualisation)SQLBits 2010
A look at spatial data visualisation, including the maps in SSRS 2008 R2, handling shapefiles for those of us who have to deal with maps outside the USA, geocoding addresses with Bing, using the Silverlight Bing Maps control, and even PivotViewer.
Understanding SARGability (to make your queries run faster)SQLBits 2010
SARGability relates to the ability to search through an index for a value, but many DB Pros don’t really get it – especially in regard to joins – leading to queries which don’t run as well as they should. No slides here, just demos...
Introduction of MS StreamInsightSQLBits 2009
StreamInsight is Microsoft's technology for Stream Data Processing and Complex Event Processing (CEP). In this session you will get an overview of what CEP is, what problems it tries to solve and how StreamInsight tries to do it.
Designing for simplificationSQLBits 2009
Allowing the query optimiser do its job of simplification is an important feature if any database design. In this session, Rob takes us through ways that a database design can leverage features of the query optimiser such as redundant joins and end up with a system the provides a much simpler querying environment.
The stuff about Joins they didnt teach you in schoolSQLBits 2018
Logical v Physical, Semi Joins, Lookup Joins, Redundant Joins - there is so much more to joins than you may have considered, and yet they are so fundamental to almost every query you ever write.
Where the bl**dy h*** are you? (Spatial Data Visualisation)SQLBits 2010
A look at spatial data visualisation, including the maps in SSRS 2008 R2, handling shapefiles for those of us who have to deal with maps outside the USA, geocoding addresses with Bing, using the Silverlight Bing Maps control, and even PivotViewer.
Understanding SARGability (to make your queries run faster)SQLBits 2010
SARGability relates to the ability to search through an index for a value, but many DB Pros don’t really get it – especially in regard to joins – leading to queries which don’t run as well as they should. No slides here, just demos...