Podcast episode 96

In this eighth episode from Microsoft Ignite, the gang sit down and talk about the highlights of the week, discuss what has been released and consider the future. Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes:

Podcast episode 95

In this seventh episode from Microsoft Ignite, the gang sit down with Kenny Lowe (@KennyLowe) to talk Azure Stack Hub and Azure Arc! Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes:

Podcast episode 94

In this sixth episode from Microsoft Ignite, Alexander sit down with Reza Rad (@Rad_Reza) of Power BI fame to talk about technical change, sleeping and Power BI! Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes:

Podcast episode 93

In this fifth episode from Microsoft Ignite, the trio sit down with Matthias Haas, the CTO of Igel, to talk about ancient memories, thin clients and edge computing! Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes:

Podcast episode 92

In this fourth episode from Microsoft Ignite, Simon and Toni sit down with Richard Hicks, the guy who wrote the book (literally!) on DirectAccess. Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes:

Podcast episode 91

In this third episode from Microsoft Ignite, the gang sit down with security legend Sami Laiho to talk Sami turning 40, security, azure blue penguins, Azure Arc! Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes:

Podcast episode 90

In this second episode from Microsoft Ignite, the gang sit down with Samuel Devasahayam (@MrADFS) of Microsoft and talk AD, ADFS and all things identity! Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes:

Podcast episode 89

In this first episode of Microsoft Ignite, Toni and Alexander met up with Andy Syrewicze of Altaro software to talk about the first day of Microsoft Ignite! Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes:

Presenting at Microsoft Ignite

I have the honor of presenting two sessions and hosting four podcast recordings at Microsoft Ignite:   BRK2099 – The cloud awakens: Azure SQL Server for the on-premises DBA Session time: Thursday November 7th, 0915-1000, OCCC W314 Have you ever asked what the cloud means for your database environment? Do you wonder if Azure is […]

Podcast episode 88

In this episode, Simon and Alexander met up at Microsoft TechDays in Stockholm and discussed the conference, our sessions, and what’s upcoming at Microsoft Ignite. Simon also managed to sneak some ConfigMgr stuff in here as well! Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes:

Podcast episode 87

In this episode, Alexander and Simon discuss the October Power BI Desktop update and touch on a few specific things, the newly released Windows 10 1909, the both of us speaking at Microsoft TechDays as well as some updates about Microsoft Ignite! Subscribe to us on Spotify, on iTunes or listen to the episode right […]

Podcast episode 86

In this hundredth(!) episode, Alexander, Simon and Toni sit down with Johan Dahlbom from Microsoft to talk about Azure Private Link. Other topics of the day are the Surface event, Power Platfom release wave 2 and the new Data Box Edge! Subscribe to us on Spotify, on iTunes or listen to the episode right here: […]

Podcast episode 85

Simon and Alexander have another chat with Anna Chu of Microsoft about all the hard work that go into making Microsoft Ignite! Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes: TyGraph’s Microsoft Ignite Session Browser

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

Concatenating columns in Power BI

Remember last time when we needed to keep track of certifications in a fictional company? We did the preliminary steps to create the base table for the table visual below in this blog post and we’ve come to the next hurdle: the column called “current”. If only we were using Excel Finally we can tackle […]

Podcast episode 84

During DATA:Scotland in September, Alexander sat down with Ida Bergum (Norwegian Data Platform MVP) and talked data journeys, Power BI Embedded and PowerApps! Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes:

Podcast episode 83

Alexander and Simon talk about zero-downtime patching of Azure SQL Server, Azure Private Link, the new preview of Windows 10 internet reset, Windows Virtual desktop in Europe and Microsoft Ignite! Subscribe to us on Spotify, on iTunes or listen to the episode right here:  Show notes: Windows 10 reset using the cloud Azure Private […]

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

Multiple keys in Power BI

Let’s say we need keep track of certifications in a fictional company. Management has requested a Power BI table that should list the region, the certification, the number of certifications, the goal and a concatenation of the number of certifications and the goal. The end goal is requested to look something like this: This should […]

Podcast episode 82

