rob_farley.jpg

Rob Farley

Rob Farley runs LobsterPot Solutions, a Gold Partner SQL & BI consultancy in Adelaide, Australia. He presents regularly at PASS chapters and conferences such as TechEd Australia and SQLBits (UK), heads up the Adelaide SQL Server User Group, sits on the South Australian committee of the Australian Computer Society and has held Microsoft certifications since 1998 (including MCDBA, MCSD, MCPD and MCITP). He is an MCT and has been a SQL Server MVP since 2006. He has helped create several of the MCP exams, and wrote two chapters for the SQL Server MVP Deep Dives, and created the PASS chapter map that can be found on the PASS website.
http://sqlblog.com/blogs/rob_farley http://feeds.feedburner.com/robfarley

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.
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.
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.
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...

Blog posts RSS

DBAs and the Internet of Things 08 Jun 2015
Ever since data moved to the cloud, database administrators have wondered what it will mean for their jobs. It doesn’t matter whether you are thinking about Infrastructure as a Service, Platform as a Service, Database as a Service, there is some aspect of what a database administrator does that ...

Monitoring skew in PDW 11 May 2015
When you have data stored across several servers, skew becomes very significant. In SQL Server Parallel Data Warehouse (PDW), part of the Analytics Platform System (APS), data is stored in one of two ways – distributed or replicated. Replicated data is copied in full across every compute node ...

Tuning slow spatial queries in SQL Server 28 Apr 2015
Even with the right indexes in place, spatial queries in SQL Server are often too slow – but they needn’t be. Two of the most commonly found patterns of query in the spatial world are when you’re looking for the nearest thing to where you are (which I’ve written about before), and when you’re ...

SHOWPLAN permission denied even if the database isn’t actually used 14 Apr 2015
To view a query plan, you need SHOWPLAN permission on the database level at least. You have this if you have CONTROL DATABASE, or CONTROL SERVER, or if you have ALTER TRACE at the instance level. I know this last one because it’s mentioned in Books Online on the ‘Database Permissions’ page, not ...

T-SQL v MDX: Pick the hierarchy and populate the report parameter values 02 Apr 2015
When dealing with report parameters, you want the experience to be as seamless as possible for the end user. In SQL Server Reporting Services, we have the tremendously useful feature of having dynamic parameters, in which you can set a particular report parameter based on the choice of a previous ...