On Monday this week I was downtown for some business as the new MVP awards started hitting Twitter. As several of my good friends were awarded this round, I was very happy and excited for them. They’ve all worked long and hard for our wonderful community, and it felt absolutely amazing to see them get recognized. My business concluded, I walked home in a warm, early autumn drizzle and felt rather good about things. This year has been absolutely exceptional i so many ways, as I’ve been out speaking in 15 different countries thus far this year. Fifteen. The speaking have taken off in a way I could not have imagined as I continue to receive favorable responses to my abstracts.
I was recently accepted to speak at a SQL Server-related event in Europe. As I relish the opportunity to speak I was very happy and started preparing in earnest for booking the trip and polishing my session. However, when I took a look at the schedule, I found the name of another speaker that I had not expected to find anymore. This person has been tossed out of one of the most important Microsoft programs allegedly (as I don’t have personal, first-hand knowledge) due to repeatedly misbehaving in general and being sexist in particular – a behavior I have personally witnessed multiple times.
I’m sitting at Schiphol airport in Amsterdam contemplating my midsummer weekend. I was accepted to speak at SQL Grillen, a free one-day (plus one day of paid pre-cons) event in the metropolis of Lingen, Germany. Never heard of Lingen? Well, neither had I, before this event. When William Durkin, the main organizer of the event, gave me the news that I had been accepted, I took the opportunity to ask him where Lingen was, and he told me that it was fairly near “the ass end of nowhere”. Having been to Lingen, I would have to agree. Actually getting there turned out to be a bit of a challenge – in the end, the amazing Andrew Pruski told me that he was driving there from Schiphol, that his flight landed five minutes after mine and that he’d love travel company.
A week ago I woke up in Tel Aviv, Israel, the day after I gave my presentation “Speak your hands - using body language for effective communication” at SQL Saturday in Israel. Despite feeling the onset of a sore throat, I contemplated how I had gotten here. I did not expect to find myself in Israel doing what I love - speaking at conferences and sharing knowledge - when I first started working with databases back in 1997. In fact, I didn’t expect to get very far from my birth town at all. It turns out that was going to be rather far from the truth.
I just came back from my latest trip last night and I’ve been thinking about how to summarize the latest events I’ve been to. It all began with the NIC conference in Oslo in February. There I presented two sessions (Azure SQL Server - the cloud awakens and boring is stable, stable is good - best practices in practice) to some 100 people in total. As is most often the case, It was a great event with great speakers and very good sessions. The conference itself was very well run and I was very happy to have been given the opportunity to share my knowledge with the community so close to home.
This T-SQL Tuesday is an interesting one, as the challenge is to talk about something you’re passionate about outside of the usual work grind. Well, it turns out I’m very passionate about Star Wars, and I’m very passionate charity. Funny thing is, there is a way to combine them. But first, let’s rewind a few years to the beginning of the story. Back in 2013 I went to a small game convention in my home town. I met an acquaintance I had not seen for about 10 years, and while it was great fun to reconnect with him, what was more fun was the fact that he was driving a full-size R2-D2 droid from Star Wars.
I stumbled across SpeakingMentors after seeing a Tweet from Alex Yates. It’s a completely free opportunity for new and budding speakers to get one-on-one mentoring with more experienced people in the industry, all with the goal that sharing is indeed caring. I can’t count the number of times I’ve met absolutely brilliant people that had decided that they weren’t able to speak in public, that they had nothing to say or any of another thousand reasons why they couldn’t do it. SpeakingMentors is an attempt to catch some of these talents and help them grow and flourish. The more great speakers we get in the community the more we all can learn.
Part 5: updating the basic settings for SQL Server 2016/2017 It’s been quite a while since I penned my best practices posts for SQL Server 2012/2014 and I’ve been saying for ages that I should update them for SQL Server 2016. Well, it would seem that hell finally froze over as here we are! Let’s startout with the Query Store. This is a new contraption introduced in SQL Server 2016. It is turned off by default, but in my opinion you should always turn it on. This is done for every database, either via the GUI or ALTER DATABASE [DatabaseName] SET QUERY_STORE = ON;