Category Archives: #SQLPASS

Learning through others

This PASS Summit was a different experience for me – I wasn’t speaking. I’ve presented at three of the five PASS Summits I’ve been to, where the previous one I’d not spoken at was 2012, while I was a PASS Director (and had been told I shouldn’t submit talks – advice that I’d ignored in 2013). I have to admit that I really missed presenting, both in 2012 and this year, and I will need to improve my session abstracts to make sure I get selected in future years.

I’m not a very good ‘session attendee’ on the whole – it’s not my preferred style of learning – but I still wanted to go, because of the learning involved. Sometimes I will learn a lot from the various things that are mentioned in the few sessions I go to, but more significantly, I learn a lot from discussions with other people. I hear what they are doing with technology, and that encourages me to explore those technologies further. It’s not quite at the point of learning by osmosis simply by being in the presence of people who know stuff, but by developing relationships with people, and hearing them speak about the things they’re doing, I definitely learn a lot.

Of course, I don’t get to know people for the sake of learning. I get to know people because I like getting to know people. But of course, one of the things I have in common with these people is SQL, and conversations often come around to that. And I know that I learn a lot from those conversations. I don’t have the luxury of living near many (any?) of my friends in the data community, and spending time with them in person definitely helps me.TSQL2sDay150x150

And it’s not just SQL stuff that I learn. This month’s T-SQL Tuesday (for which this is a post) is hosted by Chris Yates (@YatesSQL), who I got to run alongside on one of the mornings. Even that was a learning experience for me, as we chatted about all kinds of things, and I listened to my feet hitting the ground – another technique I learned from a community – and made sure I stuck to my running form to minimise the pain I’d be feeling later in the day. Talking to Chris while I ran helped immensely, and I was far less sore than I thought I might be.

On the SQL side, I got to learn about how excited people are about scale-out, with technologies like Stretched Tables coming very soon. As someone involved in the Parallel Data Warehouse space (and seriously – how thrilled was I to be able to chat with Dr Rimma Nehme, who was involved in the PDW Query Optimizer), scale-out is very much in my thoughts, and seeing what Microsoft is doing in this space is great – but learning what other people in the community are thinking about it is even more significant for me.


PS: This is the 60th T-SQL Tuesday. Huge thanks to Adam Machanic (@adammachanic) for starting this, and giving me something to write about each month these last five years.

MVP/SQLPASS Summit Wrapup From a Non-Attendee

(Or “How I Sort of Attended PASS This Year After All and It Wasn’t as Horrible as it Might Have Been”) Wow, my experience at this year’s MVP Summit and PASS Summit was not at all what I had expected it to be for me just weeks ago when I was planning my trip . Life intervened, and as my blog post last week here explained , the short of it is that I was unable to attend either summit for less than fun reasons. As a shut in who has always stayed in connection with the SQL community, particularly at…(read more)

PASS Summit WIT Lunch

With the pleasant sound of cutlery on crockery, those lucky enough to secure tickets to the WIT Lunch at the PASS Summit get to listen to an interview with Kimberly Bryant, who is the founder of a non-profit organisation called Black Girls Code – helping teenaged girls from low-privilege communities to get into technology.

She calls herself an Accidental Entrepreneur, driven by her passion to see the less-privileged have opportunities to explore an industry that was dominated by a very different part of the community. Her daughter was interested in tech, and went on a tech-focused summer camp, where she was the only non-white kid, and one of only three girls. With a crowd of about 40, that was less than ten percent of the camp.

What Kimberly saw at the camp, and in other environments that are dominated by a particular demographic, was that the people who were providing for the group would cater for the masses, and not the minorities. From an economic perspective, I’m sure this makes sense. If you’re going to find something that caters for a particular cluster of people, a particular type of person, then targetting the larger clusters is likely to give the ‘best results’. But (my opinion) this is ignoring the fact that the larger clusters of people tend to be catered for by just about anything. In my experience, if someone is part of a larger cluster, they have a large amount of support from their peers already, and need less from the organisers. But if the organisers can ensure that the edges of the group are looked after, then the ones in the middle will still be just fine, and the whole group will be encouraged.

