LP Logo
line
MPN_2015_website

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

Welcome to
LobsterPot.


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

Dashboards/Reporting

Proofs of Concept

Proofs of Concept

More Services here.  

News and Events

LobsterPot HTML5 PivotViewer – now Open Source!

April 23, 2012

Hi – Roger here. Two months ago I posted about a project that I’ve been working on during down time here at LobsterPot, a port of the Silverlight PivotViewer control that has been built exclusively on web technologies – HTML5 and JavaScript. If you’re not familiar with PivotViewer it is a visualisation tool that I’ve always felt never got the attention it deserved.

So I put an early version out there to see what people thought – not expecting much. Well I can honestly say that the response has been overwhelmingly positive, I’ve been inundated with requests to finish it off as people were exited to build collections with their own data.

So I’m pleased to announce that the LobsterPot HTML5 PivotViewer is now an Open Source project hosted on CodePlex. You can find it here: http://lobsterpothtml5pv.codeplex.com.

more...

The control is still very much a work in progress and there are still pieces of functionality that is missing. I’ll be updating the documentation over the next few days and the plan is to continue work on the control so that it can render static CXML based collections as well as its Silverlight counterpart.

If you’ve got an existing CXML based collection then please download the source and let me know how well it does/doesn’t work as well as if there are any bugs or functionality that is missing. The LobsterPot HTML5 PivotViewer has been built as a jQuery plugin with extensibility in mind. I’ll be posting more about ways that the control can be enhanced, including how get started extending it to work with other data sources.

Going forward the plan is to have two versions of the control: The open source version that will support static CXML based collections and a paid version that will be enhanced with dynamic collections, tile templates and additional views for mapping, data grids and charts. If you’re interested in having LobsterPot build a collection for you please contact us.

T-SQL in Chicago – the LobsterPot teams with DataEducation

March 26, 2012

In May, I’ll be in the US. I have board meetings for PASS at the SQLRally event in Dallas, and then I’m going to be spending a bit of time in Chicago.

Data EducationThe big news is that while I’m in Chicago (May 14-16), I’m going to teach my “Advanced T-SQL Querying and Reporting: Building Effectiveness” course. This is a course that I’ve been teaching since the 2005 days, and have modified over time for 2008 and 2012. It’s very much my most popular course, and I love teaching it. Let me tell you why.

more...

For years, I wrote queries and thought I was good at it. I was a developer. I’d written a lot of C (and other, more fun languages like Prolog and Lisp) at university, and then got into the ‘real world’ and coded in VB, PL/SQL, and so on through to C#, and saw SQL (whichever database system it was) as just a way of getting the data back. I could write a query to return just about whatever data I wanted, and that was good. I was better at it than the people around me, and that helped. (It didn’t help my progression into management, then it just became a frustration, but for the most part, it was good to know that I was good at this particular thing.)

But then I discovered the other side of querying – the execution plan. I started to learn about the translation from what I’d written into the plan, and this impacted my query-writing significantly. I look back at the queries I wrote before I understood this, and shudder. I wrote queries that were correct, but often a long way from effective. I’d done query tuning, but had largely done it without considering the plan, just inferring what indexes would help.

This is not a performance-tuning course. It’s focused on the T-SQL that you read and write. But performance is a significant and recurring theme. Effective T-SQL has to be about performance – it’s the biggest way that a query becomes effective. There are other aspects too though – such as using constructs better. For example – I can write code that modifies data nicely, but if I haven’t learned about the MERGE statement and the way that it can impact things, I’m missing a few tricks.

LobsterPot SolutionsIf you’re going to do this course, a good place to be is the situation I was in a few years before I wrote this course. You’re probably comfortable with writing T-SQL queries. You know how to make a SELECT statement do what you need it to, but feel there has to be a better way. You can write JOINs easily, and understand how to use LEFT JOIN to make sure you don’t filter out rows from the first table, but you’re coding blind.

