Photo by @alex_andrews / Unsplash.com

…But I like email!

People – and consultants, a bit like myself – often tell unequivocally on social media and through flashy PowerPoints that email is dead. You must move on. Slack and Microsoft Teams and similar enterprise social tools are the future – a modern way for collaboration and that’s where real work happens now. Okay. I understand all that. I’ve done my fair share of billable work… Read More »…But I like email!
Image by Hannah Joshua @hannahjoshua / Unsplash.com

Mastering Azure CLI

  • Azure
I grew up with Perl, tcsh, bash, sh, awk, sed, grep, pico, vi, command.com and cmd.exe. Building scripts, batch files and little automations here and there was the norm for me and many others of that era. I’m especially proud for a set of .BAT files and VBScripts that connected to one of the very first Logitech USB webcams to retrieve a near real-time image… Read More »Mastering Azure CLI
Photo by @russn_fckr / Unsplash.com

Anonymizing and masking sensitive data in SQL databases before migrating to Azure SQL

Many companies I interact with have expressed an interest in migrating their legacy SQL Server databases to Azure. Typically this is due to End of Life for SQL Server 2008 (and 2008 R2) and other times it’s a desire to perform reporting and analytics on existing data in the cloud. (I wrote about migrating to Azure SQL previously here) Mostly this is all documented nicely… Read More »Anonymizing and masking sensitive data in SQL databases before migrating to Azure SQL
Photo by Greg Bakker @gregbakker / Unsplash.com

Be better – or how to consistently succeed as a techie

I’ve had this post — or rather just the title — in my blog as a draft for over a year. Today, I decided it’s time to put my money where my mouth by writing it and making it public. First, some clarification. My intention is not to brag about my professional career. My intention is to provide useful guidance I’ve learned during the course… Read More »Be better – or how to consistently succeed as a techie
Photo by Dan Gold @danielcgold / Unsplash.com

Tracking, resolving, storing and presenting AKA.MS short links from social media using Serverless capabilities in Azure

I think I’ve written once or twice I’m a great fan of building Proof of Concepts and prototypes. This allows me to rapidly learn without fear or risk of failing in front of an important customer. And all customers who pay for your time are important, of course. I’ve long admired the fantastic AKA.MS short links service Microsoft has internally created for their employees. Or… Read More »Tracking, resolving, storing and presenting AKA.MS short links from social media using Serverless capabilities in Azure
Image by @rawpixel / Unsplash.com

Building a custom connector for Power BI that supports OAuth2 to visualize my wellness data

In my previous blog post, I wrote about the Oura Ring and how it tracks my wellness and activities. As part of the service Oura provides there’s also a comprehensive API that can be leveraged for your own purposes. As the data that is being tracked is very personal (“hmm, I wonder why Jussi is being active at 3:23 am.. oh he’s feeding the baby”),… Read More »Building a custom connector for Power BI that supports OAuth2 to visualize my wellness data
Image by Danielle MacInnes @dsmacinnes / Unsplash.com

Living with Oura Ring – the smart way to track wellness and activity

  • Gadgets
Late last year I decided to place an order for a Oura Ring, the smart wellness and activity tracking ring from the Finnish startup. It took a few months to arrive, as they seem to be in high demand. While I’m writing this Oura’s site has a banner saying that orders placed today will be delivered by May. Impressive! I had two intentions for my… Read More »Living with Oura Ring – the smart way to track wellness and activity
Photo by Arya Meher @aryamehe / Unsplash.com

Fun with Azure Functions: Building a lookup tool for Azure AD tenant IDs

  • Azure
I sometimes find myself struggling with a technical issue that I just can’t seem to resolve in a timely manner. Over the years I’ve learned that once you’ve spent maybe 15 to 30 minutes troubleshooting without any noticeable progress, there’s only two things that will help you: a huge cup of fresh coffee or working on something else for a while. Some people claim asking… Read More »Fun with Azure Functions: Building a lookup tool for Azure AD tenant IDs
Photo by Rubén Bagüés @rubavi78 / Unsplash.com

One password to rule them all: Migrating to 1Password from KeePass and text files

I can’t quite remember when I started using a password manager, or which password manager it was at the time. As an IT Pro I’ve used everything from text files stored on Windows Desktop to encrypted Excel files to post-it notes to reusing the same password (“R3member1”, “R3m3mber2”..) to forgetting my password and resetting it. Repeatedly. I left Microsoft exactly 10 years ago, and we… Read More »One password to rule them all: Migrating to 1Password from KeePass and text files
Image by Samuel Zeller @samuelzeller / Unsplash.com

Migrating SQL Server 2008 databases to Azure SQL

“This is a quick one”, I thought. A customer asked me to have a look at their old CRM environment, that was running in a local physical server in their datacenter. The plan was to decommission the server, but rescue the CRM database. I knew I could lift-and-shift the database or databases to Azure SQL quite easily. This post walks through my experience and some… Read More »Migrating SQL Server 2008 databases to Azure SQL