Podcast episode 58

As we’re just about to move kneedeepintech.com from one host to another, episode 58 will be temporarily hosted here again!

In episode 58 of Knee-Deep in Tech we talk about several important Power BI blog posts, Surface Hub 2, the upcoming Chromium-based Edge browser, Windows Lite and the power of the Microsoft community!

You can find us on Spotify:

or play right here:

https://shows.pippa.io/kneedeepintech/episode-58

 

Show notes:

Marco Russo – understanding numeric data type conversions in DAX

https://www.sqlbi.com/articles/understanding-numeric-data-type-conversions-in-dax/

 

Kasper de Jonge – Time intelligence solved with modelling and crossfilter instead of DAX measures

 

Patrick LeBlanc @ Guy in a Cube – Power BI Paginated Reports: Data source, Dataset and parameters

 

 

 

 

 

Podcast posts

In a very short while I’ll be removing the podcast posts from this blog as they’ve been concentrated on https://www.kneedeepintech.com for some time. Christmas is coming, and with it a feeling of wanting to clean house, even on this blog 😛

Hard choices

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. As is the case with most people behaving in this way, this person has shown no regret or even understanding how this behavior could possibly be interpreted as wrong in any way. As this information has not become very public, I reached out to the organizers of this event to ask them if they knew about this person’s history and behavior, and if they really wanted someone like that speaking at their event.

While I don’t exactly know what I was expecting for an answer, I was not expecting the answer I received. The answer was basically the organizers putting their head in the sand and explaining that they treat everyone with the equal respect and expect the same back. Unless anyone is convicted of a crime they would not be kept out of speaking at their event, as they could not act on hearsay alone. They were, in my opinion, hiding behind a legal straw man that has little or nothing to do with the question at hand.

As it was abundantly clear that the organizers do not share my values when it comes to community, I was faced with the choice of either speaking at this event and implicitly accepting this individual’s behavior or withdraw to make a point. I chose the latter as I feel the need to stand up to sexism and generally deplorable behavior. I can’t change the world, but I can make a personal stand despite this costing me an important speaking opportunity.

Our community is too precious to not make a stand.

 

*updated with the word “allegedly” as I am not privy to Microsoft’s reasoning.*

What’s in my bag – 2018 edition

All the cool people are doing it (Brent Ozar, Daniel Hutmacher) so I felt compelled to do the same – a quick run-down of the bag (and the contents) that has been travelling with me to 11 countries so far this year. When going speaking in Europe, I never check a bag. There are several reasons for that – it’s more expensive, it takes more time, and I simply don’t need it. I’m away for anything between two and five days and I’ve found that I can comfortably fit all the clothes I need plus computer and various electronic gizmos that goes with it. The bag I chose after *very* careful research was the Tom Bihn Western Flyer. It might not look like much, but it is versatile, perfectly sized for everything I need, it is built like a tank *and* it fits perfectly underneath the seat in front of me on most aircraft (most notable exception was an Embraer 145).

In the beginning I wasn’t sure I could fit everything in it, but after finding the concept of bundle packing everything started to come together. Using this technique I can easily fit one pair of pants, a t-shirt or a dress shirt for every day of travel plus underwear – all without very many wrinkles. I put all the underwear and smaller items in a generic small packing cube and use that as the “plug” in the bundle packing and – voilá! it all fits. I put the resulting bundle in a Tom Bihn mesh bag that fits perfectly in the back compartment of the bag. I’ve also started to include a pair of five-finger shoes to have proper clothing for exercise at hotels – they really don’t take up any space, and it looks way less conspicuous going to gym in them than in my dress shoes…

The other compartment is taken up by my computer. I sport a Microsoft Surface Laptop, and it travels in a laptop sleeve by the Finnish company Mozo, meaning I (almost) never have to take the computer out of the sleeve at airport security. Together with said computer I *always* bring my Bose QC35 series 1 (if you’re thinking of buying them, get the series 2) noise-cancelling headset. These are ABSOLUTELY KEY for me to get *anything* done at either the airport or on the plane.

All the bits and bobs go into an organizer of similar kind to Daniel and Brent that I managed to win(!) at a raffle at this year’s MCT Zero Day at Ignite in Orlando. In here the usual toys can be found – laptop charger, mini displayport-> VGA, HDMI and DisplayPort adapters, power plug adapter, a Microsoft Surface Arc mouse, an iPhone charger, and cable, a Jackery Bolt powerbank as well as my trusty Logitech Spotlight presentation remote. The computer sleeve sits in the back of the front compartment towards the middle of the bag and the cable organizer and headphones sit towards the front. This means that I can put my small, clear toiletry bag on top of the headphones and still have a fully packed bag not be very thick, like so:

 

