LP Logo

LobsterPot Solutions™ is proud to be a Gold Competency Partner in the Microsoft Partner Network.

Welcome to

Improving your data story.

LobsterPot Solutions is an Australian SQL Server and Business Intelligence consultancy, offering consultancy and training services. LobsterPot Solutions specialises in the Microsoft Data Platform, including Power BI, SQL Server and Azure, from data resilience to data analytics, to Big Data and IoT, and of course performance tuning, health checks, and more. With experts in both Melbourne and Adelaide, we can help your organisation become more data-driven.

LobsterPot Solutions is a company of firsts. When the Microsoft Partner Network went live, we were the first company in Australia to become a Gold Competency Partner, the first in the world to gain the Gold Competency in Business Intelligence. Since then we have become the first to employ three Australian SQL MVPs, the first company in the whole Asian region to have an APS / PDW trainer on staff, and have been involved in training other trainers in the region.

Performance Tuning

Performance Tuning

Dashboards and Reporting


Proofs of Concept

Proofs of Concept

More Services here.  

News and Events

Once again, presenting at the PASS Summit

June 26, 2016

Every year that LobsterPot Solutions has been sending people to the PASS Summit, we’ve also had presenters. From 2010 when Rob Farley attended his first PASS Summit, through to this year, that’s seven consecutive years of having LobsterPot Solutions’ employees on the presenter list. And it hasn’t just been Rob Farley who has been presenting – in fact, Rob didn’t present in 2012 or 2014. But Martin Cairney and former employees Julie Koesmarno and Roger Noble have given presentations while on the team.


The talk Rob’s giving this year is on In-Memory Operational Analytics (follow the link to read the actual abstract at the SQLPASS site). The technologies of Hekaton, Columnstore, and R, are incredibly powerful by themselves, but when used together can provide for some business-impacting solutions. It’s a beginner-level session, so it’s not going to be exploring the depths of how some of the different scenarios work, but he’ll cover what you need to know, and open to your eyes to the potential of these technologies.

Education sector webinar on Power BI

June 26, 2016

We’ve had a number of customers in the education sector. Sometimes schools, sometimes universities, sometimes the Education Department within one of the state governments. Every time we work with these organisations we are thrilled to see that data is coming to the forefront of people’s thinking. And it’s a tremendous honour to be asked to present to Microsoft customers within the education sector as part of Microsoft’s Education Tech Series. Register at http://aka.ms/edupowerbiwebinar, or read on for more.


The topic of the webinar is Power BI. Rob will be presenting in Adelaide at the Microsoft offices to an audience, on the big screen at the Microsoft offices in Melbourne, and via Skype to anyone else who tunes in. LobsterPot Solutions can help improve the data story in these organisations in all kinds of ways, and we’d like to thank Microsoft for the opportunity to be part of this initiative.


US presentations coming up

September 7, 2015

As usual, LobsterPot employees will be heading to the PASS and MVP Summits in the Seattle region this year, and if you will be in the Pacific Northwest, you will have the chance to hear some of us present. Martin Cairney will be presenting at the pre-Summit SQL Saturday in Portland, and Rob Farley will be presenting at the PASS Summit in Seattle. This will Rob’s tenth presentation at the annual PASS Summit, including regular sessions, spotlight sessions, lightning talks, and his 2011 pre-con.

Another US hire – welcome Mickey Stuewe!

January 12, 2015

The US side of LobsterPot Solutions is going well, and we have brought on another staff member. We’re hugely excited to announce that we’ve hired well-known SQL expert Mickey Stuewe!

Mickey fits into the LobsterPot culture really well. Not only is she a recognised expert in SQL Server, with a history in training (she has been a Microsoft Certified Professional longer than almost anyone I know, and has been a Microsoft Certified Trainer), but she is very community-minded. She presented an advanced session on Reporting Services at the PASS Summit a couple of months ago, and is the founder of the BI and SQL Server User Group near where she lives in Orange County, California. She blogs, also presents regularly at SQL Saturday events and Red Gate’s SQL in the City events, and was voted the “Best New Community Voice” in last year’s Tribal Awards.

She is a leading light in the SQL Server space, and it’s a tremendous honour to welcome her to LobsterPot Solutions.

Four SQL MVPs – including three in Australia

January 2, 2015

Today LobsterPot Solutions sets a new first. We are the only company to ever employ three current Australian SQL MVPs, giving us four awardees in total. Congratulations to Martin Cairney who joins Julie Koesmarno (AUS), Ted Krueger (USA) and Rob Farley (AUS) as recipients of this prestigious award. This demonstrates LobsterPot’s ongoing commitment to the SQL Server community, that show that our consultants are truly influential in the SQL world.MVP_FullColor_ForScreen

From Microsoft’s website about MVPs:
Microsoft Most Valuable Professionals, or MVPs are exceptional community leaders who actively share their high-quality, real-world deep technical expertise with the community and with Microsoft. They are committed to helping others get the most out of their experience with Microsoft products and technologies.
Technical communities play a vital role in the adoption and advancement of technology—and in helping our customers do great things with our products. The MVP Award provides us with an opportunity to say thank you and to bring the voice of community into our technology roadmap.

This fits very closely with LobsterPot’s desire to help people with their data story. We help with the adoption and advancement of SQL Server, and help customers do great things with data. It’s no surprise that we see a high proportion of LobsterPot consultants are MVP awardees.

Merry Christmas

December 24, 2014

I just wanted to take a moment to wish a Merry Christmas to you: people in the SQL Community; people I see at clients and the like; and especially those people I am incredibly privileged to have working at possibly the best SQL Consultancy in the world.