The first module I cover is on Query Execution. Take a look at the Course Outline at Data Education’s website. The first part of the first module is on the components of a SELECT statement (where I make you think harder about GROUP BY than you probably have before), but then we jump straight into Execution Plans. Some stuff on indexes is in there too, as is simplification and SARGability. Some of this is stuff that you may have heard me present on at conferences, but here you have me for three days straight. I’m sure you can imagine that we revisit these topics throughout the rest of the course as well, and you’d be right. In the second and third modules we look at a bunch of other aspects, including some of the T-SQL constructs that lots of people don’t know, and various other things that can help your T-SQL be, well, more effective.

I’ve had quite a lot of people do this course and be itching to get back to work even on the first day. That’s not a comment about the jokes I tell, but because people want to look at the queries they run.

LobsterPot Solutions is thrilled to be partnering with Data Education to bring this training to Chicago. Visit their website to register for the course.

@rob_farley

SQL Community events in Melbourne

December 2, 2011

LobsterPot Solutions is a company that is fully dedicated to supporting the SQL Server community.

more...

Its owner, Rob Farley, has supported conferences such as SQLBits and PASS, and has had significant involvement in local user groups, including running the Adelaide SQL Server User Group for over six years. He has even been appointed as an advisor to the PASS Board of Directors, and is currently running for election to become a director. This mindset is common in all LobsterPot staff, who are all recognised faces at conferences both around Australia and in the rest of the world.

With this in mind, LobsterPot Solutions is proud to be the first sponsor of the SQL Server Social events in Melbourne, and to help coordinate the events. The SQL Server community is one of the strongest technical communities around the world, and events such as SQL Server Social help strengthen it even further. If you haven’t been to one, please make a point of adding it to your diary and getting to know more of your fellow database professionals.

To find out more about the next SQL Server Social event, visit the SQL Server Social blog.

World Series of PASS

August 24, 2011

I’m sure Americans understand the joke that is the “World Series” of baseball. Everyone else rolls their eyes and knows that this ‘world’ means North America.

more...

Some people feel similar with PASS, unfortunately. The North American Conference and the Global Summit are one in the same, and the 2013 Summit is to be held in Charlotte, North Carolina, to bring it “closer to database pros in the Eastern US who may not have been able to make the cross-country trip in the past.” The 24 Hours of PASS events have been split into two sets of 12, because numbers show that fewer people attend the sessions when America sleeps. “Two Days of Free SQL Server Training” is actually two Nights where I live, and most other people outside Europe and the Americas. (I’m actually on the organising committee for 24HOP, and am hoping to see this change back again soon)

And so it’s very exciting to see that there are people within PASS who are trying to Globalise the organisation more. And that’s GlobaliSe with an eSs, not a Zed. Microsoft’s Mark Souza and the current PASS President Rushabh Mehta are among those keen to make this happen, and I was recently invited to Stockholm for some meetings with representatives from around the world to discuss how to make PASS more global (which unfortunately, also means less US-centric).

It’s an interesting challenge – trying to think how to cater best for people who are essentially a minority in an organisation. It’s clear that the majority of PASS members are in the US. This is no surprise – it’s also the place that more SQL Server licenses are sold. But there is also a large portion of the SQL Server world which is not being targetted by PASS. The US market is comparatively low-hanging fruit, but there’s something to be said for reaching further afield. The US community will still benefit from most initiatives that are designed to cater better for non-US folk, but the non-US folk are less likely to benefit from US-ones.

Part of the challenge will be around metrics. If PASS measures success by the number of members, then it makes sense to focus on the more-populated areas of America. On the other hand, if success is measured in other ways, perhaps even ones that are more qualitative than quantitative, then globalisation can make better sense.

The meetings in Stockholm were very interesting, and it was good to hear opinions from other parts of the world, not just Americans (or Australians). But one of the most interesting things happened towards the end of it.