My passport lives in one of the front zippered pockets.

Going through airport security is a breeze: remove belt and watch (might be unnecessary, your mileage may vary) and put them in either the back compartment on top of the clothing bundle or in the front leftmost pocket, unzip the front main compartment and pull out the computer and the toiletries and put everything in the plastic tubs heading for the X-ray machine. It literally takes me seconds to get the stuff I need OUT of the bag and ever so slightly longer to stuff it back in – all in all, security is dead simple with this setup.

Speaking at TechDays and MCT Summit

I’m on a train heading to Stockholm and Microsoft TechDays, where I’ll be delivering “Azure SQL Server for the on-prem DBA”. This session outlines what’s available in Azure, what is automatic, what is not quite automatic and what is idiosyncratic, as well as explores some of the hard questions one should ask whenever the topic of databases in the cloud comes up.
This is the second time I’ve been selected to speak at TechDays, and I find this to be a very nice conference. It’s a good venue, a lot of people and a great sponsor area. This year I’ll apparently hold court in one of the larger rooms – rather exciting!

While I’d have loved to stay for the whole conference, I was also accepted to speak at the MCT Summit in Cologne. Unfortunately the two conferences run in parallel. I was fortunate enough to be able to ask for an early session at TechDays and late sessions at the MCT Summit, so I’ll be running for the airport pretty much as soon as I’m done in Stockholm. On Thursday I’ll be delivering “SQL Server hates you(?) – what the DBA never told the developers”, and on Friday it’s time for the third run of “Talk tech to me – improve your technical presentation skills”. Both of them are kind of favorite sessions for me, and I’m up to around 10 deliveries of “SQL Server hates you(?)” so I’ve achieved a nice flow presenting that one.

Both of the events provide amazing opportunities for learning apart from my sessions. Check out the TechDays Agenda and the MCT Global Summit agenda!

A most unexpected Monday

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.

The podcast is up to 50 episodes plus around ten extra episodes such as the preIgnite as well as the Ignite ones. There are several interviews that have yet to be released, but suffice to say we’ve had the pleasure to talk to a lot of very interesting people at Ignite. We’ve started toying with video (which turned out to be about an order of magnitude more difficult than expected), and we have a lot of ideas there under the auspice of Knee-Deep in Tech. I’ve had the profound honor of mentoring a handful of new and upcoming speakers this year as well, and I’ve been completely blown away by their results and ability for growth. To get even further, I will be starting to help out with the Swedish Power BI User group this autumn as well – things are most definitely going in the right direction.

I thought back to my first PASS Summit where these mythical creatures with “MVP” and “MCM” badges roamed the halls. I didn’t dare talk to them to begin with, but it gradually dawned on me that these people were just like me, only even more driven to share and help others grow. I decided right then and there that I too could play that game, and that I would do what little I could to spread the word, mentor people, speak and train as many as I possibly could. I immediately loved every opportunity to share knowledge and help people out.

After I came home I spent some time with my wife and played with the cats, so it wasn’t until 7 or 8 pm that I checked my email. In my inbox I found an email I had not expected – an email that congratulated me for being awarded Microsoft MVP for Data Platform. I’m now one of those “mythical” creatures I met so many ears ago. I’m now an MVP, but I’m also exactly the same guy I was last Sunday – nothing more, nothing less. I am humbled by this award and I can’t wait to use my newfound powers to do even more My mission remains.

To everyone who has helped me and encourage me along the way: thank you from the bottom of my heart.

Talk tech to me

I was invited by the PASS Professional Development Virtual Chapter to deliver “Talk tech to me – improving your technical presentation skills” on the 13th of September. The recording just went live and can be seen here: https://www.youtube.com/watch?v=srBe5Q-2xPE&feature=youtu.be but I have to warn sensitive viewers that there are some very disturbingly graphical dancing in there. I had a blast speaking and I’m very much hoping to get to do it again in the future!

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 of my home office – the place where I spend way too much time when I’m not at my day office (which is a fairly rare thing these days).

It’s a standard sit/stand desk from IKEA (one of the perks of being a Swede!) that I almost always have in the standing position. A tip I learned the hard way is that standing and working is hard on the feet – put a rug or similar underneath your feet and enjoy a distinct lack of discomfort! The stuff in the picture is as follows:

Logitech Spotlight wireless presenter