To those who I have represent my brand: I love you guys! You’re all passionate about providing the best experience for our customers, developing the SQL community, and doing amazing things to help people improve their data story. I couldn’t be prouder of you all. Sure, there are times when I lose sleep (and hair) over stuff, but I know that we have each other’s backs, and that’s a brilliant thing. I’ve often likened us to that story about the tiger in a cage. The best way to defend such a tiger is to let it out of its cage. If I can help enable you, and remove any obstacles that come between you and your ability to be phenomenal, then that’s what I’ll try to do. We all have our different styles, but together I think we can be an incredible force. It’s been a crazy year in many ways, including starting the LobsterPot story in the US (and Ted – you’ve been incredible!), but we have even more exciting times ahead, I’m sure. The Microsoft data stack is developing quicker than ever, and people are using it in bigger and better ways all the time.

Merry Christmas guys. Let’s continue to spread the SQL cheer… 🙂


PDW Query Optimization

December 6, 2014

Recently, Rob wrote a white paper about how some simple changes to a database design in Parallel Data Warehouse can leverage one of the lesser-known Query Optimizer methods, with significant results, removing all data movement from many queries. The paper was published on the Microsoft website at http://blogs.technet.com/b/dataplatforminsider/archive/2014/11/14/aps-best-practice-how-to-optimize-query-performance-by-minimizing-data-movement.aspx

The technique used here is one that may be familiar to experts in Query Optimization, but few people within the PDW space are familiar with it. This is just another reason why you should choose LobsterPot Solutions as your preferred APS / PDW implementation partner.

Event: BI and Predictive Analytics

November 24, 2014

LobsterPot Solutions is teaming up with Microsoft and Chamonix to bring an event focused on Power BI and Azure ML, on December 8th 2014. For more details, read on.


This was sent out the other day from Microsoft:

Recently, Microsoft has brought you a number of briefings and events presenting our vision for innovative ways to accessing data and garnering concrete business value from it.

We have demonstrated our vision for ways to search, query, mash-up, share and visualise data that will enable business and government to gain valuable, real insights into their operations and make decisions faster and more accurately. 

Join Microsoft, Chamonix and LobsterPot Solutions, and we will show you how this vision is being executed.

This briefing will cover:

1. Fresh business insights

See Chamonix demonstrate how vast amounts of data can be interpreted easily to identify key indicators to improve and support your operational and strategic decisions. 

2. Easy-to-use analytics tools

LobsterPot Solutions will further extend the value of such data by showing you how the traditionally complex and slow delivery area of predictive analytics is now easy to operate, producing models quickly and without requiring highly specialised and scarce skills.

3. The power of data

See how Microsoft is delivering Software as a Service with innovative capabilities that leverage insights from data  with the same speed at which you run your business or government department.

After this briefing you will have seen how Microsoft’s Business Intelligence vision is a pragmatic way to rapidly deliver business decision support capabilities to the knowledge workers in your organization, using familiar tools and technologies with speed and great value for money.

Register today clip_image001[6]

Suited for those who wish to extract more value from their data assets, to drive new and meaningful insights into the current and future performance of their business or government department.


Monday 8 December
Microsoft Office
147 Pirie Street, L12

Register today clip_image007[4]

Increase your understanding of modern data insights and predictive tools in a pragmatic, real life context.

Welcome time
Session commences
5.00 pm
Session concludes & refreshments served

LobsterPot staff are influential, outstanding and valuable

October 27, 2014

The title of the post says it all, but let me explain why…

It’s not news that LobsterPot has three SQL Server MVPs on staff. Ted received his fifth award earlier in the year, and this month saw Julie get her second award and a ninth for Rob.

But not only that, Julie was recognised as one of Nine Influential Women by Solutions Review magazine, and MartinC received an Outstanding Volunteer Award from the PASS organisation. Ted and Julie have both received this award in the past, and former employee Roger Noble also received this award while he was working for us. It’s all further evidence that LobsterPot staff really are very special.

LobsterPot Solutions in the USA

August 5, 2014

We’re expanding!

lp_usa_squareI’m thrilled to announce that Microsoft Gold Partner LobsterPot Solutions has started another branch appointing the amazing Ted Krueger (5-time SQL MVP awardee) as the US lead. Ted is well-known in the SQL Server world, having written books on indexing, consulting and on being a DBA (not to mention contributing chapters to both MVP Deep Dives books). He is an expert on replication and high availability, and strong in the Business Intelligence space – vast experience which is both broad and deep.


Ted is based in the south east corner of Wisconsin, just north of Chicago. He has been a consultant for eons and has helped many clients with their projects and problems, taking the role as both technical lead and consulting lead. He is also tireless in supporting and developing the SQL Server community, presenting at conferences across America, and helping people through his blog, Twitter and more.

Despite all this – it’s neither his technical excellence with SQL Server nor his consulting skill that made me want him to lead LobsterPot’s US venture. I wanted Ted because of his values. In the time I’ve known Ted, I’ve found his integrity to be excellent, and found him to be morally beyond reproach. This is the biggest priority I have when finding people to represent the LobsterPot brand. I have no qualms in recommending Ted’s character or work ethic. It’s not just my thoughts on him – all my trusted friends that know Ted agree about this.

So last week, LobsterPot Solutions LLC was formed in the United States, and in a couple of weeks, we will be open for business!

LobsterPot Solutions can be contacted via email at contact@lobsterpotsolutions.com, on the web at either www.lobsterpot.com.au or www.lobsterpotsolutions.com, and on Twitter as @lobsterpot_au and @lobsterpot_us.

Ted Kruger blogs at LessThanDot, and can also be found on Twitter and LinkedIn.