Three of us were invited to be non-voting advisors on the PASS Board of Directors – Raoul Illyés (Denmark), James Rowland-Jones (UK) and me (Aus). These appointed positions, only for a year (based on what the board is allowed to do). See page 4 of http://www.sqlpass.org/Portals/0/PASS%20Bylaws%20–%20June%202009.pdf, "The Board may also choose to appoint any number of non-voting advisors to the Board by a majority vote for a period of up to one year each."

Yes, these are currently non-voting positions that we’re taking on. But we do still have the ability to go through the election process to earn the ability to vote on board issues. I’m not sure we really need it though – this appointment will give the three of us (and in turn, our respective regions) a decent voice, even if the final decision is left to the existing people. In time, who knows how we can influence PASS and how PASS can influence the SQL world.

Finally – this isn’t about PASS taking over the world. It’s about PASS being better placed to support the worldwide community. This will probably involve supporting non-PASS events (such as SQLBits) too, and possibly even reducing the focus on requiring communities to sign up as official PASS chapters. A lot of things might change, but the hope and focus is on making PASS a better vehicle for supporting the worldwide SQL Server community.

@rob_farley

PASS Summit pre-conference seminar by Rob Farley

May 27, 2011

PASSSummit2011The annual PASS Summit in North America is the largest SQL Server event in the world. There is no other event on its scale anywhere. So it is with great honour that LobsterPot’s Rob Farley will be delivering a pre-conference seminar at the 2011 event, held in Seattle from October 11-14.

more...

The seminar that Rob will be delivering is a slightly-modified version of the one that he delivered at the SQLBits conference in the UK in 2010, and is called “Fixing Queries Using Advanced T-SQL Constructs”. The details of both it and the other LobsterPot submissions for the PASS Summit can be seen at http://lobsterpot.com.au/lobsterpot-submissions-for-sqlpass.

The official announcement from PASS about the chosen seminars will be around June 1st, and the announcement about breakout sessions is expected to be a few weeks later.

New hires, new site, new location

May 13, 2011

Exciting times for LobsterPot – Martin & Heidi joining the team, a new website (lobsterpot.com.au), and a Melbourne presence!Melbourne Skyline

more...

In March, Martin Cairney joined the team. Martin is a long-time member of the local Adelaide SQL Server community, and has been a friend of mine for some years now. He has spoken at the Adelaide SQL user group before, and when 2007 saw him move to the UK for a while, I wished him all the best. Martin went on to speak at the first SQLBits event, and became a regular at those conferences until he came back to Adelaide last year. He also spoke at SQL community events around the UK, establishing a good profile there. It was definitely good to get him on board a couple of months ago.

This month, Heidi Hasting brings the number of people in the company to seven. Heidi has worked with some of our staff before, and I see her having a massive future with the company.

You can see the new website for yourself! It’s clearly much better than the old site, which was little more than a placeholder. The new one has the attention of a proper web designer (instead of just being a bit of HTML thrown together by me), runs on the WordPress platform, and features a picture of Glenelg jetty, taken by my lovely wife. Most Adelaide beaches are just amazing, and it’s nice to be able to show one off on the website.

But perhaps the biggest news – we have a Melbourne presence now!

Martin has moved to Melbourne, and we’re picking up clients there. I imagine I’ll make some trips over there myself in coming weeks/months, hopefully speak at the odd user group, visit clients, and maybe see some friends and family as well.

Expanding out of Adelaide has been on my mind for some time. While Adelaide is a great place to do business, and everyone should consider moving here, it’s small compared to many places (only the fifth largest city in Australia). Establishing LobsterPot in other places makes good sense. Melbourne is a great city – I used to live there, and my brothers and their families still do. We’ve had the occasional Melbourne-based client before, but never enough to consider having a consultant based there. We do have a consultant there now, and we are well-and-truly open for Melbourne business.

LobsterPot submissions for SQLPASS

May 10, 2011

May 6th, 2011
(by Rob Farley)

