17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor
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

Tricks in T-SQL and SSAS 07 Apr 2014
This past weekend saw the first SQL Saturday in Melbourne. Numbers were good – there were about 300 people registered, and the attendance rate seemed high (though I didn’t find out the actual numbers). Looking around during the keynote, I didn’t see many empty seats in the room, and I knew there ...

Scans are better than Seeks. Really. 11 Mar 2014
There are quite a few reasons why an Index Scan is better than an Index Seek in the world of SQL Server. And yet we see lots of advice saying that Scans are bad and Seeks are good. Let’s explore why. Michael Swart (@MJSwart) is hosting T-SQL Tuesday this month, and wants people to argue against a ...

Victims of success 10 Feb 2014
I feel like every database project has major decisions now, which are remarkably fundamental to the direction that’s going to be taken. And it’s almost as if new options appear with ever-increasing frequently. Consider a typical database project, involving a transactional system to support an ...

Converting Points to a Path 22 Jan 2014
Suppose your SQL table has a bunch of spatial points (geographies if you like) with an order in which they need to appear (such as time) and you want to convert them into a LineString, or path. One option is to convert the points into text, and do a bunch of string manipulation. I’m not so ...

Write-BlogPost 13 Jan 2014
A couple of years I ago I was going to write a song about automation, in reggae style, which could maybe have been used by the Trinidad SQL community – particularly Nigel Sammy (@nigelsammy). The theme was going to be around the fact that you need automation because the sun shines and the beach is ...