Diversity is something that the IT industry suffers from, and I do mean ‘suffer’. Without good diversity, our industry is held back. Stupidly, our industry keeps shooting itself in the foot, and it’s the larger clusters of people – I guess that means people like me – who need to take a stand when we see things that would alienate minority groups.

Kimberly Bryant points out that teams need diversity, and that hiring decisions need to ensure that they don’t turn away people because of diversity. For myself, as a business owner, I hope that I never turn someone away because of diversity, because I do agree that teams need diversity. What I love the most though, is that what Kimberly has done is to develop programs to make sure that people from a particular minority group present as stronger candidates to hiring managers.

Let’s encourage people from minority groups to get into IT. We’ll all benefit from it.


Dr Rimma Nehme at the PASS Summit

This Summit’s presentation from Microsoft Research Labs is from Dr Rimma Nehme, bucking the trend of having presentations from Dr David DeWitt. I’m really pleased to be able to hear from her, because she’s an absolute legend.

Among her qualifications is work on the PDW Query Optimizer – a topic closer to me than probably any other area of SQL Server. I just wish I had known this a few minutes ago when I met her, but I’m sure she’ll chat more freely after her big presentation.

Today she’s talking about Cloud Computing, which is great because the cloud space has changed significantly in recent years, and it’s good to hear from Microsoft Research Labs again. For example, analysing the power-effectiveness of a data centre by comparing the total power used by a data centre against the computing power of a data centre. This leads to exploring more effective systems, such as evaporative cooling (which is used by many Australian homes and businesses, of course), making energy-responsibility a key component of cloud computing. With such an effort being put into cloud computing, the globally-responsible option is to use the cloud.

The five key drivers for cloud that Dr Nehme listed are:

  • Elasticity
  • No CapEx
  • Pay Per Use
  • Focus on Business
  • Fast Time To Market

These are all huge, of course, and the business aspects are massive. It’s increasingly easy to persuade businesses to move to the cloud, but the exciting thing about the technologies that have been discussed this week is the elasticity point.

Microsoft is doing huge amounts of work to let people scale out easily. New technologies such as Stretched Tables will allow people to have hybrid solutions between on-prem and cloud like never before. With a background in the PDW Query Optimizer, Dr Nehme is the perfect person to be exploring what’s going on with spreading the load across multiple cloud-based machines for these scale-out solutions.

The cloud means that many database professionals worry about their jobs. I’m sure people felt the same way when the industrial revolution came through. People who work on production-lines have been replaced by robots, and database administrators who only do high availability don’t need to handle that in the cloud space. But they will not be redundant. Dr Nehme just said “Cloud was not designed to be a threat to DBAs”, and this is significant. The key here is that we have more data than ever, and we need to be able to use computing power effectively.

We can’t keep going with the amount of data that is appearing, and we need to be more responsible than ever.

Great keynote, Dr Nehme. I hope this is the first of many keynotes from you.


PASS Summit – Thursday Keynote

It’s good to point out it’s still only Thursday, as my laptop tells me that it’s already Friday.

Today is the second of only two keynotes this Summit, which means that it’s the opportunity to hear from Microsoft Research Labs about what’s going on with data from their perspective.

It’s also when we get to hear from the PASS VPs – community members that I used to serve with on the PASS Board of Directors – about how PASS is doing from a Financial and Marketing perspective.

One of the interesting things about PASS is that there are reserves of over a million dollars. I mention this because it’s an area that some people is quite “interesting” for a community and non-profit organisation, but I want to point out that these savings help let PASS be more free in what they (we?) do. Having a million dollars in the bank means that PASS can reach out and do things that will serve the community, even if it seems like it could be risky. There is a lot of risk in running the Summit every year, and this is the most obvious area that PASS could need money to cover costs that might not come back if, say, there’s another volcano eruption in Iceland. I saw first-hand the freedom that PASS had because of the reserves (although some risks were still very high and freedom does not mean irresponsibility), and I know this is a good thing.