PASSSummit2011My guys are great! When PASS started accepting abstract submissions for their Summit (in October this year), some of the LobsterPot employees immediately started looking into ideas for talks they could do. We rate communication as one of our key values at LobsterPot, and all my staff are keen presenters.

more...


Roger Noble was at the PASS Summit with me last year, and has since spoken at both the Adelaide SQL Server User Group and Adelaide SharePoint User Group. Considering the work he’s done in data visualisation with PivotViewer over the past year, he was keen to be able to submit a session on that. This technology is seriously cool stuff – quite a few of our clients have been very interested in it and are now using PivotViewer to get at their data in new ways. You can see examples of Roger’s work at http://pivot.lobsterpot.com.au

Get even more from PivotViewer (Roger Noble)

With the release of the Silverlight PivotViewer control from Microsoft in June 2010 we saw the beginning of a new direction for data visualisation and interactivity, allowing data to be browsed and filtered in ways that highlighted information that could have easily been missed. This session will show you how to take the PivotViewer control and enhance it even further to provide even more ways to display your data, including placing information on maps, and showing extra information in the PivotViewer tiles according to the zoom level. From sourcing data from PowerPivot and SharePoint 2010, using Visual Studio 2010 to add new functionality and improvements in future versions this session will show the range of ways that PivotViewer can effectively be used in your organisation.


Like most of the team, Ashley Sewell has been doing a bunch of work with clients implementing cubes and reports. The talk he’s put in reflects a very common emotion that he gets from clients when they first start talking about Business Intelligence. They want to know that they’re not just getting their data in a different format, but that they’re going to be able to reach into the data themselves and realise that ‘Analysis’ aspect of SSAS. Ashley used to be tertiary lecturer, and understands the importance of giving presentations that are useful as well as at an appropriate technical level. This talk will be excellent, and I really hope it gets picked.

So you’ve got a Cube. What’s Next? (Ashley Sewell)

Did you ever get to the end of an Analysis Services session thinking "Cubes sound great but what can I show the analysts and execs back at work to woo them?". If your answer is yes then this session is for you. You will be taken through some of the Business Intelligence reporting and dashboarding available using a combination of PerformancePoint Services 2010 and Reporting Services 2008 R2 with particular emphasis on combining the best of each offering to maximise the impact of your dashboards. You can expect to leave this session with a deep enough understanding (and a list of gotchas) to enable you to create your own dashboards and data visualizations that bring the data within your cube to life on the web.


As expected, I’ve put a few submissions – a pre-conference seminar and two regular sessions.

The pre-con is an enhanced version of the one I did at SQLBits 7. In that, I go through a bunch of T-SQL queries that could have been fixed using T-SQL that most people aren’t aware of. For example – many people would shy away from something like ORDER BY MAX(OrderDate) DESC, but if you understand what’s going on there, when it’s good and when it’s bad, then it can be just fine. This pre-con got excellent feedback at SQLBits, and I think it will please PASS Summit delegates as well.

Fixing Queries With Advanced T-SQL Constructs (Rob Farley)

Have you inherited queries that are not your own, and are finding that performance isn’t so great? Removing cursors in favour of set-based queries is useful, but even set-based queries can perform poorly. Understanding the impact that various constructs can have on a query plan could be key to resolving many of these issues. In this seminar, irrepressible SQL MVP Rob Farley will take a look at some real-life queries and take the audience through examples of constructs that can have significant effects on tuning. This will include complex nested joins, join simplification, procedural functions, SARGability v residuality with predicates, better execution plan reading, start-up parameters, force hints, complex sorting, ORs, effective Dynamic SQL, GROUP BY v DISTINCT, unique indexes, temporary tables, APPLY considerations, and more. You’ll discover profoundness in things you thought you knew, and you’ll even see when a covering index that returns a single row can be a bad thing. This will be a day spent in Management Studio, not PowerPoint. If you want to know how to persuade the Query Optimizer to do a better job of running your query, this day is for you. The examples will apply to a variety of versions, with most of it being useful even in a SQL 2005 environment.


