Speaking at Data Platform Discovery Day

I just had an absolute blast presenting at the Data Platform Discovery Days – both the European and the US edition! For the US edition I presented “Azure Machine Learning for the Absolute Beginner”, a session looking at machine learning in general, walking through Azure Machine Learning and giving several examples of machine learning in action – in both expected and unexpected places! The European edition asked for “Building an Empire – Implementing Power BI Step by Step”, a session on Power BI, datasets and dataflows.  I was asked for my slide decks, and I’ve uploaded them here:



Powershell and DHCP Domain Search Suffix Order

Hey there. The Finn is back after a long time, this time with a Domain Search Suffix Order issue. I ran into this issue at my new place of work where we have multiple platforms like Windows 10, MacOs and even Linux together with multiple domain names.
Traditionally you would just use a group policy to set the search lists on domain joined boxes. Problem solved, well not here because Linux and MacOs don’t do GPO’s. This pushed me to find an alternative that works cross-platform as well. Welcome to the DHCP option 119.
Windows Server DHCP does not include that option out-of-the-box, so you’ll have to add that manually prior to running the script.
Run dhcp mmc, right click on IPv4 under Servername and select “Set predefined options…”
Click Add, give it a descriptive name. Click on the “Array” checkbox, type in 119 in the Code-field and finish with “OK”.
Now you are ready to run my script below. Kudos to the original author for the hex-conversion. Made my day a lot easier. Why reinvent something that works?
My additions just gets all of your existing scopes and adds the 119 option values. Or you can also do a single scope at a time if needed. Remember to replicate your scopes if you are running in DHCP-failover mode since that is not done automatically.
Now all of your supported devices should work with this option. Not all OS’es actually request this option so your mileage might wary. Windows 10 as of 1809 should be fine. MacOs 10.6 (if memory serves) and Ubuntu from ages ago.
I hope you liked this post and got some use out of it. I am not sure how common this issue is but here is a verified solution for problem with distributing the Domain suffix search list to devices other than Windows.
set-option-119 rename to .ps1

New adventures – with TrueSec

Today is the first day of my new adventure. As of today, I´ve joined TrueSec Infrastructure and will be taking on the role as Principal Technical Architect. I will be focusing on Microsoft 365 and other technologies related to it.

Its really a dream come true, I still do remember my first user group that I attended many years ago. Johan Arwidmark was one of the speakers, and he and many of my new colleagues at TrueSec have in different ways been idols and people you always have been able to turn to.

That´s of course one of my goals as well, to become a trusted advisor for both customers and the community. I do see TrueSec as a great company that will enable me to achieve that. They will also be able to provide me with opportunities to work with some of the worlds most interesting and, in a good way, challenging companies and organizations.

From today, Ill be working globally and ill of course still be doing as many community activities as possible. In the coming months I´m speaking at Techdays Sweden, Microsoft Ignite, Experts Live Europe. Looking into the future I´m one of the featured speakers at Igel Disrupt EMEA in February.

Me, Alexander and Toni will continue the adventure we have set out on with Knee-Deep in Tech, that wont change. We will still aim to publish weekly podcasts, blogpost and be active on social media.

On top of that, I know that TrueSec have a few things planned for me – so stay tuned and reach out if there´s anything I can help you out with. You can reach me at Twitter, LinkedIn and of course via e-mail.

Speaking at Experts Live in Prague!

It´s a late announcement, but I´m happy to tell the world that I´ve been accepted to speak at Experts Live in Prague November 20-22!

It will be my first Experts Live, but from what I´ve already have experienced in terms of organization and how they´ve have handled me as a speaker – I´m VERY excited!

Ill be presenting a session on Windows Virtual Desktop and how it integrates and enhances (and gets enhanced) by Microsoft 365. A session I´ve presented a number of times and that always gets the attendees to think in new directions and understands how WVD is democratizing End-User Computing.

I´m of course happy that Alexander have been accepted as well and will present two sessions as well.

Other than that I´m of course looking forward to the keynote with Joey Snow and Rick Claus of Patch & Switch fame as well as sessions from Marius Skovli and Alexander Benoit among others! You can check out all the sessions in the session catalogue which you can find here:


But don’t forget what conferences are all about, its learning and connecting. Therefore it will be great fun to spend so much time socializing with all the speakers and attendees during the different networking events. So take the opportunity to reach out to me before or during the event. Perhaps we´ll even invite you to be a part of our Knee Deep in Tech podcast? 😀

Looking forward to seeing you in Prague!

Supporting the #SQLFamily

Take a look at the map above. Up to the right you see Linköping, Sweden – where I’m based. To the left you see Austin, Texas – a town 5.215 miles away. I’ve never been to Austin. Heck, I’ve never even been to Texas! So how is this relevant?

Angela D. Tidwell, a budding data scientist and a good friend of mine from the States is one of the organizers of SQL Saturday #890 in Austin, Texas. She reached out on Twitter the other day and asked me if I wanted to sponsor the event.  They just opened up a “personal/blog” sponsor option. For $25 you get your logo and a link to your site among the other sponsors. I didn’t have to think about this very long at all. As you all know well by now, community is one of my main drivers. SQL Saturdays have been the bedrock of the SQL community for years, and many a speaker has started their careers in one of them. I started my speaking career at one. Therefore I jumped at the opportunity to help this event out.

What are SQL Saturdays?

Many SQL Saturdays are pretty small with less than 100 attendees. Some of the events have grown to five times that – or more. These events are completely free to attend and feature everything from local speakers to people from literally the other side of the globe . As they are free, many people who would otherwise not go to any training find a SQL Saturday to be a major boost to their technical career.

Who speak there?

Some of the speakers are known only at their own companies. Some of them are considered international rockstars. Well, at a SQL Saturday everyone is pretty much an equal.  It is an amazing opportunity to get training, meet speakers and – most important of all – network with your fellow #SQLFamily.

So what is the issue?

Unfortunately, running a free event is neither easy nor cheap. The venue costs money. Just transporting all the stuff TO the venue costs money. Therefore they rely on sponsors, and anyone who has tried organizing an event of any size knows how difficult securing sponsorship can be. Hence I’m happy to have been able to contribute to SQL Saturday Austin, even if I can’t make it there in person.