4th - 7th May 2016



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

Join Effects With UPDATE 12 Jan 2016
A lot of people don’t like UPDATE with a FROM clause. I’m going to explore what’s going on, both logically and within the query plan. And I’m doing this for T-SQL Tuesday #74, hosted by Robert Davis (@sqlsoldier). I’m going to use a fresh copy of AdventureWorks2012. I’m using SQL 2012 SP3, but ...

A new superpower for SQL query tuners – Number of Rows Read 12 Dec 2015
There’s a technique that I’ve been using for some time now, and been looking for going even further back, which has become immediately available to everyone who can see a query plan (version permitting). Some years back (ok, it was 2010), I started to present at conferences about SARGability and ...

Does the paradigm fit the environment? 08 Dec 2015
This month we see the 73rd T-SQL Tuesday come around – six years were completed last month (the first was in December 2009), and this is the start of year seven. It’s hosted this month by Bradley Ball (@sqlballs), and he asks a question about whether our environments are naughty or nice. Now, I’m ...

Anti-Harassment Policies and Codes of Conduct 26 Nov 2015
I was a director on the PASS board back in 2012 when our having a Code of Conduct was first raised. A number of conferences had experienced bad situations, particularly around sexist behaviour, and it was very appropriate for PASS to take a stand and say “We don’t want this kind of thing to happen ...

What’s driving your data model? 10 Nov 2015
If data modelling were easier, I doubt there would be as many books on the subject, and we wouldn’t have multiple methodologies to consider. I’m not going to explore the different methodologies here – that’s almost a religious argument these days, and I am more than happy to let you adopt ...