4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

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

Will 2015 be a big year for the SQL community? 08 Dec 2014
In Australia, almost certainly yes. Australia recently saw two Azure data centres open, meaning that customers can now consider hosting data in Azure without worrying about it going overseas. Whether you’re considering SQL Database or having an Azure VM with SQL on it, the story has vastly ...

Minimising Data Movement in PDW Using Query Optimisation Techniques 04 Dec 2014
This is a white paper that I put together recently about APS / PDW Query Optimisation. You may have seen it at http://blogs.technet.com/b/dataplatforminsider/archive/2014/11/14/aps-best-practice-how-to-optimize-query-performance-by-minimizing-data-movement.aspx as well, but in case you haven’t, ...

Learning through others 11 Nov 2014
This PASS Summit was a different experience for me – I wasn’t speaking. I’ve presented at three of the five PASS Summits I’ve been to, where the previous one I’d not spoken at was 2012, while I was a PASS Director (and had been told I shouldn’t submit talks – advice that I’d ignored in 2013). I ...

PASS Summit WIT Lunch 06 Nov 2014
With the pleasant sound of cutlery on crockery, those lucky enough to secure tickets to the WIT Lunch at the PASS Summit get to listen to an interview with Kimberly Bryant, who is the founder of a non-profit organisation called Black Girls Code – helping teenaged girls from low-privilege ...

Dr Rimma Nehme at the PASS Summit 06 Nov 2014
This Summit’s presentation from Microsoft Research Labs is from Dr Rimma Nehme, bucking the trend of having presentations from Dr David DeWitt. I’m really pleased to be able to hear from her, because she’s an absolute legend. Among her qualifications is work on the PDW Query Optimizer – a topic ...