This i’ve already described in fair detail here: Logitech Spotlight -initial thoughts but the software has come a long way since then. I’ll do a followup in the near future as I’ve done som tweaks to the setup that has gotten the thing to the point where I’m quite happy with it.

Asus MB16AC external USB monitor

This was one of the more novelty purchases I’ve done, but in retrospect it turned out absolutely brilliant. I use it as a secondary screen where I keep my presenter view during speaking. Depending on if it is a remote session, a video (yes, I’m working on those) or a regular session at a conference, the secondary screen serves different purposes. It’s fairly lightweight, has a good resolution and is very versatile, but security people at airports have been known to be a bit confused as to why the “computer” won’t turn on…

Rode Procaster microphone

This mic I’ve been eyeing since I first started thinking of doing a podcast, but I’ve stayed away from it for several reasons. First, it requires a proper USB/XLR interface is a dynamic microphone. The old Yeti microphone I used to use to record the podcast has been exchanged for the AKG boom mic in my podcasting setup, but I always wanted a dynamic mic for the (in my opinion) better, richer sound. Unfortunately, this mic quickly showed me two issues that I was not aware of that I had – the first was that the (nonexistent) sound treatment of my room meant that the acoustics were … very bad, and that the mic required an insane amount of gain to get a usable signal out of. Fortunately I have a colleague who is a soundnerd of epic proportions, and he gave me a lot of help with choosing the most suitable sound treatment materials for my room. There is only so much one CAN do to a room in a rental apartment, but doing it is absolutely vital. More about that below.
The other problem with low gain and the subsequent noisy signal was overcome with a Cloudlifter (https://www.cloudmicrophones.com/cloudlifter-cl-1). It is, quite simply, a pre-amp that uses phantom power to give the signal a clean boost up to +25dB – and boy, what a boost it is. It completely changed the signal into a crisp, clear and strong signal that is absolutely awesome for podcasting, voiceovers, delivering sessions or anything else I might want to do with it.

Logitech BRIO 4K webcam

I had not given webcams much thought when I decided to get one. Fortunately, my partner in crime Simon had, and he was adamant that we get the Logitech BRIO 4k webcam, despite it being much more expensive than the other webcams out there. After using it for a while I can say I think I know why it is that much more expensive, as I find the picture to be absolutely excellent. Simon and I are working on doing webinars in the not-too-distant future, and these cameras are key to produce good video. I do find the built-in capability of removing the background live during a conversation to be more of a novelty than actually useful, though.

Yamaha MG10XU USB mixer

When I was working with my Pluralsight course I got a crash course in audio. As in – my audio was crap, and I needed to fix it – stat. My previous USB audio interface was pretty cheap and worked OK – or so I thought. When using proper headphones it became painfully obvious that the signal was simply too poor to be used, despite running it repeatedly through noise filters. I started to do research and stumbled over the Yamaha MG10XU mixer – a 10-channel mixer with more features you could easily shake a stick at. It’s more than I need, but it comes very highly recommended and after running it for a while I can conclude that my previous issues of noisy signal are gone. As it is an analog mixer I can tweak the sound to my preference, and it even has a built-in compressor so I won’t need to add any compression to the signal during the post processing step! I can easily add any other sound source to the mixer, apply effects and shunt the result straight into Audacity (my weapon of choice for recording audio). The mixer accepts XLR, RCA, phono plugs and probably a few other connectors I don’t even know about.
With the Cloudlifter I don’t have to crank the gain very high at all, but still enjoy a crystal clear signal. My iPad with a sound pad app is connected to one of the line inputs and one of the most amazing things – I get to hear what the mixer hears as I get monitor functionality with the MG10XU.

Software

Not pictured is the software I use, and that depends on what I am producing. For sound recording I’ve been using Audacity with great success. However, Audacity is missing one thing that I desperately need – the ability match audio volume between clips. I might have to look at Adobe Audition for that.
For video I’ve been using Camtasia. One of the many perks of being an MCT is free access to Camtasia, and while I like the tool I find some aspects of it … unrefined. The lack of keyboard shortcuts drive me nuts sometimes, and some things take forever. I’m thinking of going to Adobe Premiere, but Adobe is … quite more expensive.

I’ve used Google Hangouts for presentations, and there is one quirk that is going to be an issue for me going forward – you can’t see both the presentation AND the video of the presenter. As I’ll be doing some professional development sessions this fall, I need to *both* show the slides and the video as I’ll be talking about body language. Not quite decided on how to do things – maybe pre-record video and put it into the session.

Acoustic treatment

The room is you garden-variety 14-15 m2 room with one window, some closets and a hardwood floor. If you clap your hands in there, the echo hits you like a bus. Not a good starting position for recording good audio, where the idea is to reduce the bounce and echo to a minimum. There are several ways to do it, and my way lands firmly in the “not the worst way of doing it”, but definitely not nowhere near the “best” way either. The theory is … deep, to put it simply, but it all comes down to controlling sound bounce/reflection and echo using a combination of absorbing or diffusing materials. Since I’m only concerned with my voice and not full-spectrum music, I don’t have to go all out with huge bass traps and such, thus I’ve decided on a “middle of the road” approach with only acoustic foam. As the apartment is a rental apartment I couldn’t glue the foam to the walls (as is otherwise the way to do it), so I went online and got a kind of long tacks. They work well enough I can remove the foam with little or no damage to the foam itself, and the wall only look like I’ve had a poster or two there. I tried the 3M command strips as well, but they took both pieces of the foam AND the wallpaper with them when I tried to remove them. The cats loved to chew on them, though…

I’ve put some foam in front of my microphone to catch the sound of my voice, and I’ve put foam squares in the sloping ceiling behind me. I’ve also put foam on the other walls in hope of as much of the echos as I reasonably can. The corners are an issue (ask any acoustic engineer what they feel about corners!) but so far I’ve chosen to ignore them. For best effect I should have rotated the squares 90 degrees against each other, but for some reason my brain decided to forget this when I put them up.
The CNC machine and the R2D2 has nothing to do with the rest of this blog post, though 😛
Not shown is my rug. It’s a garden variety rug (also from IKEA!) on the floor to take care of the hard surface. You’d be surprised how much reflections come off the floor, and while I technically should take care of the ceiling as well, that is (at the moment) beyond my ambition.

And there  you have it – my home office as it stands right now. I’m working on a post that details my mobile podcasting setup as well, look for that in the near future!

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, 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. Said and done, we found each other and proceeded to pick up the car. Then we proceeded to repeatedly park our way to Germany as there was a lot of traffic. 2,5-3 hours later we arrived in the sleepy town of Lingen.

After the speaker dinner I found myself talking to the heavy hitters of the #SQLFamily, and they pointed out that with one track being newcomer only, there were 28 sessions in total. Then I was told that they had had over 200 session submissions. Take a second to consider that. It was almost a 1:10 ratio between the number of sessions submitted and the available slots. And here I was. I looked around and marvelled at the company I was in. I was chosen when so many people were not, and for the first time in a long, long time I felt a very real feeling of pressure. I was here, so many people were not, time to really, REALLY get my head in the game.

The event itself has been running for just a few years, growing from very few speakers and a small number of attendees, to a hard cap of 200 attendees and 35 sessions. New for this year was that one of the tracks was given over to newcomers – people that had never given a session at anything bigger than a usergroup or similar. This is simply a stroke of genius. The catch-22 of speaking is as simple to understand as it is depressing in practice – in order to be selected you must me a somewhat known entity. In order to get known as a good speaker, you need to – yeah, you guessed it – speak. The newcomers were, in a word, exceptional. With no exception, all of them performed absolutely great. I had the pleasure of attending a session on “soft skills” by Robert French, a gentleman from Scotland. I do a fair amount of speaker mentoring and presentation skill training, so I tend to keep track of small things that can be improved in pretty much every speaker I listen to, but Robert was … as close to absolutely brilliant as I’ve ever seen. I can’t remember the last time I left a session with such a feeling of disbelief due to having watched a master at work. I can’t wait to see him present again, and I sincerely hope the rest of the speaker circuit sit up and take notice, because this man can teach something to EVERYONE. Each of the speakers had one mentor assigned to them, and Robert was paired with the equally brilliant Cathrine Wilhelmsen, so he could not have been in better hands.

My session was the first one after lunch. At the same time as Grant Fritchey. Grant. Fritchey. Yes, THAT Grant Fritchey. The good thing with being on at the same time as Grant is that I wouldn’t be having him in the audience, but the other side of that coin is that I wouldn’t have anyone else either, as they’d all be at Grant (or any of the other three tracks). Now, Grant is an amazing guy – exceptionally skilled, always eager to help, kind, open, super-helpful, approachable and all the other good things, but he’s one of the very few people that genuinely scare me. The thought of having him in the audience would take some self-control to handle.
The session I presented this time was “The Force Awakens – Azure SQL Server for the on-prem DBA”, a new version of one of my original Azure sessions. All in all it went well, but I’ve got a list the length of my arm of things that I want to improve, and it is so interesting to see how easy it is to give advice to others and completely miss it yourself – I *know* I have a stoneface and a deadpan demeanor worthy of the highest echelons of the British royal family and that I *need* to loosen up. Did I? I’ll let you take a guess. It’s yet again on the list. At the top. In red. Underlined three times.

When the sessions were done for the day, the other two words of the SQLGrillen logo came into play – “beers” and “bratwurst”. The evening consisted of talking to all the amazing sponsors, attendees and speakers – all while eating excellent German sausages and grilled meat and drinking different kinds of German beers. In short – it was amazing. Social interaction ALWAYS lead to new friends, new insights and new ideas. At the surface “databases, beer and bratwurst” doesn’t sound like a very serious event, but this has been one of the best events I’ve ever had the pleasure to attend. During the evening I was asked if I would consider being a mentor for a new speaker at DataMinds in Belgium later this fall. I did not have to think about that for more than a second, as I would be absolutely honored to help out any way I can. And so it was that I became one of the newcomer mentors for DataMinds.

I would like to finish with a heartfelt “thank you” to William, Ben and all the other organizers, sponsors, speakers and attendees. This was one of the best run events I’ve ever had the pleasure to speak at, and definitely one of the most fun. I would like nothing more than to get to come back next year, even though the chances are slim. I’m so happy to have been given the opportunity, and I’m looking forward to the next opportunity to meet my #SQLFamily.

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 – 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.

After a month of peace and quiet I embarked on the first of three trips in a short time – I went to SQL Saturday Iceland. I’ve never been to Reykjavik and was completely blown away with the beauty of Iceland. I spent the whole ride from the airport in stunned silence as the craggy landscape rolled by. I had managed to find a rather … special place to live – turns out there is a surprisingly big difference between “hotel” and “hostel” – to my defense the hotel-turned-hostel was not very clear, but I got a room the size of a postage stamp an a shared bathroom down the hall. I’ll chalk it up as “authentic” and “an adventure”. Oh, and don’t get me started about the yellow buses in Iceland. Top tip: regardless of situation, they have the right of way. Period.
I had the last slot of the day in tough competition with Rob Sewell / Chrissy LeMaire and Dejan Sarka. Despite this I had some 35 attendees joining me for a wonderful discussion about best practices (boring is stable, stable is good – best practices in practice). Lots of great questions, insightful comments and laughs from the attendees.
I jumped on the bus to the airport at 0400 so I was a tad tired when I finally got back home.

After a quick recharge and change of underwear, I then went to Antwerp to speak at a completely new conference called ITProud. It is the brainchild of Peter de Tender, Adnan Hendricks and Christophe Lams. They’ve had some issues with marketing so the total turnout were some 80-ish attendees. The speaker lineup was solid and I had the distinct pleasure of spending quite some time with Fredrik Nilsson of Dell/EMC. I had a great time presenting Azure SQL Server – the cloud awakens to six eager attendees. The day after the conference Fredrik and me did Brussels, and after having spent several hours at the Royal museum of the armed forces and the comic strip museum we went back home.

By now the travel schedule was starting to take its toll (considering I *am* turning 40 in a week) but I had one stop to go. This week I went to Helsinki to speak at TechDays Finland. Again I had the last slot of the last day so I was very happily surprised to welcome some 40 attendees for my session SQL Server hates you(?) – what the DBAs never told the developers. It was a fast-paced and fun session, and I was told that I had surprised several of the attendees who immediately would go home and look over their environments. Despite the fact that devs and DBAs are two sides of the same coin, we still commit the very basic mistake of thinking that everyone knows what we do. When it comes default settings of SQL Server or to programming patterns that seem like a good idea, we can all benefit from much more conversations with our counterparts.

Now, after having been home for several hours and starting to digest this tour (and slowly starting to prepare for the UPCOMING trips) I again realize how lucky I am to be where I’m at. I get to speak about what I love, to people who are eager to learn and at the same time I get to spend time with and learn from all the other amazing speakers. Some days it feels that I’m the only non-MVP speaking on these topics but it is simply amazing how much talent is out there and how many opportunities there are for learning. I’m very much looking forward to some peace and quiet a few weeks, during I will work on the Global Azure Bootcamp conference me, Simon Binder and Johan Dahlbom will be organizing in Linköping, Sweden. At the time of this writing we’ve confirmed five(!) MVPs speaking, several great sessions AND a bit IoT workshop. We’re already at 70 attendees and we haven’t even started marketing the event yet. This will be amazing. Come join us!