In this episode the trio discuss technological debt, the new custom format strings in Power BI, Azure AD Proxy for Power BI mobile, AI whisky, Toni’s new blog post and a new approach for Windows update and upgrades! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: Power […]

A poured glas of Mackmyra and the opened bottle

Mackmyra Intelligence – How AI blended technology and whisky

Before I begin – please always drink responsible. If you feel that you have an unhealthy alcohol consumption level or pattern, there´s help to get. This post is not written to encourage alcohol consumption nor has Mackmyra in any way had any influence on the text or the blog as such. This will be a […]

Domain Controller local admin password

Hey there. Toni here back with some thoughts on domain controllers and their local SAM database. You know, the thing that is disabled as soon as the server is promoted to a domain controller. This is something that is often forgotten about until it’s too late. This database is actually critical if something bad happens […]

T-SQL Tuesday #118 – SQL Server Fantasy Feature

This month’s T-SQL Tuesday invitation comes from Kevin Chant and is named “Your Fantasy SQL Feature”. Kevin writes: “My invitation to yourselves this month is to write a post about a fantasy SQL Server feature you’ve got in mind. It can be absolutely anything at all related to SQL Server. For example, it could be […]

New speaking hardware

At TechMentor in Seattle this summer I asked Aleksandar Nikolic, a fellow European MVP, about the tiny machine he used when presenting. It turned out that he had recently acquired a Surface Go, a Surface laptop roughly the same size as an iPad. Since buying it he had left his heavier machine at home, he […]

Podcast episode 81

In this episode the trio discuss the new Power BI mobile look, the new Guy in a Cube training courses, the Surface event in October, upcoming speaking engagements and Microsoft Ignite in general! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: Guy in a Cube Training

Windows Server 2019 gaming

Hey folks, long time no see. How are you doing? In Episode 80 of Kneedeepintech I briefly mentioned Windows Server and gaming in the same sentence. Now that I have had time to actually test it again I’d thought I would post my findings here. I have the Xbox 360 wired controllers that I’ve used […]

Podcast episode 80

In this first episode back from the (dead) vacation, the trio discuss if it is possible to turn Windows Server into a gaming rig, new exciting features in Power BI, the Azure Data Share service presently in preview, a bunch of fantastic new developments in InTune and EMS as well as share the news that […]

Knee-Deep at Ignite

A few days ago a dream came true for both Simon and me – we will both be speaking at Microsoft Ignite in November! We will be delivering breakout sessions, theater sessions, host unconference sessions AND record podcast episodes. I’ll be delivering an updated classic – “The Force Awakens – Azure SQL Server for the […]

Podcast episode 79

In this special vacation-mode episode, Alexander and Simon talk to Microsoft Tech Community Lead Anna Chu (@_achu) about the upcoming Microsoft Ignite conference in general and community content in particular! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: An old definition of session levels

Podcast episode 78

In this last(?) episode before summer Alexander and Toni talk about Bitcoin, Azure Data Lake integrating with Event Grid, Azure Premium Files going GA, Power BI dataflow updates, the new viewer role in Power BI, Azure Bastion, Microsoft Ignite: the Tour and Toni’s newfound toy: the ADRecon script! Subscribe to us on Spotify, on iTunes […]

Podcast episode 77

In this episode Alexander and Simon talk DataGrillen in Lingen, the new Raspberry Pi 4, “work spaces” in Power BI, new nifty features in Outlook, conditional access available for O365 Business and the release of Hyper-V server 2019! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: Raspberry […]

Podcast episode 76

In this episode the trio discuss some of the Power BI news coming out of Microsoft Business Applications Summit, on-prem MFA going the way of the dodo, Azure Bastion, new Windows 10 insider previews as well as the Salesforce aquisition of Tableu and Microsoft and Oracle working together! Subscribe to us on Spotify, on iTunes […]

Podcast episode 75

In this episode Alexander is still enjoying pneumonia, so Simon and Toni talk about news in Intune, the latest Windows Insider previews, more about 1903 and upcoming travels! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: What’s new in Intune for Education Latest Windows Insider Previews More […]

Podcast episode 74

