Entries by alexander

Custom date formats in Power BI

Until the Power BI team gives us the ability to specify a custom date format on a column, one has to jump through a few hoops to get a custom date format to be recognized as a an actual date format. I finally decided to blog about it as it seems a common enough issue […]

Tech rundown

I’ve been asked about the technical setup I’ve just recently put together to be able to do remote sessions, podcasts, videocasts and similar. Now, this is kind of a dangerous thing to ask me about, as I’m VERY much a techno freak, so you asked, you shall receive. In excruciating detail… This is a picture […]

SQLGrillen

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, […]

Going to unexpected places

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 […]

Spring tour ’18

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 – […]

T-SQL Tuesday #99 – Dealer’s Choice

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 […]

I’ve become a mentor

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 […]

Basic settings for SQL Server 2012/2014/2016, part 5

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 […]

T-SQL Tuesday #97 – Setting learning goals for 2018

This month’s T-SQL Tuesday is hosted by Mala Mahadevan, and she poses a very interesting question with learning goals for 2018. The T-SQL Tuesday founder Adam Machanic posted on Twitter that a learning plan is the way to go, to which I responded that such a list (I misread “plan” to “list”) will probably be […]

T-SQL Tuesday #96: Folks Who Have Made A Difference

  This T-SQL Tuesday was an interesting one, and I’ve been spending quite a few hours thinking about how to formulate my thoughts. Unfortunately the end of said Tuesday is nearing with unreasonable speed, so I’ll have to be brief. This month’s challenge comes from Ewald Cress and is to recognize those who have made a meaningful contribution […]