Another talk that I’ve done in the past is one called “Understanding SARGability (to make your queries run faster)”. In fact, last year this talk was a ‘stand-by’ for the PASS Summit. I also gave it at SQLBits 7, with Brent Ozar (@BrentO) and Buck Woody (@BuckWoody) heckling me from the back. Brent tweeted “Okay, wow, @robfarley is a seriously good presenter”, and although he got my Twitter handle wrong (it’s @rob_farley), I was very flattered. It’s one of my second-favourite tweets still.

Over recent times, I’ve found that people really don’t seem to understand the significance of having predicates fall into the category of “Residual”. I wrote about it recently, and was quite interested to see some of the reactions that people had when they talked about it with me. Jack Li wrote a post last week about a query which took longer than expected because a Hash Match was putting a lot of data into a single bucket. This is a common problem that gets missed, because of the impact of having the selective predicate treated as residual. I’m going to write more posts on that in the coming weeks, and a lot of that will be covered in one of the talks I’ve submitted this year. Residualiciousness isn’t a real word, but I figure that shouldn’t stop me.

Joins, SARGability and the Evils of Residualiciousness (Rob Farley)

You wouldn’t believe how often people just aren’t using their indexes effectively, whether it be searching for data, or joining tables. Quite often, this comes down to predicates becoming residual. Yes, residuality is a problem, and once a predicate has become residualicious, you may as well be scanning instead of seeking. There’s so much more to SARGability than people think, and people can often miss out on significant performance benefits by not appreciating this – particularly with new and improved query hints becoming available in SQL 2008 R2 SP1 and Denali. SARGable means Search ARGument Able and relates to the ability to search through an index for a value. Unfortunately many database professionals don’t really understand it – especially in regard to joins – leading to queries which don’t run as well as they should. In this talk, you’ll learn how to tell whether a predicate is being used correctly, and to evaluate what’s really going on in your Seek or Join. You’ll even learn to use new features in SQL 2008 R2 SP1 and Denali to affect the residuality of your predicates. This is a talk involving lots of demos, showing plenty of queries and execution plans.


The other talk I’ve submitted was inspired by a conversation with my friend Jamie Thomson (@jamiet), who unfortunately won’t be at the PASS Summit this year (he does have an excellent reason though). I happened to mention something which I considered an important consideration about queries used for SSIS, and he told me I had to write a blog post about it. I eventually did, and it got me thinking about a bunch of things that SSIS Tuning Talks (like those that Jamie gives) which are very relevant to tuning T-SQL, but yet almost never get mentioned by standard talks. Some of them get covered in the pre-con seminar too, and I’m sure I’ll have to get blog posts written on some of these things over coming months.

Tuning T-SQL Using Lessons Learned From SSIS (Rob Farley)

We see presentations telling us how to tune T-SQL, looking at things like how a covering index can help avoid an expensive lookup, and the importance of set-based thinking. But there can be a lot more to finding bottlenecks in an execution plan, and there are significant parallels with the kind of concerns we have when tuning SSIS Data Flows. This session will look at some of the things that SSIS gurus explain when in looking at how to make SSIS run faster, and draw strong parallels to things that many query tuners don’t realise. If only they paid attention to the SSIS world! There will be a lot of examples in this session, explaining what’s happening in query plans and the ways that you can persuade your queries to run more like your SSIS packages, and vice-versa.


Looking at the long list of abstract submissions this year (and right now there’s about three hours for more to come in), I think it’s going to be a great event. With buzz around Denali and a stronger community than ever, I think it’s going to be huge.

There will be handful of LobsterPot employees there, and I hope you will be too!

@rob_farley

On technical talent

April 10, 2011

Tuesday, January 25, 2011 3:15 PM
(Rob Farley’s Blog Post)

In honour of the regular T-SQL Tuesday blogging, the UnSQL theme started, looking at topics that were not directly SQL related, but nevertheless quite interesting. This is the brainchild of Jen McCown, who posted the second of these recently.