From the marketing perspective, the celebration of individuals who have gone beyond the norm is a great part of the Summit event, and the PASSion Award winner has been announced as Andrey Korshikov. This guy has done so much for the Russian Data Community, making him the most influential SQL person in the largest country of the world. You can’t go past that…


Keynote technologies – new or not?

So I’m sitting in the PASS Summit keynote, and there are some neat things being shown.

Something that just appeared on the screen was around having the location of shoppers being shown on a plan of a store. There were some ‘Oohs’ coming from around the room, as they mentioned that Kinect was being used to track locations. Hotspots were appearing on a time-driven picture.

But the thing that I think is most exciting is that this is almost all achievable right now. Collecting information from Kinect is something that my friends John & Bronwen have been presenting about for years, and displaying things on custom maps in Power BI (complete with hotspots) is also very achievable. If you don’t know how to do this, get along to Hope Foley’s session this afternoon (Wed 5th), as she explores more of what’s possible with Power Map. She wrote a post recently about Custom Maps in Power Map, which is a great blog post, walking through how to show spatial data on the plan of a building, playing it against a time dimension.

The stuff in the keynote is excellent – much of it is future, but if you’re at the PASS Summit, you can be having conversations with many of the world’s best experts about how to revolutionise your data story, not just in the future, but right now.


PASS Summit keynote

The PASS Summit has kicked off again with a tremendous keynote from Ranga. He’s been in the role at Microsoft for a little over a year now, and has really come into his own, as can be seen by the presentation this morning. The changes to the data picture haven’t changed hugely over the past year, although the "Internet of Things" space is increasing quickly.


With that, the speed of growth in data volume has kicked in harder than ever. Being able to collect, process, and analyse the kinds of volume that we’re now facing means that scaling is major feature being discussed. In recent years, this meant looking at Big Data and the ways that this can hook into our existing solutions, and technologies like Hekaton have allowed us to scale up to handle huge numbers of transactions in a scale-up scenario.

This year, though, we see scale-out having a refreshed focus. We’re hearing talk of ‘sharding’ more, and the idea of being able to use multiple databases (including cloud-based ones) to achieve scale on demand – an elasticity that suits business more than ever.

Most of our customers at LobsterPot see changes in the amount of business that’s going on across the year, with some having certain key days requiring orders of magnitude more traffic than on ‘normal’ days. They already scale out their websites, but data is another matter. Databases typically scale UP, not OUT.

My work in the Analytics Platform System / Parallel Data Warehouse space makes me acutely aware of the challenges around scaling out data. When you need to perform joins between tables which have their data in different databases, on different servers, there are problems that need addressing. A lot of it happens behind the scenes through complex data movement techniques, so that it looks like a normal query. This is stuff that is hard to do through clever data

What we’re seeing this morning are some of the ways that Microsoft is providing scale out technology in SQL Server and SQL Database. Considering they now have over a million SQL Database databases in Azure, thinking about how to leverage this technology to enhance on-prem SQL Server databases to provide a new level of hybrid is very interesting.

One of these technologies is Stretched Tables, which we saw this morning. This is about being able to take a table in SQL Server and stretch it into SQL Databases in Azure. This means that the table will be sharded across on-prem and cloud – hot data being stored locally, and more-rarely used data being stored in the cloud. For queries that need to access data that’s in the cloud, data can can be extracted from the cloud tables, pushing predicates down to pull back part of the data, transparently (as far as the user is concerned).

This is not like using linked servers and views, handling inserts with triggers. This is achieving hybrid behind the scenes, giving users a logical layer they can query to access their information whether it’s local or in the cloud.

Until now, I’ve always felt that ‘hybrid’ has been about using some components locally and other components in the cloud. But what we’re seeing now are ways that ‘hybrid’ can mean that we have the core of our database – the tables themselves – are handled in a hybrid way.

Exciting times ahead…


Why I am not going to PASS this year

