Rob Farley
Consultant, Comedian, Community leader
Adelaide, Australia
Actions
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.
Links
Awards
Area of Expertise
Topics
The Problem with MPP
Massively Parallel Processing (MPP) is the technology that lets Dedicated SQL Pool in Azure Synapse Analytics scale so well. But this doesn't come for free. In this short session, Rob describes what's going on, and why understanding the concept can help you avoid some performance pain.
Quadrants that describe your data culture
Business people seem to really love quadrants, and that includes the stakeholders at your customers. Whether it's the Ability to Execute v Completeness of Vision quadrants that we see from Gartner or comparing the importance v urgency of items on our to-do lists, there's something magical about positioning things in a quadrant system. Data is no different here, so this session explores some practical quadrants that can help you address various situations that you and/or your customers might be in, in a format that the stakeholders you need to convince might appreciate.
Indexes with flip-charts
Indexing is critical to the success of your database, and it’s vital that you understand indexes thoroughly. You should know how they work in different situations, what kind of choices can work for or against you, and how to get the most out of them. This session will dive into index internals and demonstrate what’s going on behind the scenes as queries run. Using practical examples to explain the theory, we will take a journey from the basics through to advanced concepts that become simple when viewed correctly.
A ton of reasons to like APPLY
I like OUTER APPLY-ing.
Let me show you why.
CROSS APPLY is also good.
Don’t worry, this session won’t all be in haiku poetry. But trust me when I tell you that APPLY can improve the beauty and performance of your queries, as well giving you better confidence over the correctness of your results.
Breaking the fourth wall - connecting to audiences with your presentations
Creating a presentation isn’t easy and neither is attending a presentation. Reading a thousand slides in dozens of presentations over a few days at a conference can make the most enthusiastic audience member glaze over. Presenters need to find ways to be interesting. To connect with their audiences. To help audiences stay engaged and grasp the key things being taught. This session will help you the presenter understand the different types of audience connection, so that you can help them use different parts of their brains and stay with you. You'll learn to move away from PowerPoint and into powerful points instead.
Why the Query Optimizer might not give you the kind of join you asked for
This will be a guide to seeing what joins actually do and why the join that's mentioned in your execution plan might not match the kind of join you thought you asked for.
Problem Operators
When you're looking at a query plan to see if there's opportunity for improvement, what are the things you look for within the operators you see?
In this session, Rob will explore some of the signs that there's some tuning to be done, and what kinds of things can be done to address them.
Joins with Rob Farley
Joins are a thing you learn on Day 1 of T-SQL 101. But they are so much more involved than what you learned then. Logical v physical, Semi Joins, Lookup Joins, Redundant Joins, not to mention those times when you thought you specified one kind of join and the execution plan says it's doing something else.
Luckily, it's not magic - it's all very straightforward once you understand the different types of joins and how they work. This session will cover the different types of logical and physical joins - and even look at joins that don't exist at all.
Rob Farley
Consultant, Comedian, Community leader
Adelaide, Australia
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top