I’m speaking at SQL Saturday Victoria

On Saturday, 16 March 2019 I will be speaking at SQL Saturday Victoria. This will be the second time that I am able to attend this great event and I’m looking forward to again being in this beautiful city.

This year, instead of a technical presentation I will be presenting a professional development talk ‘Taking back control of your work using Kanban‘. This talk will look at what Kanban is and how it can help you and your organisation retake control of work delivery.

I hope to see you there.




Planning my PASS Summit 2018 schedule

Summit is just around the corner and its time to start thinking about some of the sessions you will be attending. In the past, I have winged-it but this often resulted in me missing session that I really wanted to attend or attending too many of the same type of session. As I will also be attending  SQL Saturday Portland and some of the speakers will also be speaking I also have the opportunity to see some of the sessions there. Below are some of the sessions that I plan to attend this year.

Day One

Day 1 Keynote

PASS Summit always begins with a keynote, in addition to providing a good roadmap of the features to come over the last few years, we regularly get to hear the first announcements of new and upcoming features in SQL Server. With SQL Server 2019 on the horizon maybe there will be more exciting news (Holding thumbs).

Data types do matter – Angela Henry

I am very excited about this talk as it will be the first PASS Summit presentation for my friend Angela Henry. Not only is Sumit a great time to learn but also to support #SQLFamily and I look forward to seeing her do her thing.

I’ve been working with SQL Server for a long time now and kind of just assume that I know the basics, it will be great to get a bit of a refresher and hopefully fill in some of the missing gaps that I have.

My Power BI Report is Slow: What Should I Do? – Marco Russo

Performance tuning in DAX is something that I have been doing more recently of so have some experience with the topic but who can turn down the opportunity to learn from the master. What I’m most looking to take away from this talk is the Approach that Marco takes to identifying the biggest bottlenecks and patterns that he uses to address them.

Storytelling for Machine Learning and Advanced Analytics – Jen Underwood

Jen has worked for Microsoft and many other industry leaders. She has a fantastic grasp not only on the Microsofts BI tools but industry trends in general, I look forward to her thoughts on this.

Speaker Idol: Round One

As I am taking part in this competition this year it is only right to spy on support my fellow contestants. I look forward to watching although I’m not sure if watching the others present will make me more or less nervous.

Day Two

Day 2 will be a little different for me, taking part in this year’s Speaker Idol competition and speaking during the last session of day 2 I will not be attending any afternoon sessions as I will need to prepare for my talk.

Inside Columnstore Indexes – Bob Ward & Ryan Stonecipher

This will be my 4th PASS Summit and I have never been to a Bob Ward session, they are legendary for melting your brain. Unlike some of his other talks, columnstores are something that I am familiar with and share some common implementation patterns that underpin vertipaq which is the engine behind Power BI. Hopefully, I will be able to keep up.

Test Driven Development in SQL Server (How to Deploy Code Safer) – Hamish Watson

Devops is something that I am trying to understand more while integrating it more into my daily activities. On top of that, I understand the speaker like to hand out candy so who could say no to that.

Speaker Idol: Round Two

I will be presenting during this session so if you don’t find me here that means that I have messed up somewhere.

Day Three

Day three I’ll be a bit of a mixed bag, If I make it through the first round then I will again be skipping sessions to ensure that I have enough time to prepare.

Using Azure Databricks to Develop Scalable Data Solutions – Ginger Grant

I got to meet Ginger earlier this year and enjoyed talking to her. She will be presenting on a topic that will play a greater role in the data platform ecosystem in years to come so need to pay attention to more and I look forward to learning.

Building Enterprise-Grade BI Models with Microsoft Power BI – Christian Wade

For a long time, I have been an analysis services fan and most of my work revolves around it in some way, it looks like Microsoft plan to make Power BI the centre of the analytics experience so understanding this may be very important

Deep Dive in DAX Evaluation Context – Alberto Ferrari

Although I understand DAX context evaluation reasonably well this is a must attend talk for me, just like Marco Russo’s session, this is a must-attend talk for me.

Speaker Idol: Final Round

This will e the final session of the summit, I hope to be speaking during this session as well but even if I don’t make it through I will make sure I will be the crowd supporting the other contestants.








PASS Summit 2018

I’m excited to be able to go to my 4th PASS Summit having attended in 2012, 2014 and 2016 (a little bit of a trend there). PASS summit is always the highlight of the Microsoft Data Platform community (more than just SQL nowadays), and I look forward to reconnecting with old friends and meeting new ones. Flying from South Africa to Seattle is always a bit of an effort from both a time and cost perspective, so I like to bring as many people as possible with me especially people who have not had the opportunity before.  This year I joined by two first-timers, James McGillivray (T) and Charl Heinemann (T) along with some repeat attendees like as JP Voogt (T) and Jody Roberts (T). While I have always enjoyed my trips to PASS Summit, this year is going to be a little more interesting.

Microsoft Data platform MVP

This will be the first time I attend PASS Summit as a Microsoft MVP, while there are no extra perc’s to being an MVP at the event it’s always nice to add one more ribbon to my attendee badge and reconnect with some of the many people I met at the MVP Summit.

Speaker Idol

This year I have been selected to take part in the Speaker Idols competition. The Speaker Idols competition consists of several 5-minute lightning talks over four rounds, the first three rounds are made up of four contestants (12 in total) who each present to a panel of judges, a winner is chosen from each group who then go onto the final round held on Friday afternoon. I will be presenting in the second group also made up of Leslie Andrews (T), Janusz Rokicki (T) and Paresh Motiwala(T) all of whom I have never met before so I look forward to getting to know each of them as well as the judges.

Power BI World Tour

I have also been selected to present a session at the Power BI World tour taking place in Bellevue from 29 to 30 October 2018. I will be speaking about Data flows in power BI which at the moment is still in private preview but will likely be made public by then. This is a two-day event dedicated to Power BI and will also take place in the building where most of the Power BI team work out of so it is sure to be a great event.

SQL Saturday Oregon

I will also be attending SQL Saturday Oregon for the second time. I will also be attending with James and JP and we look forward to getting in some hiking while we are there and SQL Saturday Oregon would not be the same without #SQLTrain, without a doubt the best way to travel to PASS Summit that starts the next day.

October and November are going to be great, and I Hope that I will see you all there.



I’m speaking: PASS Business Analytics Marathon


I will be presenting a webinar on 7 June for the PASS Business Analytics marathon sponsored by Quest.

During my talk, I will introduce attendees to streaming data and how it different from how we as data professionals have traditionally dealt with data. We will then look at how Azure Stream Analytics can be used to provide rich real-time reporting.

We will conclude the talk with a practical demonstration of creating a streaming analytics Job in Azure and use PowerBI to visualize the results.

Presentation code:
You can download the code I used to create the events here