I’m actually a bit late in responding, as I haven’t got it in my head to look for these posts yet. Still, Jen says I can still contribute now, hence this post. The theme this time is on Tech Giants.

I could list people all day for those I admire in the SQL Server space, and go on even longer if I branch out to other areas. But I actually want to highlight four guys that I admire so much for their skills, integrity and general awesomeness that I hired them.

Yes – the guys that work for me at LobsterPot Solutions, being Ben McNamara, David Gardiner, Roger Noble and Ashley Sewell. I admire them all, and they present the company with a platform on which to grow.

One other thing: Why ‘LobsterPot’?

April 10, 2011

Saturday, November 20, 2010 10:11 AM
(Rob Farley’s Blog Post)

I get this question a lot.

I don’t mean just ‘every so often’, I mean all the time. It would average out to daily, but there are still days when I only see people who have already asked. Either way, it’s definitely a lot. And they always put it the same way: “One other thing: Why ‘LobsterPot’?”

more...

At LobsterPot Solutions, we don’t have salespeople. None at all. Instead, we rely on word-of-mouth marketing – people telling each other about us, about how we’ve helped them, are good value-for-money, approachable, knowledgeable, and so on. That means making sure that all our staff (currently five of us) understand the values of the company and represent the company accordingly.

But still, the idea of branding is still something that takes some effort.

Before I go too far into this, I should point out that I’ve had conversations with at least one company about LobsterPot’s branding, and how to leverage this better, through press-releases, advertising campaigns and the like – but I’m going to write about the name, logo, and how I’m trying to differentiate the company brand from my own personal brand.

I wish I had a really good story about a LobsterPot that I could share. Unfortunately, I don’t. I can’t relate some story about some time I was cooking seafood, and forever branded myself with the shape of the pot handle, deciding to name my company after it. Instead, it just comes down to my thinking about brand-names in general.

When people tell me about successful brands, they frequently include Google, Microsoft, and IBM. I had this experience just yesterday even, during an explanation of my branding. These are all successful companies, but I think their brand strength is a reflection of the general company strength, rather than the brand itself being compelling. I can’t deny the two go hand-in-hand, but when considering a start-up, I wanted something to differentiate my company.

I saw four types of company names that I wanted to avoid.

The first type was made-up words. Accenture and Avanade, even Google and Microsoft are all great names once you know the name, but I’m not sure they stick in the mind very quickly. I could tell you about the excellent pain-killer the paramedics used when I had a back-injury in 2003, but I can never remember its name. I just refer to it as the ‘green whistle’, which suggests to me that ‘green whistle’ would make a better brand name than Penthrox (and yes, I just had to look that up).

Another type of branding is the opposite of a made-up word, but rather a word that is so indistinguishable from lots of other brands that it gets lost. A name like Data Solutions is never going to grab me, never going to be able to turn up in a search engine, despite describing the company quite well. Plus, it might not expand too well if the focus of the company shifts away from data.

Third is the dreaded TLA – the three-letter-acronym. IBM is the classic example of this, but there are countless others. I guess there are a limited number of these, but when you start including HP and KPMG, you quickly realise that there are just about as many as you can imagine, and the struggle that these companies must have in being remembered. We might all find that KPMG rolls off the tongue, but if someone told you it was actually KBMG, or KPMC, then you’re relying on the company reputation to remind you. I guess most TLAs have been formed because of company names that begin as either my second brand-type or my fourth, but the brand gets established as the acronym rather than the longer name.

The last kind I wanted to avoid was the “I’ve named the company after myself” scenario. This isn’t so bad on the whole, but I don’t actually want to have a company that can’t be separated from myself. You all know companies that have the person’s name featuring in the brand – shops do it a lot. Almost all the big supermarkets are named after the person that started them, and while this can speak of a personal touch, and a reputation that is attached to an individual, I’m not sure it works so well for a consultancy if I want to be able to send someone else to do a job.