In this episode Toni talk to Andy Syrewicze of Altaro Software about Azure, Windows, the Windows Server Summit, the value of conferences in general and Microsoft Ignite 2019 in particular! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes:

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

Podcast episode 73

In this unreasonably full episode Simon and Toni cover that the Ignite registration is open, Windows Server summit 2019, known issues with Windows 10 1903, news in OneDrive, Intune and ConfigMgr, and finally news from Citrix! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: Windows 10 1903 […]

Podcast episode 72

In this episode Simon and Alexander try to sum up announcements from Microsoft Build, news from Power BI AND tidbits from the internet. We talk about the Microsoft Build keynote, SQL Server Edge, Azure SQL Server serverless, exciting news for Power BI, the upcoming preview of Teams transcription, MBAM going the way of the dodo […]

True north for the easily distracted

Podcast episode 71

In this episode we cover the rumors of upcoming Swedish Azure datacenters, running vmWare on Azure, updates to the Power BI gateway and news from Azure! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes:

SQL Saturday #851 – A new thing in town…

“Why don’t we have a SQL Saturday in Stockholm?” a friend asked me a few years ago. “I honestly don’t know”, was my answer. “There is a lot of people in Stockholm, but for some reason they don’t seem to be able to organize one. There is one in Gothenburg that’s been working fine for […]

Podcast episode 70

In this episode we officially introduce Toni, we talk about news in Power BI, unexpected radio experiences, news in Intune, Windows Admin Center, and we rant a bit about upcoming MDM changes in iOS 12. Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes:

Podcast episode 69

In this episode we talk about jetlag, Star Wars Celebration IX in Chicago, the upcoming Microsoft Ignite: the tour in Stockholm, the Global Azure Bootcamp in Linköping, Power BI April updates as well as the new Surface Hub 2S! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: […]

Podcast episode 68

In this episode we talk about a few of the new Power BI features, the fact that Windows 10 now has over 800 million users, the Global Azure Bootcamp, Windows virtual desktop and a quick recap of the MVP summit! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show […]

Podcast episode 67

In this episode we sit down with fellow MVP Matouš Rokos (MVP Azure) and talk about infrastructure as code, keeping up with tech and knowledge transfer! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: Matouš Rokos on Twitter

Kerberos fails with CIFS using AOVPN

Hey. Today I want to talk about an interesting case that involves Kerberos, Always On VPN and access to CIFS. A customer has recently deployed Always on VPN in their infrastructure. Most clients worked well with that but a few had mixed issues with old VPN clients installed on some machines. Cisco AnyConnect usually worked […]

Upgrading the lab

Good day to you. Today I’ve done a little write-up about my home lab equipment. I was noticing a few slowdowns once I got around 10 vm’s running on my old “server”, which was an older gen Intel E3 1240 series CPU running 32Gb of DDR3 RAM, SSD cache and spinning HDDs for mass storage. […]

A Swede went to Finland, spoke and learned

A couple of weeks ago now, I was focused on preparing for, and speaking at, Techdays in Helsinki, Finland. I was really happy to be accepted for the conference after Alexander spoke there last year and praised the arrangement. I was also very happy that Techdays choose to accept my session on Windows Virtual Desktop, […]

Powershell for printer creation, with bonus feature.

Hey, the Finn here again with another random post. A client reached out to me since they are in the process of switching print servers. They have a lot of printers, to say the least. They are all managed manually and they felt that they would like avoid the hassle of creating all the print […]

Azure ASM (Classic) and migrating to ARM

Hey, Toni here again. Some customers are still stuck on using Azure classic for their deployment. Microsoft has done a lot of work for many years to convince everyone to move over to Azure Resource Manager (ARM) model and with good success as well. Did you know that they offer good tools (well scripts actually) […]

Podcast episode 66

In this episode we talk new beta features from SQL Server 2019 CTP 2.3, thoughts from SQLBits, news from Intune and ConfigMgr as well as some very strange SQL Server behavior! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: Analysis Services updates in CTP 2.3 Intune news […]

Windows Admin Center certificate