This is going to be one of my toughest non-technical posts ever. And the reason it will be difficult will have an ancillary relationship to the Lortabs I have been taking for the last two days. It has everything to do with me being at home while the 2014 PASS Summit is going on. Previously, the only Summit I had missed was the first one in Chicago. I had just changed jobs, so they wouldn’t pay my way yet. They did send me to the Summit in London that directly followed, which wasn’t a bad trade since…(read more)

Two Presentations This Weekend at #SQLSaturday349 in Salt Lake City

I have the privilege of being selected to fill two slots this weekend at #SQLSaturday349 in Salt Lake City.  The venue is simultaneously hosting the Big Mountain Data event.

My talks are:

To the Cloud, Infinity, & Beyond: Top 10 Lessons Learned at MSIT


Columnstore Indexes in SQL Server 2014: Flipping the DW /faster Bit

The latter is one of my staples.  The former is a new presentation, a preview of my forthcoming delivery for PASS Summit14.

Register, see the schedule, or see the event home page on the SQL Saturday site.  I’ll look forward to seeing you here:

Spencer Fox Eccles Business Building
1768 Campus Center Drive
Salt Lake City, UT 84112

Kudos to Pat Wright (blog | @sqlasylum) & crew for their crazy efforts (pardon the pun) in coordinating the event.

TJay Belt (@tjaybelt), Andrea Alred (@RoyalSQL), & Ben Miller (@DBADuck), keep your peepers peeled—I’m on the way!

Less than a month away…

The PASS Summit for 2014 is nearly upon us, and the MVP Summit is immediately prior, in the same week and the same city. This is my first MVP Summit since early 2008. I’ve been invited every year, but I simply haven’t prioritised it. I’ve been awarded MVP status every year since 2006 (just received my ninth award), but in 2009 and 2010 I attended SQLBits in the UK, and have been to every PASS Summit since then. This year, it’s great that I get to do both Summits in the same trip, but if I get to choose just one, then it’s an easy decision.

So let me tell you why the PASS Summit is the bigger priority for me.

Number of people

Actually, the PASS Summit isn’t that much larger than the MVP Summit, but the MVP Summit has thousands of non-SQL MVPs, and only a few hundred in the SQL space. Because of this, the ‘average conversation with a stranger’ is very different. While it can be fascinating to meet someone who is an MVP for File System Storage, the PASS Summit has me surrounded by people who do what I do, and it makes for more better conversations as I learn about who people are and what they do.

Access to Microsoft

The NDA content that MVPs learn at the MVP Summit is good, but the PASS Summit will have content about every-SQL-thing you ever want. The same Microsoft people who present at the MVP Summit are also at the PASS Summit, and dedicate time to the SQL Clinic, which means that you can spend even more time working through ideas and problems with them. You don’t get this at the MVP Summit.


Obviously not everyone can go to the MVP Summit, as it’s a privilege that comes as part of the MVP award each year (although it’s hardly ‘free’ when you have to fly there from Australia). While it may seem like an exclusive event is going to be, well, exclusive, most MVPs are all about the wider community, and thrive on being around non-MVPs. There are less than 400 SQL MVPs around the world, and ten times that number of SQL experts at the Summit. While some of the top experts might be MVPs, a lot of them are not, and the PASS Summit is a chance to meet those people each year.

Content from the best

The MVP Summit has presentations from people who work on the product. At my first MVP Summit, this was a huge deal. And it’s still good to hear what these guys are thinking, under NDA, when they can actually go into detail that they know won’t leave the room. But you don’t get to hear from Paul White at the MVP Summit, or Erin Stellato, or Julie Koesmarno, or any of the other non-Microsoft presenters. The PASS Summit gives the best of both worlds.

I’m really looking forward to the MVP Summit. I’ve missed the last six, and it’s been too long. MVP Summits were when I met some of my oldest SQL friends, such as Kalen Delaney, Adam Machanic, Simon Sabin, Paul & Kimberly, and Jamie Thomson. The opportunities are excellent. But the PASS Summit is what the community is about.

MVPs are MVPs because of the community – and that’s what the PASS Summit is about. That’s the one I’m looking forward to the most.