In fact, being able to separate my own branding from the company is something I need to constantly battle. I’m the one who travels to conferences, who received the MVP award, who sits on committees, and so on. Being in Australia, in a different time-zone to where many of the world’s SQL experts live, and being in Adelaide, a city which is disregarded by many Australians even, I can’t ignore my personal brand. If I go somewhere, I want to be larger than life, and deliver a talk that is both educationally jaw-dropping and memorable. I want people to be talking about me after I’ve left the room (hopefully in a nice way too). I can’t be at as many events as many of the SQL celebs (like Jen herself), and I’m asleep when most of them are using Twitter too. I need to be different enough personally to be noticed.

And to be a company (instead of just Rob), I was going to need company branding that ticked a lot of boxes.

I wanted red. I see red as a strong colour, which can help its memorability. Solid red too, not shades of red, or a small amount of red. A large solid block of red, which isn’t devalued by other colours thrown in.

I wanted strong imagery. I wanted people to immediately recognise the words being used, and to have an image come to mind. Hopefully something that would lend itself to a logo.

I wanted strong association and emotion. The imagery that comes to mind should be associated with good feelings, memories of good times.

I thought of companies like egg.com (a financial services company in the UK), Angry Koala (a BI consultancy run by my good friend Grant Paisley, with whom I had a number of conversations around branding), and Banana Blue (an online supermarket). These are all company names that you just remember. They’re ‘funny’, if you like. They all involve a thing, but are slightly more than the thing. It’s the Angriness of the Koala, or the Blueness of the Banana, or the Interwebsicality of the Egg which provides the hook. There’s an absurdity which helps you remember the name.

So one day the Lobster motif occurred to me, and the idea of the Pot, rather than the Lobster itself. Ok, so it doesn’t have the absurdity aspect, but as a company of people, I think the Pot seems to work. Plus, the cooking pot is the delivery mechanism associated with getting Lobster onto your plate, which works.

The Lobster is red. The imagery associated with the claw is strong – it’s easily turned into a logo (and in fact, the logo I use is clearly a logo, not a photo, easily reproduced, minimal number of colours, yet clearly a lobster claw and almost possessing a personality if your imagination can go far enough). When people think of lobsters, they remember the time they were at a fancy restaurant, celebrating some event, or cherishing a loved one, splashing out on some luxury – all emotions I’m more than happy to associate with my business. There’s even a big lobster in South Australia, which helps the connection to where the business is based.

Okay, so there’s nothing about LobsterPot that suggests business insight or databases (except perhaps the “SELECT Claws”), but I’m not sure that matters. I can wear a bright red shirt which stands out at conferences, and have business cards which even show a lobster in a pot. The name is different enough to make people remember, and perhaps they even spend a moment thinking about if there’s a connection between the business and brand. I do often say “sounds like a restaurant, but isn’t”, which helps people with the imagery, and provide extra hooks for memory.

But most of all, everybody asks.

Microsoft SQL Server code-named ‘Denali’ – CTP1

April 10, 2011

Tuesday, November 09 2010 9:48 PM
(David Gardiner’s Blog Post)

Wednesday morning I’ll be giving a quick summary of all the new announcements from the 2010 PASS Summit in Seattle (courtesy of LobsterPot’s on-the-spot reporters Rob and Roger) to the Adelaide leg of the PDC10 Roadshow.

In preparation for that, I did a quick search for any Denali tidbits, and discovered the CTP is now publicly available. I’m downloading as we speak/type. Annoyingly, the Release Notes link is broken at the moment. Hopefully that gets fixed soon.

Download links

My top predictions for new features (seeing as I haven’t got it installed yet to find out)

  • Failover cluster support for Windows Phone 7
  • Query optimiser support for X-Box 360 Kinect

Ha.. though actually I can see some possible use of Kinect with reporting and data mining in the future.. That would be cool.

Maybe they’d have to call that “Minority Report-ing Services”