Hey there. The Finn here with another little quick update. This time on Windows Admin Center and certificates. You are using Windows Admin Center, right? It’s good stuff. You like good stuff, right? Self-signed is the default option, but man is that an ugly way to go. Here is how you update your Windows Admin […]

Azure vNet peering and why it’s great

Hi, my name is Toni aka “The Finn” from some guest appearances on the show. I was invited to write some stuff here so here goes. I have recently been doing some Azure work and want to share some of that with you. Building your applications and infrastructure in multiple Azure networks or even regions […]

Podcast episode 65

In this episode we talk HoloLens 2, Azure Kinect, revisiting best practices, upcoming speaking, Simon shares a a rant on Windows Virtual Desktop opinions and Toni Holopainen (@MrBlackSwe) joins the crew! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: HoloLens 2 introduction CNet HoloLens 2 introduction article […]

Speaking at SQL BITS!

I’m going to SQL BITS! Not only going, but also speaking – I’m very excited to be delivering “DAX for the SQL developer” at 1420 in a room called “Snake Eyes”. What could possibly go wrong? This is my first time at BITS, both as a speaker and an attendee, and I am very much […]

Podcast episode 64

In the fourth episode of 2019, a.k.a “get out of the car”, we talk high availability as a concept, false security with 8 characters, our latest travels and deploying Power BI using InTune! Subscribe to us on Spotify, on iTunes or listen to the episode right here:

Deploying and Managing Power BI using Microsoft Intune

This post is written on request by parts of the Power BI community. I’ve really enjoyed writing it, not because it’s a deep dive, because it isn’t. I’ve enjoyed writing it because this post will show what you can do with Intune and Windows 10, which will help another strong community to grow and make […]

Podcast episode 63

In the third episode of 2019, a.k.a “kränkt”, we talk about the new Power BI February update, the both of us teaching different subjects, The Accenture-Avanade-Microsoft partnership, and what’s new in ConfigMgr! Subscribe to us on Spotify, on iTunes or listen to the episode right here: Show notes: Power BI Desktop February update Microsoft-Accenture-Avanade co-op […]

Heading to Norway and NICCONF

Tomorrow I’m heading to Oslo and the Nordic Infrastructure Conference (NICCONF) – one of my favorite conferences! I’ve been invited to deliver three sessions this year: “The force awakens – Azure SQL Server for the on-prem DBA” which is an introduction to Azure SQL Server in its different shapes, “Azure Machine Learning for the absolute […]

Podcast episode 62

In the third episode of 2019 (a.k.a “into the mancold”) we talk about email-based subscriptions in Power BI, the Power BI service high availability FAQ, Joe Sack interviewed on SQL Down Under, exciting news about Windows Managed Desktop, Desktop App Assure going GA and a few tidbits from InTune! Subscribe to us on Spotify, on […]

Podcast episode 61

In the second episode of 2019 we talk about thin clients, Simon keynoting in Germany and gallivanting in Ireland, and news with Power BI! Subscribe to us on Spotify, iTunes or listen to the episode right here:

Back on the road

The first month of the new year is more than half way done. Time flies, but I’ve already had time to go to SQL Saturday Linz in beautiful Austria. I delivered “Headless chicken – calming the sysadmin-turned-DBA” to a full room, and it was 60 minutes of fun, shenanigans and failing to use a flipchart […]

Podcast episode 60

In the first episode of the year, we outline some of our plans for 2019, our upcoming schedule and talk a bit about some extra special Power BI and Windows news that caught our eyes since the last time! Subscribe to us on Spotify or listen to the episode right here:

Podcast episode 59

In episode 59, the last episode of 2018, a.k.a “flash from clear sky”, we look back on what the year has brought. This includes the evolution of Power BI, Microsoft acquisitions, Microsoft Virtual Desktop, Intune AppDeployment, us becoming MVPs and the future for the blog and podcast! Subscribe to us on Spotify or listen to […]

Podcast episode 58

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: https://open.spotify.com/show/1AwQDgaycKwSzfGRLAHLLJ or play right here:   Show notes: Marco Russo – understanding numeric data type conversions […]